@@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!!! ❤️❤️❤️
its really helpful source available on you tube . It covers some important topics of sql in the respect of interview purpose ....... thanks for sharing
It is a beneficial and informative video, with Clear Explanations and perfect coverage of the topic. Thank you for sharing & much appreciate for your effort.
I found this as excellent video on RU-vid for SQL. This single 30 min video covers all the SQL concepts. Instead of wasting time searching for multiple videos, I will highly recommend watching this one. It will be incredibly helpful. Thanks for the sharing 👍👍
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.
hi I have tried your steps. I am getting below error while running vn.train(plan = plan) SSLError: HTTPSConnectionPool(host='ask.vanna.ai', port=443): Max retries exceeded with url: /rpc (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self-signed certificate in certificate chain (_ssl.c:1006)')))
please listen once , your videos very informative ,this is comment from your another video tittle making intractive dashboard using streamlit ( 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).
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.
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.
@@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
Hey Aman, we have done couple of project projects on streamlit. And You can also refer another tutorial let me share with you. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rviQtjkxQQY.htmlsi=BVwq49cpmUr3k5LI ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6Eu2b34alsE.htmlsi=IrQfgwKJEjrBqP4z
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
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 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 !
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.
Yes, you're right, RAG is a very interesting topic these days. I'm currently exploring and using it in greater detail, and I'll soon be uploading content related to RAG.