Pandas Cheat Sheet PDF, Python DataFrame Study Guide, Filtering, Groupby, Merge and Reshape

A pandas cheat sheet that shows what each operation does to your table: loc and iloc, filtering, groupby, merge and reshape, computed cell by cell.

THIS IS A DIGITAL DOWNLOAD. NO PHYSICAL ITEM WILL BE SHIPPED.
You will receive printable PDF files in one ZIP file. No printed or laminated sheets are included. The photos show how they look once printed.

SEE WHAT EACH PANDAS OPERATION DOES TO YOUR TABLE
A visual study guide to the fundamental pandas operations on two sheets, printed on both sides: selecting with loc and iloc, filtering with boolean masks, missing values, groupby, merge, pivot_table, melt and concat. Every table on the sheet is drawn from one small dataset and computed in pandas, so you can follow each step cell by cell. Every code example is short and shows its real result.

SHEET 1, FRONT - DATAFRAMES & SELECTION
- what a DataFrame is: index, column labels, values and one dtype per column
- Series or DataFrame? orders["qty"] vs orders[["qty"]], with their shapes
- labels or positions? loc and iloc on the same table, the selected cells shaded (a label slice includes its end)
- filtering with a boolean mask: one True / False per row, conditions combined with &, |, ~
- why the row labels stay after filtering, and when loc and iloc then differ

SHEET 1, BACK - WHICH OPERATION?
- "What do you want to change?": a decision map of nine common tasks, each with a before -> after table and what happens to the rows
- missing values: missing is not zero; isna, fillna, dropna; how NaN changes the mean and the dtype

SHEET 2, FRONT - GROUPING & AGGREGATION
- split, apply, combine: groupby drawn step by step on real rows
- named aggregation, and count vs size
- one result per group or one per row? agg (6 rows -> 3) and transform (6 rows -> 6) side by side
- keys as index or as a column, value_counts

SHEET 2, BACK - JOINING & RESHAPING
- how many rows does a merge make? inner, left and outer joins on the same two tables: 4, 6 and 7 rows
- duplicate keys multiply rows, and validate= to guard against it
- long <-> wide with pivot_table and melt
- concat, and why arithmetic lines up labels, not positions
- the chained assignment trap (Copy-on-Write) and the one-step fix

TEST YOURSELF VERSION
The same pages with the answers left blank: shade the selected cells, fill in the results, predict the row counts. The source tables and keys stay, so every exercise can be worked. Fill them in from memory, then check yourself against the cheat sheet.

WHAT YOU GET: 8 PDF FILES (in one ZIP)
- Cheat Sheet and Test Yourself
- 2 colour styles: Color, and Gray (uses less coloured ink)
- 2 paper sizes: A4 and US Letter
- each file is two sheets: 4 pages, print double-sided ("flip on long edge")
- a short READ ME with printing tips

WHO IT IS FOR
Students learning Python for data analysis or data science; self-taught learners and career changers; junior analysts; anyone preparing for a data course or technical interview who wants groupby and merge to finally make sense. Assumes basic Python.

HOW IT IS MADE
Typeset in LaTeX; every table and diagram is drawn by code from the real pandas results, no AI image generator was used. The content and the code were prepared with help from an AI assistant. Every code example on the sheet was run by a script in pandas 3.1 and its result checked, and the content went through several independent reviews. Small notes mark where pandas 2 shows something differently.

HOW IT WORKS
1. Purchase the listing.
2. Download the ZIP file instantly from Purchases & Reviews in your Etsy account (or from the link in your confirmation email) and unzip it.
3. Print at home or at a print shop at 100% / "actual size", double-sided, or open the PDF on a tablet.

PLEASE NOTE
- This is a digital product. Nothing will be shipped.
- This is a focused study guide to the fundamental DataFrame operations, not a complete pandas reference.
- Due to the nature of digital downloads, refunds are not accepted. Send us a message if you have any problem with your files and we'll gladly help.
- Colours may vary slightly between screens and printers.
- For personal use only. You may print as many copies as you need for yourself. Teachers: please message us about classroom use. Reselling or sharing the files is not allowed. (c) MIRAICO Academy, all rights reserved.
- Independent educational resource. Not affiliated with or endorsed by the projects mentioned.

Also in the shop: maths cheat sheets for the ideas behind data science (Statistics, Probability, Linear Algebra).

At MiraicoAcademy, we show how things work, not just what to type.