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

Sure 👍🏻

Thanks for the compliment.

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

Date has not been sorted in that example, if you want sort then you can add additional column then sort accordingly

@@ProgrammingIsFunn after creating the month_year column I apply the dt.strftime(%Y : %b) and it sorted the column as per date!!. Thank you so much for replying...I didn't realise that u read comments!!! ❤️❤️❤️

@@mrinmaykhamrui4094 Thanks, I am focusing on comments, pardon in case I missed.

​@@abhisheaksaraswat-ib1of can I connect with u on LinkedIn!! Am switching my domain from core branch to data analytics!! I could really use ur help!.🙂🙂🙂

It's my pleasure

I am glad it helps you.

I am glad this video helps you.

Thank you for your kind words! I'm thrilled the video was beneficial to you.

My machine has been changed, so I don't have those files right now. It would be great if you could write the Python code from the video directly. Moving forward, I will be uploading it to GitHub.

Sure, tell me what you are looking.

@@ProgrammingIsFunn , Can you also post a video like downloading the files from the sharepoint, data cleansing and uploading the output files into the sharepoint again !!!

Glad it was helpful!

I'm so glad to hear that my content has had a positive impact on you!

Yeah, 👍🏻

Thanks for the visit

I'm glad!

Keep watching

Help me with your prompt.

Thank you for the positive feedback! I'm glad you found it informative.

It's not always necessary to provide the database name, but it can help to narrow down the context for a more accurate response.

You can run n number of time I think 💭.

kzfaq.info/get/bejne/m6uGepBymbidh4k.htmlsi=pJrF2J5bdY5xH_FQ

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.

Can you tell in which statement you are facing an error

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

@@ProgrammingIsFunn error solved , thanks

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

Pandas append has been depreciated, instead of append you can concat

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

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 <= datetime.strptime(d["date"], "%Y-%m-%d").date() <= st.session_state.end_date] st.write("Filtered Data:", filtered_data) # Page navigation page = st.sidebar.selectbox("Select a page", ["Page 1", "Page 2"]) if page == "Page 1": page1() elif page == "Page 2": page2()

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

Yes here we are using nested filters

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

This is vanna api key

You can register your self on vanna platform and get api key. vanna.ai/docs/vanna.html#getting-an-api-key

@@ProgrammingIsFunn Is it paid one?

No, Internet is required for the same, because we are using llm api key for each request

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.