CSV Insight Analyzer

Objectives

• Implement CSV file upload and parsing with column type detection
• Display summary statistics for each column (mean, median, mode, min, max)
• Use AI to generate a plain-English summary of the dataset
• Detect and highlight missing values and potential outliers
• Suggest data cleaning steps based on identified issues

Hints

• Use PapaParse for robust CSV parsing in the browser
• Send column samples to the LLM to infer semantic meaning beyond raw types
• Use simple z-score or IQR methods for outlier detection before AI explanation

Resources

• www.papaparse.com/docs
• platform.openai.com/docs/api-reference/chat

Comments (0)