🐼
STUDENT NOTES · DAY 20 OF 24
The Data Panda 🐼
A DataFrame is an Excel sheet that obeys code. Meet pandas — the tool data scientists open every single day.
1Your first DataFrame
🐍
Py: Rows and named columns — a table! Load any CSV with pd.read_csv("file.csv") and you get exactly this.
2One column, instant answers
🤖
Bittu: No loops needed — I iterate inside. You just describe WHAT you want.
3Filtering — only the rows you want
🦉
Professor Hoot: Read it aloud: "df where df marks >= 75". Pandas filters like a bouncer with a list.
4groupby — the most useful line in data analysis
🐍
Py: Split by team → average each group. Marks per class, sales per city, goals per team — same one line every time.
5Quick quiz! 🧠
df.head() shows…
💡 A quick peek at the top of the table — always your first move after loading data.
Average marks per section, one line:
💡 groupby splits, mean computes per group. Memorize this shape — you'll type it forever.
6Your mission 🚀
Mission 1: Build a DataFrame of 5 friends: name, age, favourite snack. Print .head().
Mission 2: Filter friends older than your age.
Mission 3: In class: load the shared marks.csv and find the average per section with groupby.
Day 20 done — the panda approves! 🐼
Next: web scraping — harvest data straight from web pages.
Go to Day 21: Web Scraping →