Real-world-shaped CSV datasets plus step-by-step practice tasks for learning Excel, Google Sheets, SQL and Python (pandas). Every file is free to download and use in class, in assignments, or for your own portfolio projects.
If these datasets helped you, please ⭐ star the repo so other learners can find it.
| Dataset | Rows | Columns | Good for | Practice task |
|---|---|---|---|---|
| Sample - Superstore.csv | 9,994 | 21 | Sales & profit analysis, pivots, dashboards | — |
| Nescafe.csv | 4,248 | 25 | Data cleaning, text & date functions, budget vs actual | Task 01 |
| uber_trips_dataset_50k.csv | 50,000 | 14 | Large-sheet analytics, time & distance analysis | Task 02 |
| everlasting_earrings_sales_300_rows.csv | 300 | 11 | Pivot tables, regional sales reports | Task 03 |
| Walmart.csv | 3,203 | 12 | Order & shipping analysis, category performance | — |
| transaction.csv | 100 | 10 | Expense tracking, conditional aggregation | — |
| coca_cola_customer_reviews_dirty.csv | 100 | 7 | Cleaning messy survey data, text analysis | — |
- GeneralProcess.md — end-to-end data analysis workflow, from sourcing to statistics
- Task_02_Notes.md —
IF,IFS,COUNTIFS,SUMIFS,AVERAGEIFSand friends, with examples - AnalyticsMastery.md — array formulas and what-if analysis in Google Sheets
Download one file: open the CSV above, then click Download raw file.
Load straight into pandas:
import pandas as pd
url = "https://raw.githubusercontent.com/edusatyaki/Dataset/main/Nescafe.csv"
df = pd.read_csv(url)
df.head()Load into Google Sheets: =IMPORTDATA("https://raw.githubusercontent.com/edusatyaki/Dataset/main/transaction.csv")
Clone everything:
git clone https://github.com/edusatyaki/Dataset.gitNescafe.csvandcoca_cola_customer_reviews_dirty.csvcontain deliberate mess (extra spaces, mixed case, Excel serial dates) — cleaning them is part of the exercise.Sample - Superstore.csvis the classic Tableau sample dataset, included here for practice.
Maintained by Satyaki Das · Data Analytics instructor