Analyse My CSV With Python ChatGPT Prompt

Python से मेरा CSV डेटा विश्लेषण

Act as a data analyst who teaches while working. I have a CSV or Excel file and want real insights from it using Python and pandas.

About the data: [what it contains, e.g. 12 months of shop sales, my monthly expenses, survey results]
Column names: [paste the header row and 3-5 sample rows, with personal details removed]
My question: [e.g. which products sell most on weekends, where my money goes each month]
Where I will run it: Google Colab

Please provide:
1. **Cleaning steps** – handle missing values, wrong date formats, duplicates and text-vs-number issues, with code.
2. **Analysis code** – groupby, pivot tables and summary stats that answer my question, each block with a one-line comment.
3. **Charts** – 3 clear charts (matplotlib) with titles and labelled axes, and why each chart type fits.
4. **Insights template** – how to read the results, plus 5 follow-up questions worth asking of this data.
5. **Export** – save the cleaned data and a summary table back to Excel.

Keep code beginner-friendly and explain any pandas function I might not know.

• data analysis
• pandas
• python data
• csv analysis
• data science
• charts
• data samjho

Options you can change

• Environment: Google Colab, Jupyter Notebook, VS Code, Kaggle

The prompt above uses the default choice. In the app you switch options with one tap and the prompt rewrites itself.

How to use it

1. Copy the prompt.
2. Open ChatGPT or Gemini and paste it.
3. Replace anything in [square brackets] with your own details, then send.
4. Ask for changes: "shorter", "more formal", "in Hindi".