Python Interactive Dashboard Development using Streamlit and Plotly

[@danicuenda8324]

This is just amazing, a real tutorial, no demo of useless stuff where you have to buy a 300$ course afterwards. Great example from start to finish, I can work from here on my own. Thank you very much sir.

[@ProgrammingIsFunn]

You're very welcome! I'm glad to hear that you found the tutorial helpful. If you have any more questions or need further assistance with anything related to the topic or any other topic, please feel free to ask. I'm here to help.

[@giovannitertulli]

This is the best video I've seen in 2023. Even better than Netflix and all that stuff. A true gem, I'll start to use this style of dashboarding for my job! Blessings man!

[@ProgrammingIsFunn]

Awesome!!! I'm glad to hear that you found the tutorial helpful.

[@hishot9442]

Best tutorial on the topic EVERRR

[@lee300977]

Amazing tutorial giving a great insight into the use of Streamlit. Thank you!

[@ProgrammingIsFunn]

Thanks Lee. I am glad it works for you

[@juicetin942]

Bhai maine nhi socha tha India mein itna mast coder milega. Main to fan hogya. I will watch all your videos. Let me know if you have any courses on any platform

[@JinzhuWANG]

Fantastic video! What you have taught can be used directly into a project. Thanks!

[@ProgrammingIsFunn]

Yes you can use it and then you can try to deploy on your production environment if needed.

[@GurpreetKaurJ]

Incredible Share Sir! Wonderfully Explained!! Awesome Visualizations. Thanks for this informative detailed explanation!

[@sachintyagi2003]

Brother..... You Create Amazing Dashboard!!!!

[@ProgrammingIsFunn]

I am glad you liked it.

[@kukki619]

I am really impressed and motivated after watching this video Thanks for the stunning visualisation

[@ProgrammingIsFunn]

Thanks for the appreciation☺️

[@AashriSaraswat]

This is one of the useful and informative video for every developer. Awesome

[@HakeemAlimi984]

Thanks. I found it helpful ❤

[@manuelquintana1340]

Thank you so much, your video was very very useful for me, you save me! Greetings from Colombia

[@ProgrammingIsFunn]

I am glad this video is beneficial for you. Keep watching

[@amirekhalili]

Amazing tutorial video, thanks for sharing

[@ravi1341975]

Wow this is amazing,i implemented it.Thank you.

[@ProgrammingIsFunn]

well done 👍🏻

[@creativemind2506]

Really Amazing project for streamlit

[@ProgrammingIsFunn]

I'm glad to hear that you found the tutorial helpful.

[@tlfmcooper]

This was amazing. Thank you

[@raghunathamaharana9091]

Great learning video. Eye opener video.

[@respect7556]

It's very informative and very creative, you are bestest sir❤

[@ashkanzand1288]

Very useful video! thank you for sharing it.

[@ProgrammingIsFunn]

Thanks for your comment. Keep Learning!!!

[@Diogene-pl1lq]

Great! Really amazing tutorial! Thanks alot

[@letuan930]

Great tutorial! thank you for sharing such a great knowledge

[@ProgrammingIsFunn]

Glad to hear!!!

[@AstorSkywalker]

Thank you Sir, very interesting!

[@williamnkum2053]

Awesome video!!! Great learning

[@dss1871]

Interesting.. Thanks for sharing.😊

[@miracleatimangovictoria7529]

Thank you so much. ❤❤

[@ProgrammingIsFunn]

You’re welcome!

[@CodewithKython]

fantastic job, great learning

[@arshallen]

great video thank you for sharing

[@falkez1514]

hey, maybe you could do a version of this for investments growth portifolio? huge thanks man, loved the video!

[@JohnMitchellCalif]

very useful! Subscribed

[@ProgrammingIsFunn]

Awesome 👏

[@ashraf_isb]

thank you so much for this!

[@ProgrammingIsFunn]

You're so welcome!😉

[@AbdussalamHossainKhan]

good one

[@ProgrammingIsFunn]

Thanks for your feedback!

[@TejasNarkhede-u6e]

Can we refer your video, because I want to collect telemetry data like motor speed, battery voltage ? Guide me how?

[@ProgrammingIsFunn]

Yes you can but you have to customise your solution based on the nature of the requirement

[@martg0]

great video! how do you host it?

[@viraleo1517]

thanks for your video

[@ProgrammingIsFunn]

I'm glad to hear that you found the tutorial helpful.

[@amargaikwad]

This works but i have dataframe with 1lac rows and everytime I click something it goes on in loop and slows down

[@ProgrammingIsFunn]

Thank you for your input. Indeed, when handling larger datasets, Streamlit performance may slow down. However, there are several strategies you can employ to optimize your Streamlit application and enhance its efficiency: Utilize Caching: Apply the @st.cache decorator to your data loading or processing functions to store the results and avoid redundant computations. import streamlit as st import pandas as pd @st.cache def load_data(): df = pd.read_csv("large_dataset.csv") # Any necessary data manipulation can be performed here return df df = load_data() Opt for Efficient Data Structures: Consider using more efficient data structures like Dask or Vaex, which are tailored to handle large datasets more effectively. Remove Unnecessary Columns from DataFrame: Trim down your DataFrame by removing any unnecessary columns, reducing memory usage and processing time. Async Support: Explore Streamlit's experimental async support for operations involving asynchronous tasks, preventing the application from blocking while waiting for these tasks to complete. By implementing these techniques, you can mitigate performance issues associated with handling larger datasets in your Streamlit dashboard.

[@JJ-yl5er]

I might not have understood the code correctly, but why do we need to apply further filtering to get filtered_df if the data has already been filtered in previous steps? Perhaps we could do something like the following to get the final filtered_df: # Create for City city = st.sidebar.multiselect("Pick the City", df3["City"].unique()) # Simplified Filter Logic if not city: filtered_df = df3 # If no city is selected, df3 is the final filtered result else: filtered_df = df3[df3["City"].isin(city)] # Filter by city

[@ankitshah6892]

Streamlit store (in its servers) or has access to the data we use to create such dashboard?

[@ProgrammingIsFunn]

You can deploy on your server as well

[@kunalr_ai]

you have only 15k subs and this video having 163k views on 6/6/2024. That is amazing.

[@ProgrammingIsFunn]

Thanks for your comment. My channel may not be as well-known as others, so I truly value your support. Please consider sharing these helpful videos with your peers, colleagues, and friends. Feel free to let me know what topics you're interested in for future content, so I can plan accordingly.

[@dhamodharanr3461]

Thank you very much

[@ProgrammingIsFunn]

I'm glad to hear that you found the tutorial helpful.

[@ramaali7438]

thank you , but what if i want to use another dataset and choose it from the interface i another words i want to make it dynamic dashboard

[@ProgrammingIsFunn]

If you use a different dataset, the functionality may not be optimal as the system is tailored specifically for the superstore sales data. Similarly, in real-life scenarios, creating a dashboard using PowerBI and Excel is effective, but if the underlying data is changed to a different dataset, the dashboard will no longer function correctly.

[@venkataanbharadwajvedula864]

Amazing

[@ProgrammingIsFunn]

Thank you! Cheers!

[@williansuarez3988]

this line: text = ['${:,.2f}'.format(x) for x in category_df["Sales"]], have an error, the column "Sales" is not numeric, is object, how can I fixed?

[@ProgrammingIsFunn]

You have to convert sale column into numeric data type. You can use pd.to_numeric function to convert the same.

[@inderjeetchandnani302]

Hi- my time series is not sorted with month and year, any guess where I might be going wrong.

[@ProgrammingIsFunn]

You can do using additional column. More specifically extract the month number from the date and sort it.

[@PANDURANG99]

Authentication and deployment?

[@ravitejakandimalla8484]

Hi sir, Firstly, that's a great explanation by you. I have a josn files stored in FIreBase database, how to get that that data in real time to build a dashboard like you did in real time?

[@AYUSHMANROUTSCSE]

Thankyou for such an incredible project. However, I am curious if there is a way I could add an interactive map to this data which shows the sales data points on the map. If yes, please help.

[@chabalaber]

Just look at documentation of these libs.

[@juicetin942]

How to get rid of produced with plotly.js button?

[@PrachiJain-v2g]

Hello, can someone help me i am using pie chart for showing the data, its not giving me any error but its displaying any chart as well

[@ProgrammingIsFunn]

Can you share your code or approach if you can?

[@Nick-qw3lm]

Thank you for your video. Please could you help me with the following question. After I import a .csv with only two decimals like 1.00 or 333.00, the following lines don't maintain those two decimal. Those decimals become 1.000000 or 333.000000. I would like to have only two decimal. Could you help!? with st.expander("Table"): st.write(category_df.style.background_gradient(cmap="Blues")) csv = category_df.to_csv(index=False).encode('utf-8') st.download_button("Download", data=csv, file_name="file.csv", mime="text/csv", help='Click here to download') with st.expander("Table"): df_selection["month"] = df_selection["date"].dt.month_name() sub_category_Year = pd.pivot_table(data=df_selection, values="amount", index=["name"], columns="month") st.write(sub_category_Year.style.background_gradient(cmap="Blues")) with st.expander("filtered"): st.write(df_selection.iloc[:500, 0:20:1].style.background_gradient(cmap="Blues_r"))

[@ProgrammingIsFunn]

Thanks for your comment. You can try with below line 👇 : category_df = category_df.round(2) Then try to export the data into csv. Good luck 🤞

[@Nick-qw3lm]

​@@ProgrammingIsFunn Thanks for the response but the problem is in the expanded tables in Streamlit like you can see in your video at time 37:42. The expanded table shows 6 decimals. Do you think you can help me?

[@nkwachiabel5092]

@@Nick-qw3lm st.write(df.style.format("{:.0f}").background_gradient(cmap='Blues_r')). This should help you. You can change the '0f' to '2f' if you want two decimals

[@Zelda-vi2sp]

Hello, thank you so much for your video. I have tried to apply for my dataset, and I have had some issues (ImportError: Pandas requires version '3.0.0' or newer of 'jinja2' (version '2.11.3' currently installed).) when running this code: st.write(gen_table.style.background_gradient(cmap="Blues")). Could you please help me to solve it? Thank you!

[@ProgrammingIsFunn]

Thanks for the comment, you have to upgrade your pandas and jinja2

[@Zelda-vi2sp]

@@ProgrammingIsFunn Thank you! And I also have another issue in that code is: "AttributeError: module 'matplotlib' has no attribute 'colormaps'". Could you help me with this?

[@souleymanetraore2053]

Super interesting tutorial but I have an error that I don't understand: StreamlitAPIException: ("Expected bytes, got a 'float' object", 'Conversion failed for column 0 with type object') Traceback: File "pages\graph.py", line 114, in st.write(linechart.T.style.background_gradient(cmap="Blues")) Thanks

[@sudhanshu004]

I have got the same error . So i searched a bit and found out it was an encoding error of utf-8 . Eventhough I wasnt able to avoid it ; but I coverted csv without encoding and its working with warning .Here is the updated code ; let me know if it works for you df_filtered['month_year'] = df_filtered['Order Date'].dt.to_period('M') st.subheader('Time Series Analysis') linechart = pd.DataFrame(df_filtered.groupby(df_filtered['month_year'].dt.strftime("%Y:%b"))["Sales"].sum()).reset_index() # Optionally convert to CSV without encoding csv = linechart.to_csv(index=False) fig2 = px.line(linechart, x="month_year", y='Sales', labels={"Sales": "Amount"}, height=500, width=1000, template="gridon") fig2.update_layout(title="Time Series Analysis") st.plotly_chart(fig2, use_container_width=True) with st.expander("View data for Time Series"): st.write(linechart.T.style.background_gradient(cmap="Blues")) st.download_button('Download Data', data=csv, file_name="Timeseries.csv", mime="text/csv")

[@adedwiariniputri70]

Hi, thank you for the tutorial. I have question : elif state and city: filtered_df = df3[df["State"].isin(state) & df3["City"].isin(city)] elif region and city: filtered_df = df3[df["Region"].isin(region) & df3["City"].isin(city)] elif region and state: filtered_df = df3[df["Region"].isin(region) & df3["State"].isin(state)] for this part of code. Why did you put df inside df3 isin state/region? thanks

[@ProgrammingIsFunn]

Hello, when you use the code df["State"].isin(state), it will generate a series of True and False values based on whether each element in the "State" column matches any element in the provided state list. For instance, if your "State" column contains values like NewYork, Florida, Ohio, NewYork, Florida, and you execute df["State"].isin("NewYork"), the result will be True, False, True, False, False. To filter rows containing only "NewYork," you should use df[df["State"].isin("NewYork")]. For a more detailed explanation, you can refer to this tutorial: kzbin.info/www/bejne/oGW3Z4KtntKZfLssi=mDvMlFAU2MasEnvX. Thanks and keep watching.

[@adedwiariniputri70]

@@ProgrammingIsFunn I understand what it used for. But why : df3[df["State"].isin(state) & df3["City"].isin(city)] Its df inside df3? isnt it supposed to be the same dataframe inside the dataframe example : df[df['State'].isin(state)] or df3[df3['State'].isin(state)]

[@adedwiariniputri70]

@@ProgrammingIsFunn df[df['State'].isin(state)] or df3[df3['State'].isin(state)] not df["State"].isin(state) chatgpt said you were typo. I think you are. It supposed to be same dataframe instead different dataframe

[@sandeepbondre6808]

Hello I find this tutotial more relavant and intresting , however , I am unable to understand where the data is getting stored , i guess in the server memory , if need the data to come from Excel files e.g. one file for each month how do i merge these twelve files or do i have to merge it manually , what if the data needs to be used from a SQL DB how can the same being achieved , I am not sure of the performance impact e.g. if each csav file has got 1lacs plus rows etc.

[@ProgrammingIsFunn]

Hello Sandeep, I'm pleased to hear that the information is proving beneficial for you. In this tutorial, we retrieve data into a Pandas DataFrame, where the DataFrame functions as a storage unit for information sourced from an Excel file. For instance, if you receive a file every month, you can utilize Python programming to consolidate this data. This implies that upon saving a file to a designated directory, the data merging process will execute automatically upon running the designated application or tool. Likewise, if you opt to store the data within an SQL database, Python can be employed to seamlessly import the data into the database without manual intervention. To enhance your comprehension, I am providing you with 2-3 instructional videos that will be of significant assistance. 1.) Combining Excel Sheets or File: kzbin.info/www/bejne/noWvnpmniLZgnqMsi=nponR3dGS6N1cQtH 2.) Python Pandas Tutorial: Importing Bulk CSVs Data Into SQL Server Using Python: kzbin.info/www/bejne/m3a5eGB3abdsjbcsi=1czJrortLN3Wexl6 3.) Auto Export Data from SQL Server with Notification: kzbin.info/www/bejne/bnPMgquVrap8ntksi=xbzyhWA-v2T7AdMr

[@BeziGebeyehu]

@@ProgrammingIsFunn you are the best!, Seriously🥰

[@wisdomsolution8346]

Great Work. Much appreciated. Can we share the dashboard report with other users in our office and can we fetch data from 4 files which are stored on a sharepoint folder. Thanks in advance.

[@ProgrammingIsFunn]

Yes you can.

[@amanahmed6057]

If i have multiple pages and I want to select start date and end date in 1st page and it should filter for other pages also , How can i achieve that functionalities

[@ProgrammingIsFunn]

Thanks for the query. You can store start date and end date in a variable and when you are rendering any page of streamlit. # streamlit_app.py import streamlit as st from datetime import datetime # Initialize session state for start_date and end_date if not already done if 'start_date' not in st.session_state: st.session_state.start_date = datetime.now() if 'end_date' not in st.session_state: st.session_state.end_date = datetime.now() # Define the first page def page1(): st.title("Page 1: Select Dates") start_date = st.date_input("Start Date", value=st.session_state.start_date) end_date = st.date_input("End Date", value=st.session_state.end_date) if start_date > end_date: st.error("Start date must be before end date") else: st.session_state.start_date = start_date st.session_state.end_date = end_date st.write(f"Selected Start Date: {st.session_state.start_date}") st.write(f"Selected End Date: {st.session_state.end_date}") # Define the second page def page2(): st.title("Page 2: Filtered Data") st.write(f"Using Start Date: {st.session_state.start_date}") st.write(f"Using End Date: {st.session_state.end_date}") # Example of filtering data (you can replace this with actual data filtering) data = [ {"date": "2023-01-01", "value": 10}, {"date": "2023-02-01", "value": 20}, {"date": "2023-03-01", "value": 30}, ] filtered_data = [d for d in data if st.session_state.start_date

[@amanahmed6057]

@@ProgrammingIsFunn Thank you so much for this code , i will go through this , (^_^)

[@shawna9833]

Are you support in small project development as freelancer or may be provide coaching?

[@ProgrammingIsFunn]

Freelancing sometime

[@shawna9833]

​@@ProgrammingIsFunncan you please share your contact detail

[@sachinjana3304]

hi, i find this tutorial really amazing, but I am getting an error while uploading new excel documents and the error is df["Order Date"] = pd.to_datetime(df["Order Date"]) how can i fix it

[@ProgrammingIsFunn]

May I know about the error?

[@sachinjana3304]

error on "Order Date" - raise KeyError(key) from err @@ProgrammingIsFunn

[@technicalknowledge9128]

Awesome sir can u teach me for class i love ur video

[@ProgrammingIsFunn]

Yeah tell us what you want to learn?

[@technicalknowledge9128]

@ProgrammingIsFunn python

[@ProgrammingIsFunn]

@@technicalknowledge9128 you can follow my playlist for Python, really that playlist will help you lot. Let me share with you.... kzbin.info/aero/PLWuFHho1zKhWb-f-SJAMUCK--f8PJlG46

[@deepakgupta8852]

Great tutorial I am little bit confused that how we can get time series data in correct order I mean month wise I think sort could work but still thinking would it be valid or not

[@deepakgupta8852]

Found the solution by myself again great tutorial worth every second

[@ProgrammingIsFunn]

We can use the calendar module to get the month and based on that we can align our month

[@punitsangwe7275]

Where do I get exel file, or raw data, link you provided, it has no xlsx file to download, it is redirected to some tableau community page, plz help

[@ProgrammingIsFunn]

Once it is redirected on Tableau community, so scroll down little bit then you will see the icon of excel file link and download it. If you are not able to find it then from below link you can download the order.xlsx file. github.com/AbhisheakSaraswat/RawData/blob/main/Order.xlsx

[@infodevbrasil]

how to put the project into production, where to deploy

[@No_to_slavery]

my "pip install streamlit" does not work. how do I need to do? I have python extension. Do we need conda env in vs code or anything? I have invalid character error. thanks

[@ProgrammingIsFunn]

can you tell me what error you are getting? If PIP is not recognized then you have install the pip in your system. from below path you can save on your desktop. (just open the below link and press Ctrl S) bootstrap.pypa.io/get-pip.py once is done, then open your cmd and redirect to the desktop and write the below command: python get-pip.py Thanks!!!

[@No_to_slavery]

@@ProgrammingIsFunn I got below error. I think it does not accept pip: ModuleNotFoundError: No module named 'altair.vegalite.v4'

[@tadakantisreeja6133]

sir how do we deploy the web application which was made

[@ProgrammingIsFunn]

Sure, we will let you know soon.

[@jaredsmith7795]

If anyone could answer, is the dashboard always running or is it reliant on execution within python?

[@ProgrammingIsFunn]

It's completely up to you. If you wish to refresh this dashboard automatically whenever your data is updated, Streamlit offers an option to always rerun when your data source changes. This is particularly useful when you're connected to the cloud, as any changes in the data source will automatically reflect in the dashboard.

[@debashishbasu1505]

How to execute my project over internet in my organisation??

[@ProgrammingIsFunn]

Please check your services which offers by your company

[@R3adyP1ay3r0ne]

File "", line 322, in decode UnicodeDecodeError: 'utf-8' codec can't decode byte 0xd0 in position 0: invalid continuation byte.

[@ProgrammingIsFunn]

You can use encoding while you are reading the file, example : pd.read_csv(filePath, encoding = “ISO-8859-1”)

[@amanahmed6057]

in this video are you also teaching cross filtering , please reply

[@ProgrammingIsFunn]

Yes here we are using nested filters

[@amanahmed6057]

@@ProgrammingIsFunn Not nested filter , means when we click on pie chart , other graph should automatically filter Just like we do normal click in powerbi. Thank you !

[@fadilajoudate7091]

why we can not apply to city what we did for the State ? In Min 21

[@ProgrammingIsFunn]

We are choosing the state and corresponding their cities

[@amanahmed6057]

can you tell us from where you are learning the streamlit other than document

[@ProgrammingIsFunn]

Hey Aman, we have done couple of project projects on streamlit. And You can also refer another tutorial let me share with you. kzbin.info/www/bejne/qKfMgqegoN2Eh7ssi=BVwq49cpmUr3k5LI kzbin.info/www/bejne/bHbYY5Vpacafqacsi=IrQfgwKJEjrBqP4z

[@vartech100]

Very imformative. However, I am getting this error : StreamlitAPIException: ("Expected bytes, got a 'float' object", 'Conversion failed for column 0 with type object') Traceback: File "second.py", line 112, in st.write(linechart.T.style.background_gradient(cmap="Blues"))

[@ProgrammingIsFunn]

Can you check the data type by which you are making line chart, means whatever the code you are using to create a variable like linechart.

[@ankurtanwar1972]

Stuck at this error : - "AttributeError: module 'matplotlib' has no attribute 'colormaps'" , it would be great if I get some help

[@ProgrammingIsFunn]

Share the code which you wrote

[@ankurtanwar1972]

I was trying the same code that you've shared

[@saikrishnasirikonda1008]

This is absolutely amazing!!!. But, while implementing i got an error called AXIOS ERROR - 403 as status code in file uploader function. I want you to help me from that, i would really appreciate your efforts, thank you.

[@mayankjha946]

ImportError: background_gradient requires matplotlib. st.write(category_df.style.background_gradient(cmap="Blues")) getting this error here..... how to solve it ??

[@ProgrammingIsFunn]

Can you try with import Matplotlib library

[@aymensettey8975]

i have the same error what should i do i imported matplotlib @@ProgrammingIsFunn

[@nwoyeshedrack6212]

Thank you so much for this. Can this be deployed on a server

[@ProgrammingIsFunn]

Yeah we can. 👌

[@shaikhrafae1458]

can we did in Pycharm

[@ProgrammingIsFunn]

Yes we can !!!

[@danielcortes3799]

can this be replicated but with jupyter notebook?

[@ProgrammingIsFunn]

Yes we can

[@2628Fab]

super interesting tutorial but I have an error that I don't understand: ParserError: Error tokenizing data. C error: Expected 1 fields in line 7, saw 2

[@Blanca-456]

It's because in your data file, in line 7 there are 2 values. It's supposed to be one.

[@KhalidKhan-kr5it]

very interesting session..Please share how we can send mail also..

[@ProgrammingIsFunn]

Yes, sure

[@antukhan5592]

this line giving error (20line ) df = pd.read_csv("Superstore.xlsx", encoding = "ISO-8859-1") ParserError: Error tokenizing data. C error: Expected 1 fields in line 7, saw 2 (fix it proper iso ) reply asap

[@ProgrammingIsFunn]

You have put the wrong function to read excel file, it should be read excel without encoding parameter pd.read_excel(“superstore.xlsx”)

[@antukhan5592]

@@ProgrammingIsFunn doesnot work

[@AbhisheakSaraswat]

@@antukhan5592 can you tell me what is not working?

[@blcl6050]

@@antukhan5592i've got the same issue. First download above `xls` file. Then export it to `csv` (you need only first table), rename it to Superstore.csv. Then modify line to 'df = pd.read_csv("Superstore.csv", sep=";", encoding="UTF-8")'. Now it works for me.

[@johndong4754]

@@antukhan5592 I had to use this line: df = pd.read_excel("Superstore.xls") and run this line in terminal: "pip install xlrd>=2.0.1"

[@Tibaandroid-ho3zp]

The important thing is to integrated it with a good framework such Django! Is it possible? Many thanks.

[@ProgrammingIsFunn]

Yes it is possible to do that.....

[@mednejad]

Wow amazing video, Subscribed ..... 🙂 I'm loving Python and especially the visual libraries. Do you do private tutoring through Skype by any chance? If so please let me know and I'll give you my email to discuss rates? thank you :-)

[@amanahmed6057]

getting this error Error tokenizing data. C error: Expected 1 fields in line 7, saw 2

[@ProgrammingIsFunn]

Can you tell in which statement you are facing an error

[@amanahmed6057]

@@ProgrammingIsFunn No idea , i was just ran the code , upto region and got this error and after finding from internet it looks like File is not okay , So i find another dataset and put order date in that file , But now i am getting error as Order Date is Keyerror

[@amanahmed6057]

@@ProgrammingIsFunn error solved , thanks

[@ProgrammingIsFunn]

@@amanahmed6057 can you tell me what is exact error of code. or you are getting an error when you are reading the file.

[@aniketkumar6270]

please listen once , very informative video , Bhaiya i want to upload any sales data in browse file and it will give the anaylisis like you shown in this video . how can i do this with any sales data set. it return error if i upload any other sales dataset. what can i do ,please help me ,this is my project.

[@ProgrammingIsFunn]

For any other sales data it will not work, because I have used the column name into the script. However, you want to upload your own data set then you need to customise your dataset based to columns accordingly.

[@annapurnasingh6689]

​@@ProgrammingIsFunnsuppose I am working on such applications where if I upload any sales datasets,it will show me the same template which you design .If I don't want to change the column name . Any idea how we can do this?

[@abhisheaksaraswat-ib1of]

@@annapurnasingh6689 you can do the mapping in your config or json file to do that

[@KarunkumarSeeram]

Hello iam getting an error at starting stage to read csv files and upload files please solve my error man

[@ProgrammingIsFunn]

Can you let me know what is the error ?

[@KarunkumarSeeram]

@@ProgrammingIsFunn File "D:\chatbot\myvenv\Lib\site-packages\streamlit untime\scriptrunner\script_runner.py", line 552, in _run_script exec(code, module.__dict__) File "D:\chatbot\app.py", line 23, in df = pd.read_csv("Superstore.csv",sep='\t',encoding='ISO-8859-1',error_bad_lines=False)

[@KarunkumarSeeram]

@@ProgrammingIsFunn df = pd.read_csv("Superstore.csv",sep='\t',encoding='ISO-8859-1',error_bad_lines=False) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ TypeError: read_csv() got an unexpected keyword argument 'error_bad_lines' please tell how to solve this error

[@ProgrammingIsFunn]

@@KarunkumarSeeram Remove error_bad_lines keyword from the read_csv function

[@antukhan5592]

@@ProgrammingIsFunn its not working

[@sikiruyusuff1246]

My challenges is that the filter is just showing only one item selection.

[@sikiruyusuff1246]

I have solved the problem by ignoring the datetime filter. The problem occurred might be due to the different dataset used

[@ghassensaidi]

great job seourisly bro ... i can't find the dataset

[@ProgrammingIsFunn]

Thanks. Please follow this link and download the excel file. community.tableau.com/s/question/0D54T00000CWeX8SAL/sample-superstore-sales-excelxls Just scroll little bit then you will able to see excel icon with download button

[@ghassensaidi]

@@ProgrammingIsFunn thanks

[@KALYANACHAKRAVARTHINALAM]

do tutorials of streamlit sir from scratch

[@dipanjankarmakar5870]

do you have any hindi channel ?

[@theepicgoalstv]

Make more sample like db connection

[@ProgrammingIsFunn]

Thanks for the comment

[@Aapka_apna_shivam]

is this a project or a tutorial ?

[@ProgrammingIsFunn]

Both.

[@johndong4754]

Getting this error: AttributeError: 'DataFrame' object has no attribute 'append' fig3 = px.treemap(filtered_df, path = ["Region","Category","Sub-Category"], values = "Sales",hover_data = ["Sales"], color = "Sub-Category")

[@ProgrammingIsFunn]

The code snippet you provided, however, does not include any calls to the append method. To handle the issue, consider the following Library Versions: can you check library versions whatever your are using? If you're still facing issues after verifying these aspects, please provide more context (In which line you are getting an error or you are writing the same code as in video) or the relevant parts of your code so that I can help you further.

[@johndong4754]

@@ProgrammingIsFunn I figured out the issue, thank you! You were correct though; I had to update my libraries to solve the issue. I was confused though because I never had the append method anywhere in my code, so I am not sure why the error was mentioning that.

[@ProgrammingIsFunn]

@@johndong4754 Awesome, Keep Learning ...

[@davidbrock3716]

Hi, This is very amazing and appreciate you sharing this . Also, I have an insurance brokerage firm and wish to leverage this in our organisation. Can you please send me your direct contact details so we have a discussion around you building something similar to this offline for a fee?

[@freddoliveira]

...

[@tiger21823]

How to connect it with google sheets?