Python Interactive Dashboard Development using Streamlit and Plotly

Рет қаралды 174,906

Күн бұрын

In this video you will learn step by step Python Interactive Dashboard Development using Streamlit and Plotly just like PowerBI and Tableau etc.
Streamlit is a popular Python library used for building interactive web applications and dashboards. It simplifies the process of creating data-driven applications by providing a straightforward and intuitive interface. Here are some key uses of Streamlit in Python dashboards
* Rapid Prototyping:
* Data Visualization:
* User Interaction:
* Integration with Machine Learning Models:
* Sharing and Deployment:
⭐Content⭐
In this video, you will learn: ⚡
1.) Utilizing Streamlit to create interactive plots
2.) Navigating and uploading raw data into the dashboard
3.) Creating titles, headings, headers, or subheaders in Streamlit
4.) Generating segments for plots within Streamlit
5.) Adding a date picker to the dashboard
6.) Handling and transforming data using Python Pandas with Streamlit
7.) Creating a side pane with multiple select filters
8.) Transforming data using Pandas
9.) Visualizing data using Python Plotly and plotting all graphs within the Streamlit environment
10.) Performing Time Series Analysis in Streamlit
11.) Downloading or viewing data based on plots
12.) Creating a hierarchical view of sales using TreeMap
13.) Creating data tables using Plotly Figure_Factory
14.) Applying styles to data within Streamlit
15.) Viewing or downloading data using Streamlit
16.) Performing Data Analysis and Data Visualization using Python Streamlit
17.) Examples...
Overall, Streamlit simplifies the process of creating interactive Python dashboards by providing an intuitive interface, data visualization capabilities, user interaction features, and easy deployment options. It is a powerful tool for data scientists, developers, and anyone looking to showcase data and insights in an engaging and accessible manner.
Pandas and Plotly are powerful libraries that play essential roles in dashboard development.
➖➖➖➖➖➖➖➖ ➖➖➖➖➖➖➖➖
👍 Pandas:
1.) Data Manipulation
2.) Data Cleaning and Preprocessing
3.) Data Integration
4.) Data Transformation
👍 Plotly:
1.) Interactive Data Visualization
2.) Dynamic Updating
3.) Intuitive Interactivity
4.) Dash Integration
In summary, Pandas and Plotly complement each other in dashboard development. Pandas helps with data manipulation, cleaning, and preprocessing, while Plotly enables interactive and visually appealing data visualizations. Together, they empower you to build powerful and insightful dashboards that effectively present and analyze data.
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
Interactive Web Portfolio using Python Streamlit : • Building a Professiona...
Raw Data Set : community.tableau.com/s/quest...
Streamlit Emoji Icons: streamlit-emoji-shortcodes-st...
Python Streamlit Dashboard Source Code: github.com/AbhisheakSaraswat/...
Python Pandas Tutorial: • Python Pandas Tutorial...
Python Playlist: • Python Tutorial for Be...
Python Data Structure Playlist: • Python Data Structure
Python OOPs Playlist: • Object Oriented Progra...
Telegram Link: t.me/+32-TodtiOvo2Njk9
➖➖➖➖➖➖➖➖ or ➖➖➖➖➖➖➖➖
👍 Subscribe Now: bit.ly/41B5ep2
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
#python
#programming
#datascience
#machinelearning
#webdevelopment
#code
#developer
#softwareengineering
#opensource
#tutorial
#tech
#coding
#computerprogramming
#pandas
#numpy
#matplotlib
#StreamlitTutorial
#PythonDashboard
#InteractivePlots
#DataVisualization
#StreamlitAndPlotly
#DataAnalysis
#TimeSeriesAnalysis
#PandasTutorial
#PlotlyVisualization
#DataTables
#DashboardDevelopment
#PythonProgramming
#StreamlitExamples
#DataManipulation
#DataFiltering
#DataTransformation
#HierarchicalView
#DataExploration
#DashboardDesign
#StreamlitTips

Пікірлер: 168

@GurpreetKaurJ Жыл бұрын

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

@danicuenda8324 9 ай бұрын

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 9 ай бұрын

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.

@giovannitertulli4962 9 ай бұрын

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 9 ай бұрын

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

@user-qc3vf9uo9g 9 ай бұрын

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

@ProgrammingIsFunn 9 ай бұрын

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

@user-bk8in5on7c 6 ай бұрын

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

@Diogene-pl1lq 8 ай бұрын

Great! Really amazing tutorial! Thanks alot

@hishot9442 3 ай бұрын

Best tutorial on the topic EVERRR

@tlfmcooper 4 ай бұрын

This was amazing. Thank you

@williamnkum2053 8 ай бұрын

Awesome video!!! Great learning

@raghunathamaharana9091 8 ай бұрын

Great learning video. Eye opener video.

@lee300977 4 ай бұрын

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

@ProgrammingIsFunn 4 ай бұрын

Thanks Lee. I am glad it works for you

@AstorSkywalker 8 ай бұрын

Thank you Sir, very interesting!

@amirekhalili 8 ай бұрын

Amazing tutorial video, thanks for sharing

@dss1871 Жыл бұрын

Interesting.. Thanks for sharing.😊

@respect7556 Жыл бұрын

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

@CodewithKython 9 ай бұрын

fantastic job, great learning

@kristinaantonellaurenahern3059 8 ай бұрын

you rock!... thanks!

@kukki619 8 ай бұрын

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

@ProgrammingIsFunn 8 ай бұрын

Thanks for the appreciation☺️

@letuan930 9 ай бұрын

Great tutorial! thank you for sharing such a great knowledge

@ProgrammingIsFunn 9 ай бұрын

Glad to hear!!!

@arshallen 2 ай бұрын

great video thank you for sharing

@ashkanzand1288 7 ай бұрын

Very useful video! thank you for sharing it.

@ProgrammingIsFunn 7 ай бұрын

Thanks for your comment. Keep Learning!!!

@manuelquintana1340 Сағат бұрын

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

@ProgrammingIsFunn 53 минут бұрын

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

@ashraf_isb 2 ай бұрын

thank you so much for this!

@ProgrammingIsFunn Ай бұрын

You're so welcome!😉

@creativemind2506 9 ай бұрын

Really Amazing project for streamlit

@ProgrammingIsFunn 9 ай бұрын

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

@juicetin942 5 ай бұрын

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

@dhamodharanr3461 11 ай бұрын

Thank you very much

@ProgrammingIsFunn 9 ай бұрын

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

@JohnMitchellCalif 10 ай бұрын

very useful! Subscribed

@ProgrammingIsFunn 9 ай бұрын

Awesome 👏

@viraleo1517 11 ай бұрын

thanks for your video

@ProgrammingIsFunn 9 ай бұрын

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

@amargaikwad 2 ай бұрын

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

@ProgrammingIsFunn 2 ай бұрын

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.

@falkez1514 2 ай бұрын

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

@ramaali7438 11 ай бұрын

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 11 ай бұрын

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.

@technicalknowledge9128 2 ай бұрын

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

@AYUSHMANROUTSCSE 10 ай бұрын

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 8 ай бұрын

Just look at documentation of these libs.

@ravitejakandimalla8484 7 ай бұрын

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?

@ankitshah6892 11 ай бұрын

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

@ProgrammingIsFunn 11 ай бұрын

You can deploy on your server as well

@user-rf2mj3jp1n 10 ай бұрын

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 10 ай бұрын

Can you share your code or approach if you can?

@juicetin942 5 ай бұрын

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

@sandeepbondre6808 10 ай бұрын

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 10 ай бұрын

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: kzfaq.info/get/bejne/nrp8oMmiuLeRmHU.htmlsi=nponR3dGS6N1cQtH 2.) Python Pandas Tutorial: Importing Bulk CSVs Data Into SQL Server Using Python: kzfaq.info/get/bejne/m6uGepBymbidh4k.htmlsi=1czJrortLN3Wexl6 3.) Auto Export Data from SQL Server with Notification: kzfaq.info/get/bejne/bqiZhNuQ3autmKs.htmlsi=xbzyhWA-v2T7AdMr

@user-fg1wf5ri6h 8 ай бұрын

@@ProgrammingIsFunn you are the best!, Seriously🥰

@wisdomsolution8346 9 ай бұрын

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 9 ай бұрын

Yes you can.

@deepakgupta8852 10 ай бұрын

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 10 ай бұрын

Found the solution by myself again great tutorial worth every second

@ProgrammingIsFunn 10 ай бұрын

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

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

@inderjeetchandnani302 2 ай бұрын

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

@ProgrammingIsFunn 27 күн бұрын

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

@souleymanetraore2053 7 ай бұрын

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 7 ай бұрын

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")

@williansuarez3988 9 ай бұрын

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 9 ай бұрын

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

@Zelda-vi2sp 2 ай бұрын

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 2 ай бұрын

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

@Zelda-vi2sp 2 ай бұрын

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

@infodevbrasil 7 ай бұрын

how to put the project into production, where to deploy

@martg0 5 ай бұрын

great video! how do you host it?

@vartech100 9 ай бұрын

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 9 ай бұрын

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.

@adedwiariniputri70 6 ай бұрын

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 6 ай бұрын

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: kzfaq.info/get/bejne/oJqEabKoztPKdo0.htmlsi=mDvMlFAU2MasEnvX. Thanks and keep watching.

@adedwiariniputri70 6 ай бұрын

@@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 6 ай бұрын

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

@tadakantisreeja6133 10 ай бұрын

sir how do we deploy the web application which was made

@ProgrammingIsFunn 10 ай бұрын

Sure, we will let you know soon.

@jaredsmith7795 4 ай бұрын

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

@ProgrammingIsFunn 4 ай бұрын

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.

@amanahmed6057 27 күн бұрын

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 27 күн бұрын

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 26 күн бұрын

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

@fadilajoudate7091 4 ай бұрын

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

@ProgrammingIsFunn 4 ай бұрын

We are choosing the state and corresponding their cities

@saikrishnasirikonda1008 5 ай бұрын

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.

@sachinjana3304 6 ай бұрын

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 6 ай бұрын

May I know about the error?

@sachinjana3304 6 ай бұрын

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

@punitsangwe7275 7 ай бұрын

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 7 ай бұрын

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

@2628Fab 7 ай бұрын

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 6 ай бұрын

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

@KhalidKhan-kr5it 11 ай бұрын

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

@ProgrammingIsFunn 11 ай бұрын

Yes, sure

@izzettin1586 7 ай бұрын

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 7 ай бұрын

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!!!

@izzettin1586 7 ай бұрын

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

@amanahmed6057 26 күн бұрын

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

@ProgrammingIsFunn 26 күн бұрын

Hey Aman, we have done couple of project projects on streamlit. And You can also refer another tutorial let me share with you. kzfaq.info/get/bejne/qNyZhNeb0N61gY0.htmlsi=BVwq49cpmUr3k5LI kzfaq.info/get/bejne/bKulZcVkmcfQo3k.htmlsi=IrQfgwKJEjrBqP4z

@R3adyP1ay3r0ne 6 ай бұрын

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

@ProgrammingIsFunn 6 ай бұрын

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

@nwoyeshedrack6212 2 ай бұрын

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

@ProgrammingIsFunn 2 ай бұрын

Yeah we can. 👌

@amanahmed6057 27 күн бұрын

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

@ProgrammingIsFunn 27 күн бұрын

Yes here we are using nested filters

@amanahmed6057 26 күн бұрын

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

@mayankjha946 9 ай бұрын

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

@ProgrammingIsFunn 9 ай бұрын

Can you try with import Matplotlib library

@aymensettey8975 6 ай бұрын

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

@shawna9833 3 ай бұрын

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

@ProgrammingIsFunn 3 ай бұрын

Freelancing sometime

@shawna9833 3 ай бұрын

@@ProgrammingIsFunncan you please share your contact detail

@mednejad 5 ай бұрын

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

@Tibaandroid-ho3zp 7 ай бұрын

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

@ProgrammingIsFunn 7 ай бұрын

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

@user-ix1ox2jj1f 3 ай бұрын

do tutorials of streamlit sir from scratch

@shaikhrafae1458 7 ай бұрын

can we did in Pycharm

@ProgrammingIsFunn 7 ай бұрын

Yes we can !!!

@ankurtanwar1972 5 ай бұрын

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

@ProgrammingIsFunn 5 ай бұрын

Share the code which you wrote

@ankurtanwar1972 5 ай бұрын

I was trying the same code that you've shared

@danielcortes3799 5 ай бұрын

can this be replicated but with jupyter notebook?

@ProgrammingIsFunn 5 ай бұрын

Yes we can

@aniketkumar6270 21 күн бұрын

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 21 күн бұрын

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.

@user-qr6rk8zw5e Жыл бұрын

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 ?

@user-qr6rk8zw5e Жыл бұрын

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

@user-qr6rk8zw5e Жыл бұрын

@@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 11 ай бұрын

@@user-qr6rk8zw5e Remove error_bad_lines keyword from the read_csv function

@antukhan5592 11 ай бұрын

@@ProgrammingIsFunn its not working

@davidbrock3716 8 ай бұрын

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?

@thepowerofmotivation_yokin Ай бұрын

Make more sample like db connection

@ProgrammingIsFunn Ай бұрын

Thanks for the comment

@antukhan5592 11 ай бұрын

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 11 ай бұрын

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

@antukhan5592 11 ай бұрын

@@ProgrammingIsFunn doesnot work

@AbhisheakSaraswat 10 ай бұрын

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

@blcl6050 10 ай бұрын

@@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 10 ай бұрын

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

@ghassensaidi 6 ай бұрын

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

@ProgrammingIsFunn 6 ай бұрын

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 6 ай бұрын

@@ProgrammingIsFunn thanks

@Nick-qw3lm 7 ай бұрын

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 7 ай бұрын

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 7 ай бұрын

@@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 6 ай бұрын

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

@amanahmed6057 22 күн бұрын

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

@ProgrammingIsFunn 22 күн бұрын

Can you tell in which statement you are facing an error

@amanahmed6057 22 күн бұрын

@@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 22 күн бұрын

@@ProgrammingIsFunn error solved , thanks

@ProgrammingIsFunn 21 күн бұрын

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

@dipanjankarmakar5870 3 ай бұрын

do you have any hindi channel ?

@johndong4754 10 ай бұрын

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 10 ай бұрын

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 10 ай бұрын

@@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 10 ай бұрын

@@johndong4754 Awesome, Keep Learning ...