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

[@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]

Thank you for making many useful tuts :)

[@CodingIsFun]

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

[@chuchaftw]

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

[@CodingIsFun]

*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 ✌

[@khan.naved1]

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

[@CodingIsFun]

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!

[@philipedesouzasantos1201]

Hey, thanks! Very useful guide.

[@CodingIsFun]

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

[@soulforce4999]

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

[@CodingIsFun]

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.

[@ermalgashimramori]

Great content, as always!

[@CodingIsFun]

Thank you! :)

[@fusionfoods1262]

Please make a video about applying bootstrap styles to Streamlit components

[@CodingIsFun]

Thank you for watching the video & your suggestion.

[@nivasmptc]

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

[@CodingIsFun]

Thank you! Greetings back to Kuwait ❤ 😃

[@tnssajivasudevan1601]

Amazing video Sir

[@CodingIsFun]

Thank you! :)

[@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 :)

[@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?

[@CodingIsFun]

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

[@user-nn7fu1kt4c]

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

[@CodingIsFun]

You are veeeeeeeeeeery welcome! 💓 Cheers, Sven ✌️

[@phucle1669]

thank your

[@CodingIsFun]

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

[@calafeabra3727]

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]

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]

@@CodingIsFun Thank you for your response

[@punjaramborhade1701]

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]

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!

[@sergeysergey421]

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]

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]

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

[@sergeysergey421]

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]

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

[@achazngwouanzie7646]

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]

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.

[@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

[@ricardo.alves.campos]

Excellent !

[@CodingIsFun]

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

[@vaibhavk2430]

Is it possible to draw route between two location in streamlit

[@CodingIsFun]

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

[@gerhardspitzlsperger1567]

Always interesting

[@CodingIsFun]

Thank you! :)

[@nagendravishwamitra3652]

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

[@CodingIsFun]

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: kzbin.info/www/bejne/d3m2amVrgZ19jM0 Hope it helps! 😃

[@nagendravishwamitra3652]

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

[@CodingIsFun]

@@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')

[@sushilmudgal203]

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

[@CodingIsFun]

Thanks for watching. The link is in the description box.

[@FernandoGarcia-kw2kd]

soooo gooood

[@CodingIsFun]

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

[@ularkadutdotnet]

great video

[@CodingIsFun]

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