Great content, thank you. Is it possible to create a bidirectional component with st.html ? I'm trying to make an image button and get the onclick value in python.
@saisaigraph1631Күн бұрын
not only educative but also entertaining + fun... Thank you very much Fanilo
@andfanilo21 сағат бұрын
Thank you for the kind words 🙂 hope to see you on the next video!
@maloukemallouke9735Күн бұрын
Excellent i love it.
@andfaniloКүн бұрын
Thanks for watching! If didn’t yet, check out my latest video too, it is another way of doing Google sheets Streamlit dashboard but in the same video style 😁
@DavidOden-kk8nm2 күн бұрын
Thank you @Fanilo❤
@andfaniloКүн бұрын
Thanks for watching, see you on the next one :)
@emanueljordan3 күн бұрын
Hi, friend! If you just want to read data from Google Sheets, there’s an easy way to do it: - Open your spreadsheet in Sheets - Click on File - Click on Share, then ‘Publish to web’ - You can choose the entire document or just one sheet - It defaults to 'Web page', but you can easily change it to CSV - Click on "Publish" This will generate a link directly to the spreadsheet data. Just read it in Pandas[pd.read_csv('link')] and you’re good to go. This is just a tip from a 'Data From Beginner' who spent a lot of time figuring out how to connect with GSheets. Your tutorial was amazing, by the way! It gave me some great ideas! I’ll definitely try them out! Thanks!
@andfanilo19 сағат бұрын
Thanks for sharing! Yeah I saw this trick while browsing through the Google Workspace for Developers and thought there were so many ways to interact with Google APIs eheh. Do you know if it's possible to bake authentication into this webpage, just so not everyone who discovers the link has access to it?
@by_westy3 күн бұрын
how did you open streamlit preview in VS code
@andfanilo20 сағат бұрын
Actually it's just VSCode and a web browser side-by-side, but I configured VSCode margins so the topbar for both windows match for the screen recording ( gist.github.com/andfanilo/ae99aed9c454a46c1dbfe6a0b9fa0012 to check my config)
@thebudaxcorporate97633 күн бұрын
awesome
@andfanilo3 күн бұрын
Thanks for watching, see you on the next one :)
@kareemrasheedbabatunde90264 күн бұрын
You finally did it
@andfaniloКүн бұрын
It was a long ride! Hope you enjoyed it :) see you on the next one!
@gabrr4 күн бұрын
Amazing, stuff man!
@andfanilo4 күн бұрын
Thanks for watching, see you on the next one :)
@ici63084 күн бұрын
This is the game changer.
@andfanilo4 күн бұрын
Thanks for watching, see you on the next one :)
@maivish1005 күн бұрын
Hi Fanilo, Thanks for sharing insight informations. Can we can change column header background color in ST. Kindly reply and how to do.(st.dataframe)
@theexposer94835 күн бұрын
Streamlit is data hobbyist platform nothing more, it lacks basic framework for an application which is designed to do serious stuff. It can never become a platform to produce enterprise grade application. It’s very heavy while running, practically struggling when you are trying to do some serious work, very often st.write which one of the basic component of platform starts throwing error. I thank you for sharing the truth to the developer community so that they know the Streamlit platform limitation.
@zkiyyeller35255 күн бұрын
Awesome Video which tts did you use for this? for the tldr? 1176 seconds
@andfanilo5 күн бұрын
Hello, thanks for watching! It was probably ElevenLabs for this video 🤔 ( elevenlabs.io/ )
@JuanSuarez-ei7hv6 күн бұрын
Great!!!
@andfanilo5 күн бұрын
Thanks for watching! See you on the next one :)
@tylerjrichards_ds6 күн бұрын
I really love the sparklines, one of my favorite features. And I HATE how hard it is still to read / write with google sheets, st.connection makes it much easier but on the google side it still is not super easy
@andfanilo5 күн бұрын
Yeah, I find this service account creation demanding for new users 😅 that could be automated maybe, like with Terraform or a command to paste into Google Shell Sparklines ftw, I initially wanted to use the st-aggrid ones but they require an enterprise license so yay for Streamlit Sparklines! Thanks for watching :)
6 күн бұрын
Awesome tutorial as always... I've used CSS too but that :has selector is a really great trick... Thanks for sharing and thanks a lot for the mention of my dashboard about Poverty ❤
@andfanilo5 күн бұрын
Credits to arnaudmiribel.github.io/streamlit-extras/extras/stylable_container/ for the initial idea, plus st.html makes it a little easier! And I did already tell you your dashboard was the initial trigger to this video? So thanks for building/sharing it 😊 looking for your next dashboard!
5 күн бұрын
@@andfanilo I couldn't feel more proud, thank you for your support, I have learned a lot from your videos, I'm really glad to be useful for you and to give something back.
@iNEEL6 күн бұрын
Great work, Fanilo. This video is going to be a goldmine for all streamlit users!
@andfanilo6 күн бұрын
💪 let's hope so! thanks for the support :)
@smiley32396 күн бұрын
can i say i love you??? cause damn dude, your explanation is perfect!!!!
@andfanilo6 күн бұрын
Well thank you for the support I'm very grateful :) I hope you watch more then, I even just released a new video!
@ruidinis756 күн бұрын
that is great
@andfanilo6 күн бұрын
Thanks for watching, see you on the next one!
@trungphamquang57016 күн бұрын
I love new trick with CSS :D
@andfanilo6 күн бұрын
Eheh, this is actually a customized version of arnaudmiribel.github.io/streamlit-extras/extras/stylable_container/ made simpler with st.html. I figured it would be better to explain it so people get to learn CSS (sometimes I think my channel will be rebranded "CSS for data scientists"!) Until one day we get custom classes on widgets maybe one day 🙃
@abdielgoni56906 күн бұрын
What is the difference beetwen pyairbyte and st gsheet connection?
@andfanilo6 күн бұрын
gsheets-connection is an official st.connection ( docs.streamlit.io/develop/api-reference/connections/st.connection ) wrapper around GSpread to connect to GSheets. The library puts the connection and data in Streamlit cache for you so you only have to query it. It's a Streamlit-specific solution. Pyairbyte is a Python library for Airbyte ( airbyte.com/ ) that manages the connection and data download to a lot of different databases like MySQL, GSheets (which I use in the video) or BigQuery. It comes with more features than gsheets-connection like caching data in DuckDB, or fetching datasets already managed in a Cloud instance of Airbyte. If you work in a company that uses Airbyte to connect and manage multiple data sources, chances are you can directly download or refresh data from their self-hosted Airbyte platform. It's a popular solution amongst data engineers, not just specifically Streamlit. What I did in this tutorial is basically recreate a st.connection gsheet pyairbyte, without explicitly calling it st pyairbyte gsheet connection...
@abdielgoni56906 күн бұрын
Ahh i see. Thank you for the comprehensive explanation
@aleman123456 күн бұрын
3 minutes after release, new record!
@andfanilo6 күн бұрын
Ahah you're the first :D congrats!
@rodrigobogado6537 күн бұрын
It's 3 in the morning here and every time I put on streamlit I get fanilo hahahaha. Thanks for the videos bro!
@andfanilo7 күн бұрын
😆 Aren't my videos too "exciting" to get you to sleep?! Thanks for the support as always, very appreciated :) also there's a new one coming tomorrow eheh
@rodrigobogado6535 күн бұрын
@@andfanilo Very good videos, I was just looking at the backgrounds and how to make something more personalized, thanks man
@pedrotiagobh8 күн бұрын
Hi, I had this error below while I was trying to create the .exe file from my streamlit code: Error: The entrypoint file "app.py" is not included in the bundled files. Can someone help me?
@andfanilo7 күн бұрын
I haven't tried stlite in a while but from github.com/whitphx/stlite/tree/main/packages/desktop there are some new configurations options to add to point to the entrypoiny.. But the honest best way would be to head to github.com/whitphx/stlite/issues if it still doesn't work, the author is very helpful there!
@Sonntagssoziologe8 күн бұрын
The finale was so exciting that I need to recover first. Don't you want to be a Marvel screenwriter?
@andfanilo7 күн бұрын
🙃 Maybe that was my dream job all along Have you watched my Epic Book Trailer ( kzbin.info/www/bejne/rqbFgmOiqM6JapY ) ? I feel this one was the most intense I produced 😆
@rajeshbhusal8 күн бұрын
Your videos are so funny man - I love them!
@andfanilo7 күн бұрын
Glad you like them! As long as you keep watching I'll keep doing this fun cinematic style 😉
@greciaguerrero2189 күн бұрын
Hey, Fanilo, great video!! It worked for me as long as the packages are supported by Pyodide. Unfortunately, in my case Pyodbc isn't :( I'm looking for another way to generate an exe Any ideas are very welcome :D
@andfanilo7 күн бұрын
Hey thanks for watching! Yeah unfortunately it's not easy to find which packages are not supported by Pyodide until you actually try it. There is a long post around PyInstaller that I've never been able to make work of ( discuss.streamlit.io/t/using-pyinstaller-or-similar-to-create-an-executable/902 ) and some Electron based tests here: github.com/streamlit/streamlit/issues/1370#issuecomment-1272624057 But alas it's a hard to topic to navigate...so no one fits all answer for now 😐
@Jikdor9 күн бұрын
Well that was disappointing. I just discovered Streamlit and it seemed amazing, it's a shame it has those limitations.