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

Подписаться 96 тыс.

Просмотров 31 тыс.

50% 1

👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
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:
► github.com/Sven-Bo/streamlit-...
Deploy the app for free on the internet:
► • Deploy Your Streamlit ...
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Data Visualization Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-tem...
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here: pythonandvba.com/coffee-donation

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 63

@polarise154 Год назад

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

@CodingIsFun Год назад

Glad it was helpful! Good luck with your project! Happy Coding 🤓

@onurbasaran2033 Год назад

Thanks for the devoted video preparation and valuable informations.

@CodingIsFun Год назад

My pleasure! Appreciate you taking the time to watch and leave a comment. 👍

@vanthang8592 2 года назад

Thank you for making many useful tuts :)

@CodingIsFun 2 года назад

Glad to hear that you find the tutorials helpful! Thanks for watching and your comment! 👍

@ermalgashimramori 3 года назад

Great content, as always!

@CodingIsFun 3 года назад

Thank you! :)

@philipedesouzasantos1201 2 года назад

Hey, thanks! Very useful guide.

@CodingIsFun 2 года назад

Thank you for watching the video. Glad it was helpful! 😃

@chuchaftw 3 года назад

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

@CodingIsFun 3 года назад

*I am glad to hear you are enjoying the videos, thanks for watching and for the comment!* More Streamlit (with Excel) videos will come. Stay tuned ✌

@tnssajivasudevan1601 3 года назад

Amazing video Sir

@CodingIsFun 3 года назад

Thank you! :)

@nivasmptc 3 года назад

❤️❤️❤️❤️ Love fan from Kuwait

@CodingIsFun 3 года назад

Thank you! Greetings back to Kuwait ❤ 😃

@ricardo.alves.campos 3 года назад

Excellent !

@CodingIsFun 3 года назад

Glad you like it! Thank you for watching the video & your comment 👍

@gerhardspitzlsperger1567 3 года назад

Always interesting

@CodingIsFun 3 года назад

Thank you! :)

@user-nn7fu1kt4c 4 месяца назад

❤❤❤❤❤❤❤❤❤❤ thank you veeeeeeeeeeery muuuuuuuuuuush

@CodingIsFun 4 месяца назад

You are veeeeeeeeeeery welcome! 💓 Cheers, Sven ✌️

@phucle1669 Год назад

thank your

@CodingIsFun Год назад

You're very welcome! Thank you for watching and for the comment!

@fusionfoods1262 Год назад

Please make a video about applying bootstrap styles to Streamlit components

@CodingIsFun Год назад

Thank you for watching the video & your suggestion.

@khan.naved1 2 года назад

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

@CodingIsFun 2 года назад

Yes, that is possible. Get the categories from the user using the st.selectbox and store them in a variable. Then use that variable to get all unique values from the categories column (with pandas) and use the result in a second selectbox. Happy Coding!

@shoaibshaikh2357 Год назад

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.

@CodingIsFun Год назад

Thanks for watching. I do not thing that will be possible (but I might be mistaken). You can convert it to an exe file, yet the app still needs to be deployed somewhere: discuss.streamlit.io/t/streamlit-deployment-as-an-executable-file-exe-for-windows-macos-and-android/6812/19?page=2

@carbonvibes 2 года назад

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?

@CodingIsFun 2 года назад

Thanks! If you have the IT infrastructure, you could host streamlit on-premise. If you want to deploy it to an external server/cloud provider, it depends on how you handle the user authentication to secure the data. One option might be to deploy it to the streamlit cloud. Have a look here: docs.streamlit.io/streamlit-cloud/trust-and-security

@sigkalbar Год назад

great video

@CodingIsFun Год назад

Glad you liked it. Thanks for watching and taking the time to leave a comment!

@FernandoGarcia-kw2kd 2 месяца назад

soooo gooood

@CodingIsFun 2 месяца назад

Glad you liked it. Thanks for watching and taking the time to leave a comment! Cheers, Sven ✌️

@calafeabra3727 2 года назад

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?

@CodingIsFun 2 года назад

Thanks for watching the video. I assume you are getting 'Access denied' when running 'streamlit run app.py'. In that case, you might want to check out the following StackOverflow post: stackoverflow.com/questions/68887792/access-denied-after-running-streamlit-hello As far as I know, there is no Streamlit editor. Streamlit supports hot reload. Meaning all your changes in the script will be reflected on the local server after refreshing the web browser. I hope this helps!

@calafeabra3727 2 года назад

@@CodingIsFun Thank you for your response

@vaibhavk2430 2 года назад

Is it possible to draw route between two location in streamlit

@CodingIsFun 2 года назад

Can you perhaps elaborate on what you're actually trying to achieve? Please provide some additional info. Thanks!

@soulforce4999 6 месяцев назад

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

@CodingIsFun 6 месяцев назад

Thanks for watching. Sorry, but I am not quite sure which icon you are referring to. At the mentioned timestamp, I didn't insert any icon.

@fusionfoods1262 Год назад

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

@CodingIsFun Год назад

Thanks for watching. Could you please try to clone the repo and try it again? Thanks!

@fusionfoods1262 Год назад

Its working now, thank you :)

@achazngwouanzie7646 2 года назад

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 ?

@CodingIsFun 2 года назад

Thank you! I am not entirely sure why you are getting this, but I assume it might be due to some security settings in your browser. E.g. if you are using Chrome, have a look at the following article: askleo.com/what_is_aboutblank_and_how_do_i_get_rid_of_it/#:~:text=The%20reason%20is%20simple%3A%20the,about%3Ablank%20is%20displayed%20instead.&text=If%20this%20is%20something%20you,settings%2C%20and%20your%20browser%20extensions.

@nagendravishwamitra3652 3 года назад

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

@CodingIsFun 3 года назад

Do you want to insert a VlookUp Formula into cells using openpyxl? If so, please see an example below: from openpyxl import Workbook wb = Workbook() ws = wb.active for row in ws['D1:D10']: for cell in row: cell.value = f'=VLOOKUP(C{cell.row},$K$1:$L$5,2,0)' # cell.value = f"{cell.row}" wb.save('vlookup.xlsx') Or if you want to use pandas, I have created the following video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AHS925L8JVk.html Hope it helps! 😃

@nagendravishwamitra3652 3 года назад

Sir this is working for same sheet but how to do vlookup for 2 different workbooks

@CodingIsFun 3 года назад

@@nagendravishwamitra3652 Here is an example: from openpyxl import Workbook, load_workbook wb = load_workbook(r'C:\Users\Bananatree\Desktop\Book1.xlsx') source_range = "'C:\\Users\\Bananatree\\Desktop\\[Book2.xlsx]Sheet1'" + "!$H$5:$I$10" ws = wb.active for row in ws['D1:D10']: for cell in row: cell.value = f"=VLOOKUP(C{cell.row},{source_range},2,0)" # cell.value = f"{cell.row}" wb.save('vlookup.xlsx')

@sergeysergey421 2 года назад

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

@CodingIsFun 2 года назад

Do you get an error when using streamlit on your local machine? Or do you only get an error after deploying your steamlit app to a server? And how did you define 'upload_file'?

@sergeysergey421 2 года назад

@@CodingIsFun i got error on local machine. and i have got uploaded_file_json = st.file_uploader('Choose a JSON file', type='json')

@sergeysergey421 2 года назад

absolutely crazy situation. I had a function that took in json, converted it to df, and did manipulations. I decided to test the streamlшt. As a result, it worke if iwrite the export to the pd.df in a procedural style, but then problems started anyway with mergen another df. that's how I understood the problems with panadas. or maybe I launched a streamlight in a virtual environment, it doesn't matter in general, thank you)

@sergeysergey421 2 года назад

def load_json_pd(self, idx='S_ID'): extension = os.path.splitext(self.data_path)[1] if extension == ".json": df_out = pd.read_json(self.data_path) df = df_out.T df = df.rename_axis(idx).reset_index() df[idx] = df[idx].astype(str) return df else: df = self.data_path return df

@punjaramborhade1701 9 месяцев назад

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

@CodingIsFun 9 месяцев назад

Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!