Build a Web App to Group & Plot Excel Files in Python with Streamlit

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Did you know that you can quickly develop web applications in just a few lines of code using Python? Streamlit is a Python module that makes it very easy to quickly develop web apps. In this particular web app, we will be transforming & visualizing Excel files. Once the data has been grouped, the user can download the interactive chart and the corresponding Excel workbook.

📝 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀:
Download the Project Folder / Source Code here:

Deploy the app for free on the internet:

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

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

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[polarise]

This is very easy to understand! it really helps me to write my intern project. Thank you for this👏

[onurbasaran]

Thanks for the devoted video preparation and valuable informations.

[vanthang]

Thank you for making many useful tuts :)

[chuchaftw]

love your channel! could you pleasseee make more excel/streamlit videos? theyre amazing. Thanks again!

[fusionfoods]

Please make a video about applying bootstrap styles to Streamlit components

[khan.naved]

is there a way to create a selection of category and subcategories dinamically or using a selection box??

[soulforce]

Which extension do you use for show the "XLSX icon imagen... min: 3:02, thats look amazing

[carbonvibes]

Great content, I do have a question regarding Stremlit. If I was to create the following web app where is that data being kept? I’m asking since I work for a company and keeping the company’s data secure is important. Is local hosting an option?

[shoaibshaikh]

Great video 😀! Wondering if this can be compiled as a stand alone exe for distribution purposes? My aim is to provide my colleagues with a stand alone exe which when launched opens the interactive web app in the web browser without having to download Python or without me having to deploy to a server.

[punjaramborhade]

Friend how to create streamlit dashboard for live data fetching in excel tik by tik every minutes & that data we need to plot & update also as it comes
Eg share market data since morning to closing

Plz make video

[fusionfoods]

Getting df as undefined (df is not defined), is it because you define in if condition(uploaded_file:) and it is not accessible when using the same df under section # -- GROUP DATAFRAME

[achazngwouanzie]

From Cameroun, it is really Amazing.
Please when I try to download I have this on my browser : about :blank#blocked .
What is the probleme ?

[sushilmudgal]

plz send me original code folder for ready & run bcz I tried many times not successful

[calafeabra]

Thank you for the video... Why it says " Access denied" when I try to get a URL via command prompt
and is there a Streamlit Editor I can use to code and see changes?

[nagendravishwamitra]

Super I am building this but struck in vlookup function in excel, could you please guide on how to write vlookup in openpyxl

[vaibhavk]

Is it possible to draw route between two location in streamlit

[sergeysergey]

hello! I am trying to upload a json file using the pandas method df = pd.read_json(upload_file) but I get an exception that the object is not data....although if I download a file from the hard disk using the same method, there are no problems....I don't understand what could be the reason