Turn Your Excel File Into A Web App With Python (fast & easy) | Streamlit Tutorial

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this tutorial, I am going to show you how to convert Excel Files into a Web Application by using the Python Library Streamlit. The beauty of Streamlit is that you can create web applications directly in Python, without needing to know HTML, CSS, or JavaScript. The Web App is fully interactive and will be updated, whenever you make changes in the Excel file.

🌍 𝗟𝗜𝗡𝗞𝗦:

Deploy your Streamlit Application to Heroku for free:

Streamlit Documentation & App Gallery:

✅ Chapters:
0:00 Introduction
1:20 [Setup] Python Libraries
2:12 ‘Hello World’ in Streamlit
3:41 Insert Dataframe in Streamlit
5:13 Insert Pie Chart in Streamlit
6:13 Insert Images in Streamlit
7:25 [Excursion] Filter & Group Dataframe in Pandas
11:00 Insert Slider & Multiselect in Streamlit
12:08 Filter Dataframe based on user selection
13:06 Group & Plot Dataframe after user selection
14:01 Use columns in Streamlit
14:49 Final Word
15:44 Outro

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[ermalgashimramori]

As always great tutorial, I am very pleased to see the quality of your tutorials and videos, in general, is increasing exponentially. Thank you for your time making these videos, I have been learning very much. Best of luck!

[paulcarr]

Thank you for making this video! It is very helpful and well-edited. I'm just getting into Python and Streamlit and these walkthroughs are much appreciated! The Jupyter Notebook Pandas demonstration was also very useful. What Jupyter app is that? The interface looks much better than the one I'm using.

[mohammedalbatati]

🤯 You are awesome
I really enjoyed this tutorial and will be trying it out on my own 👍🏽👍🏽👍🏽
Can't wait for the next one with uploading to server-side

Respect 👏🏼👏🏼

[manohartimothy]

Thank you so much for this video… I been watching some of your other videos like converting Excel into csv files and so on… I didn’t have enough time to thank you because I did download your program and I made some silly mistakes, which took a lot of time to amend it. I am just getting into Python and streamlit and these are quite hard to learn it in the begging. The Jupyter Notebook Pandas demonstration was also very useful. I never used Jupiter… Now I recon I will definitely do it. Once again I thank you so much for your beautiful explanations and the quality of your tutorial. I will be now onwards watching you regularly…

[ajayiae]

Amazing... great explanation and exactly what I'm looking for.... thank you!!

[BookOfMorman]

Hey great video! One suggestion: you may want to include the library name "streamlit" in the title to help gain traffic from people looking specifically for streamlit tutorials.

[py_tok]

very lovely, I will run through this tutorial fairly soon, thank you

[ccuny]

This is so good! I wish I had come across it a year ago when it was published. Liked and subbed. Greetz from France.

[mohammadjavadderakhshan]

Your tutorials are very helpful. Thankyou

[FabioMarcosBr]

Seus tutoriais são ótimos e muito funcionais. Sempre consigo aprimorar meu conhecimento com você. Parabéns.

[koollucian]

Just what I need..thank you, sir, for your excellent video tutorial.

[johanvanmarsch]

BRAVO BRAVO !! You are a KING !! With this Application you just Kill All the Microsoft Power BI Application and all this for free - I CANNOT BELIEVE MY EYES -
We subscribe in mass to you. Thank you my brother !!

[wikusolivier]

Again a great tutorial - your videos are really well-organized!

[KhalilYasser]

Very cool tutorial. Thank you very much.

[vcwocqv]

Thank you! Great video and instruction

[eliotharreau]

Bro, you are a King. Thank you for your clear explanations. 👍👍

[aemanrefai]

Awesome...thank you so much...I was able to build off of it

[FaisalReacts]

I think it's very complex programing project for me, however you explained everything very well sir..

[younesabdenaceraitemrar]

one of the best technolgies, i which i knew it, thanks a lot

[akki]

Love from india!!!! Thank you for making this video! It is very helpful and well-edited. I'm just getting into Python and Streamlit and these walkthroughs are much appreciated! can you please make a video for Excel with vba & macros with user forms!