ChatCSV Streamlit App: Chat with CSV files using PandasAI and OpenAI

In this video, we explore the latest advances in Generative AI with the help of PandasAI, a new library that helps you chat with your CSV files. With ChatCSV streamlit app that we built, you can now chat with your CSV files and get instant insights and recommendations, all without having to write a single line of code. Just change your Open AI API key in the env file and you are set! I walk you through the process of creating your own ChatCSV app.

Whether you're a data analyst, a business owner, or just someone who wants to make sense of their data, ChatCSV is the perfect tool for you.

#python #coding #generativeai

[blhijez]

Thanks for sharing but plez i could not install pandas ai in visual studio keep saying there is no module pandas ai could you advice please

[balasrinivas]

Looking for pandasai with local llm's to run on CPU(though it is slow). can you suggest?

[samketola]

what if the names of the columns are not self-explanatory. how to insert additional explanations (meta data)

[kundantiwari]

very informative video but sir i was facing an error...Can't instantiate abstract class PandasAI with abstract method chat could you plz help me out

[perumal]

Nice work👏👏, It will make data analytics part more easier..

[e-Course]

Can we connect that to own chatbot with API?

[sivatech]

I've an issue with pandasAI running in my system😢, can anybody plz help,
I am getting value error : numpy.dtype size changed, indicate binary incompatibility

[sourabh]

what are the changes needs to be done if we want to use Azure OpenAI. !!
Did try to use it but was not successful

[JiteshPatil]

Hi...Getting below error while running the app

ImportError: cannot import name ‘PandasAI’ from ‘pandasai’ (C:\Users\RONALD

[danielstiefel]

My question is… my data that was in the csv… is it now part of chatGPT data? For example, if someone knew I was using it… could they ask questions about my company… and get answers?

Thanks!

[shekarshekar]

hey Although I am using Paid API key, the API is taking a long time to respond. is there any chance, we can improve the Performance?

[kunalmisra]

can it generates graph on the streamlit platform as well?

[andreyseas]

Nice. :) How can I output visualizations for the data using natural language? Python REPL tool?

[muhammadtalmeez]

can we use open source models for this? like llama2 or mixtral

[hariomgupta]

how to show chart in response to django template.

[RedCloudServices]

Can you add visualization Plotly or even better would be PyViz or variable to select the best one for the question 🤷‍♂️

[ramp]

Good video. thank you for sharing. Is there a way to display the graph generated by the pandas AI in the UI? For example, "Plot the histogram of countries showing for each the gpd, using different colors for each bar"? Thank you

[khushikoshti]

can we use azure open ai and use this?

[sanakmukherjee]

when will it add conversational memory to it

[amosmaru]

Is there a way this could be open source?