ChatDATA | Chat With Any Tabular DATA | pandas-ai | Pandas

preview_player
Показать описание
ChatDATA | Chat With Any Tabular DATA | pandas-ai | Pandas

In this video, I will show how you can interact this csv and also create charts out of it, just by providing the text using a python library called pandas-ai. You can incorporate the code so that the pandas df can read any other format of data also. Happy learning.

👉🏼 Links:

🔗 Other videos you might find helpful:

#openai #llm #datasciencebasics #chatdata #aiassistant #csv #charts
Рекомендации по теме
Комментарии
Автор

You are simply amazing, please continue to bring us your knowledge and ideas, thanks a lot!!!!

RacingMachine
Автор

Can you tell me how we can chat with pdf that contains tables in it along with text ?? please suggest it is really important

AbhishekKumar-hjf
Автор

how can we get this in streamlit interface?, when user ask prompt for chart then chart should be generated

khushikoshti
Автор

Traceback (most recent call last):
File "C:\Users\km1949\Desktop\GT\main.py", line 2, in <module>
from pandasai import PandasAI
ImportError: cannot import name 'PandasAI' from 'pandasai'

kunalmisra
Автор

What if your text file doesn't contain a perfect tabular data format.. for example, the file has 2 line headers that repeats throughout, as well as some of the rows don't contain all the data:

#Time (HHH:MM:SS): 002:34:02
# T(ms) BUS CMD1 CMD2 FROM SA TO SA WC TXST RXST ERROR DT00 DT01 DT02 DT03 DT04 DT05 DT06 DT07
# === ==== ==== ==== == ==== == == ==== ==== ==== ==== ==== ==== ==== ==== ==== ====
816 B0 D84E BC RT27 2 14 D800 2100 0316 0000 0000 0000 0000 CCCD 0000
817 A0 DC50 RT27 2 BC 16 D800 2120 0000 4080 3000

#Time (HHH:MM:SS): 002:34:03
# T(ms) BUS CMD1 CMD2 FROM SA TO SA WC TXST RXST ERROR DT00 DT01 DT02 DT03 DT04 DT05 DT06 DT07
# === ==== ==== ==== == ==== == == ==== ==== ==== ==== ==== ==== ==== ==== ==== ====
056 B0 D84E BC RT27 2 14 D800 2100 0316 0000 0000 0000 0000
057 A0 DC50 RT27 2 BC 16 D740 2120 0000 4080 3000 0000 3000 0000 0000


How can I do pd.read_table to get just the data from DT00 thru DT07 into an array, without doing lots of preprocessing to scrub out the repeating #Time headers that appear throughout the file?

Is there a way to do it, either using df = pd.read_table("file.txt", header[0, 1])? or using read_c/tsv? And what would python return if trying to access a dataframe element that doesn't contain data? ex.
df.index
df.loc[0:3]

bennguyen