Practise Pandas With a Sample CSV, No Kaggle Needed

You do not need to hunt for a dataset to practise pandas. Make one in a minute and try these steps.

Open the Mock Data Generator

Generate the Students dataset in the box below and download CSV. Save it next to your notebook as students.csv.

Load and look: import pandas as pd; df = pd.read_csv("students.csv"); df.head(); df.shape; df.info(); df.describe(). Check how many rows and columns you have and which columns are numbers.

Select and filter: df["marks"].mean(); df[df["marks"] >= 80]; df[(df["year"] == 2) & (df["attendance_pct"] < 75)]; df.sort_values("marks", ascending=False).head(5).

Summarise: df.groupby("course")["marks"].mean(); df.groupby("year").size(); df["enrolled_on"] = pd.to_datetime(df["enrolled_on"]); df["enrolled_on"].dt.year.value_counts(). Save a result with df.to_csv("result.csv", index=False). To practise Parquet, download the same data as Parquet and read it with pd.read_parquet("students.parquet"), which needs pyarrow installed.

Everything runs in your browser and nothing is uploaded.

Open the Mock Data Generator

Related tool pages

  • Fake Data Generator: Generate realistic fake data online: names, emails, addresses, dates and more, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
  • Test Data Generator: Generate test data for databases and apps: names, emails, addresses, dates and numbers, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
  • Student Data Generator: Fake Student Records: Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
  • Student Marks Dataset Generator: Create a student marks dataset by student, subject and exam for SQL, Excel pivot tables and charts. Free, in your browser.
  • Sample Data for SQL Practice: Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.
  • Dummy Data for Excel Practice: Generate dummy sales, student or employee data and download Excel to practise filters, pivot tables and VLOOKUP. Free.

How to use the Mock Data Generator: step by step

  1. Generate the Students dataset and download CSV.
  2. Open a notebook and run the steps above.
  3. Change the filters and groupings.
  4. Generate another size or format to compare.

When to use the Mock Data Generator

  • Learn read_csv, filtering and groupby
  • Practise before an assignment
  • Try Parquet in pandas
  • Test code on safe made-up data

Example

Input: Dataset: Customers, 3 rows

Output: id,name,email 1,Maya Patel,maya.patel@example.com 2,Leo Fischer,leo.fischer@example.com

Frequently asked questions

Is the data real?

No. It is random and fictional, so it is safe to share.

Can I get the same data again?

No – each click makes new data. Download to keep a set.

How many rows can the Data Generator create?

Up to 500,000 rows at a time. Choose column types such as names, emails, addresses and dates, then download as CSV, JSON, Parquet or Excel.

Tip: Start with df.info() and df.describe(). They tell you most of what you need to know about a new file.