I Keep Breaking My Python Setup
5:08
Пікірлер
@SaifUlislam-zq2qn
@SaifUlislam-zq2qn 9 сағат бұрын
Don't learn streamlit, instead learn htmx
@WhylerGame
@WhylerGame 18 сағат бұрын
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
@saisaigraph1631 Күн бұрын
not only educative but also entertaining + fun... Thank you very much Fanilo
@andfanilo
@andfanilo 21 сағат бұрын
Thank you for the kind words 🙂 hope to see you on the next video!
@maloukemallouke9735
@maloukemallouke9735 Күн бұрын
Excellent i love it.
@andfanilo
@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-kk8nm
@DavidOden-kk8nm 2 күн бұрын
Thank you @Fanilo❤
@andfanilo
@andfanilo Күн бұрын
Thanks for watching, see you on the next one :)
@emanueljordan
@emanueljordan 3 күн бұрын
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!
@andfanilo
@andfanilo 19 сағат бұрын
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_westy
@by_westy 3 күн бұрын
how did you open streamlit preview in VS code
@andfanilo
@andfanilo 20 сағат бұрын
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)
@thebudaxcorporate9763
@thebudaxcorporate9763 3 күн бұрын
awesome
@andfanilo
@andfanilo 3 күн бұрын
Thanks for watching, see you on the next one :)
@kareemrasheedbabatunde9026
@kareemrasheedbabatunde9026 4 күн бұрын
You finally did it
@andfanilo
@andfanilo Күн бұрын
It was a long ride! Hope you enjoyed it :) see you on the next one!
@gabrr
@gabrr 4 күн бұрын
Amazing, stuff man!
@andfanilo
@andfanilo 4 күн бұрын
Thanks for watching, see you on the next one :)
@ici6308
@ici6308 4 күн бұрын
This is the game changer.
@andfanilo
@andfanilo 4 күн бұрын
Thanks for watching, see you on the next one :)
@maivish100
@maivish100 5 күн бұрын
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)
@theexposer9483
@theexposer9483 5 күн бұрын
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.
@zkiyyeller3525
@zkiyyeller3525 5 күн бұрын
Awesome Video which tts did you use for this? for the tldr? 1176 seconds
@andfanilo
@andfanilo 5 күн бұрын
Hello, thanks for watching! It was probably ElevenLabs for this video 🤔 ( elevenlabs.io/ )
@JuanSuarez-ei7hv
@JuanSuarez-ei7hv 6 күн бұрын
Great!!!
@andfanilo
@andfanilo 5 күн бұрын
Thanks for watching! See you on the next one :)
@tylerjrichards_ds
@tylerjrichards_ds 6 күн бұрын
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
@andfanilo
@andfanilo 5 күн бұрын
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 ❤
@andfanilo
@andfanilo 5 күн бұрын
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.
@iNEEL
@iNEEL 6 күн бұрын
Great work, Fanilo. This video is going to be a goldmine for all streamlit users!
@andfanilo
@andfanilo 6 күн бұрын
💪 let's hope so! thanks for the support :)
@smiley3239
@smiley3239 6 күн бұрын
can i say i love you??? cause damn dude, your explanation is perfect!!!!
@andfanilo
@andfanilo 6 күн бұрын
Well thank you for the support I'm very grateful :) I hope you watch more then, I even just released a new video!
@ruidinis75
@ruidinis75 6 күн бұрын
that is great
@andfanilo
@andfanilo 6 күн бұрын
Thanks for watching, see you on the next one!
@trungphamquang5701
@trungphamquang5701 6 күн бұрын
I love new trick with CSS :D
@andfanilo
@andfanilo 6 күн бұрын
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 🙃
@abdielgoni5690
@abdielgoni5690 6 күн бұрын
What is the difference beetwen pyairbyte and st gsheet connection?
@andfanilo
@andfanilo 6 күн бұрын
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...
@abdielgoni5690
@abdielgoni5690 6 күн бұрын
Ahh i see. Thank you for the comprehensive explanation
@aleman12345
@aleman12345 6 күн бұрын
3 minutes after release, new record!
@andfanilo
@andfanilo 6 күн бұрын
Ahah you're the first :D congrats!
@rodrigobogado653
@rodrigobogado653 7 күн бұрын
It's 3 in the morning here and every time I put on streamlit I get fanilo hahahaha. Thanks for the videos bro!
@andfanilo
@andfanilo 7 күн бұрын
😆 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
@rodrigobogado653
@rodrigobogado653 5 күн бұрын
@@andfanilo Very good videos, I was just looking at the backgrounds and how to make something more personalized, thanks man
@pedrotiagobh
@pedrotiagobh 8 күн бұрын
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?
@andfanilo
@andfanilo 7 күн бұрын
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!
@Sonntagssoziologe
@Sonntagssoziologe 8 күн бұрын
The finale was so exciting that I need to recover first. Don't you want to be a Marvel screenwriter?
@andfanilo
@andfanilo 7 күн бұрын
🙃 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 😆
@rajeshbhusal
@rajeshbhusal 8 күн бұрын
Your videos are so funny man - I love them!
@andfanilo
@andfanilo 7 күн бұрын
Glad you like them! As long as you keep watching I'll keep doing this fun cinematic style 😉
@greciaguerrero218
@greciaguerrero218 9 күн бұрын
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
@andfanilo
@andfanilo 7 күн бұрын
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 😐
@Jikdor
@Jikdor 9 күн бұрын
Well that was disappointing. I just discovered Streamlit and it seemed amazing, it's a shame it has those limitations.