AI Data Analyzer

📖 Overview

โยนไฟล์อะไรมา คอลั่มแบบไหนก็คิดและเอามาทำกราฟ — รองรับ CSV/XLSX/TSV/JSON auto-detect type

🛠️ Tech Stack

Papa Parse
SheetJS
Chart.js
chartjs-chart-matrix

🏷️ Tags

csv
xlsx
charts
auto-ai
heatmap

v1.2

AI Data Analyzer v1.2 — Heatmap + Filters + Insights + Pagination

released 2026-07-08

🗣️ User Command

อยากได้ heatmap + กรองข้อมูลตาม category + insights panel + pagination

🤖 AI Response

เพิ่ม heatmap matrix (chartjs-chart-matrix) + filter chips per categorical column + insights panel (totals/avg/range/diversity/missing) + 50-row pagination with prev/next/jump

✅ What Changed

Heatmap chart — cat1 × cat2 matrix with numeric z-value (avg), color intensity scale
Filter chips — click categorical values to filter (multi-select), live re-render of all charts with filtered data
Insights panel — 5 insight cards: total/avg of numeric col, range, date range, most diverse categorical, missing cell %
Missing data warning (>30% = ⚠️ high missing rate)
Pagination — 50 rows/page with « ‹ 1/3 › » buttons
Sidebar layout — column types + filters + file meta in sticky sidebar, charts+preview in main column
KPI shows 'After filter' count vs 'Total rows' so you see filter impact at a glance

📁 1 files 📝 +920 lines 🖼️ 0 screenshots 🚀 Live → http://178.83.121.75:50900/

v1.1

AI Data Analyzer v1.1 — XLSX + scatter + regression + e-commerce sample

released 2026-07-08

🗣️ User Command

เพิ่ม .xlsx .tsv และ chart แบบ scatter พร้อม linear regression

🤖 AI Response

เพิ่ม SheetJS (XLSX/XLS) + scatter chart with linear regression line + r-value display + line chart for date-time series + 3rd sample dataset (e-commerce 600 rows with order_id/category/channel/month/quantity/price/rating/returned)

✅ What Changed

XLSX support via SheetJS (reads .xlsx and .xls, converts numeric cells to strings for consistent type detection)
Scatter chart with linear regression — slope + intercept + r-value displayed inline in legend
Time-series line chart — date × numeric aggregated by month with filled area
3rd sample dataset — e-commerce 600 orders across 12 months × 6 products × 2 channels
Each KPI card has color-coded accent bar (green/orange/blue/purple)

📁 1 files 📝 +600 lines 🖼️ 0 screenshots 🚀 Live → http://178.83.121.75:50900/

v1.0

AI Data Analyzer v1.0 — Any file → Auto charts

released 2026-07-08

🗣️ User Command

โยนไฟล์อะไรมา คอลั่มแบบไหนก็คิดและเอามาทำกราฟ

🤖 AI Response

vanilla HTML + Papa Parse (CSV/TSV/JSON) + Chart.js + auto-detect column types (>85% confidence) + auto-suggest 3 chart types (histogram, top categories bar, doughnut) + 6 KPI cards + 50-row preview

✅ What Changed

Single index.html 19KB — drop any CSV/TSV/JSON, get 3 charts auto
Type detection — number/date/boolean/text with >85% confidence threshold
Histogram with auto-bucketing into 12 bins
Top 10 categories by numeric sum (horizontal bar)
Doughnut distribution for text columns
2 sample datasets (sales 576 rows, survey 1000 rows)

📁 1 files 📝 +460 lines 🖼️ 0 screenshots 🚀 Live → http://178.83.121.75:50900/

📦 AI Data Analyzer

📖 Overview

🛠️ Tech Stack

🏷️ Tags

AI Data Analyzer v1.2 — Heatmap + Filters + Insights + Pagination

🗣️ User Command

🤖 AI Response

✅ What Changed

AI Data Analyzer v1.1 — XLSX + scatter + regression + e-commerce sample

🗣️ User Command

🤖 AI Response

✅ What Changed

AI Data Analyzer v1.0 — Any file → Auto charts

🗣️ User Command

🤖 AI Response

✅ What Changed