pandas-ai icon indicating copy to clipboard operation
pandas-ai copied to clipboard

Auto-Insights

Open Edu126 opened this issue 2 years ago • 5 comments
trafficstars

🚀 The feature

Based on the table structure -Top n rows -Dataframe Descriptive //Min, Max, Avg, etc. ..

Output: List of possibles prompts

eg. "Plot a PCA with 3 clusters".

Motivation, pitch

As a BI Not even the most expert in the business is used to seeing +10 variables on a table and being able to correlate them intuitively and gets harder when they are from different areas.

As a DS Sometime you get so use to a chart or at certain type of analysys that forget to explore new approaces.

Alternatives

No response

Additional context

No response

Edu126 avatar May 10 '23 02:05 Edu126

I'd like to try this @gventuri

aryandgandhi avatar May 13 '23 16:05 aryandgandhi

Feel free to go for it @aryandgandhi, I've just assigned it to you!

gventuri avatar May 14 '23 14:05 gventuri

Hey guys for this enhacement or aditional functionality we could use pandas profiling https://github.com/ydataai/ydata-profiling. A JSON containing several preliminary insights about the dataset is among the outputs. This can be a useful first step before performing computations with the LLM. @gventuri @aryandgandhi

Edu126 avatar May 15 '23 11:05 Edu126

That's a very nice idea. Haven't tried it out, but seems super interesting and it would also be fast to implement. @Edu126 would you like to try to implement it or you'd rather someone else taking care of it?

gventuri avatar May 15 '23 22:05 gventuri

(Edit) I'm not that good at python testing yet so is better if you could work on it, here is my source code with an example in how to extract the alerts from the HTML report (Not available in other format)

Chat GPT generates : -Initial insights based on the alerts + df.head() + df.describe() -Based on the preoious data some data manipulations recommendations: An initial description for each column image image

Jupyter notebook Archive.zip

Edu126 avatar May 16 '23 02:05 Edu126

@aryandgandhi are you still working on it? Do you need some help?

gventuri avatar Jun 20 '23 15:06 gventuri