Data Science Cheat Sheet Bundle, NumPy, Pandas, SQL Joins, Data Visualization, Data Analyst Study Guide, Printable PDF

A data science cheat sheet bundle: NumPy arrays, pandas tables, SQL queries and choosing charts, four visual study guides with 16 pages.
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.

FOUR TOOLS, FOUR STUDY GUIDES
What shape is my array? How do I filter, group and join a table? Which rows does my SQL query return? Which chart should I make, and can I trust the data? Four of our visual data science study guides answer them in working order, in one download and at a lower price than buying them separately. Each one is two sheets, printed on both sides (4 pages), with a Test Yourself version. Instead of lists of syntax, the sheets draw what happens to the data, and every code example and query shows its real result, checked by running it.

1. NUMPY: SHAPES, AXES & BROADCASTING (4 pages)
- the same 12 values as a 1-D, 2-D and 3-D array: shape, ndim, size, and what an axis really is
- indexing with the selected cells shaded; "Will these shapes broadcast?" step by step
- views or copies, reshape, transpose, concatenate vs stack
- reductions along an axis, keepdims, * vs @, vectorization

2. PANDAS: FILTERING, GROUPING, JOINING & RESHAPING (4 pages)
- what a DataFrame is; loc vs iloc on the same table; filtering with a boolean mask
- "What do you want to change?": nine common tasks, each with a before -> after table; missing values
- groupby as split, apply, combine; agg (6 rows -> 3) vs transform (6 rows -> 6)
- how many rows a merge makes, pivot_table and melt, concat

3. SQL FOR DATA SCIENCE: QUERIES, JOINS, AGGREGATIONS & WINDOWS (4 pages)
- which rows survive each clause: written order vs logical processing order, drawn
- NULL and UNKNOWN; the four joins on the same two tables; filter in ON or in WHERE?
- GROUP BY, COUNT and NULL, WHERE vs HAVING, a CTE
- window functions: ranking with ties, top 1 per group, running totals and the frame

4. DATA VISUALIZATION & EDA: WHICH CHART SHOULD YOU USE? (4 pages)
- six questions, six charts, all drawn from one table
- how bin widths change a histogram; box plots with fences vs whiskers
- reading a scatter plot and r; a trailing 7-day mean
- a 7-step workflow for exploring a new table, with honest decisions about missing and unusual values

The pandas and SQL sheets both cover joins and grouping, each in its own tool with its own example data, so you see the same ideas in Python and in a database.

TEST YOURSELF VERSIONS
Every sheet also comes with its Test Yourself version: the same pages with the answers left blank. Fill them in from memory, then check yourself against the cheat sheet.

WHAT YOU GET: 32 PDF FILES (in one ZIP, one folder per cheat sheet)
- 4 cheat sheets, each as Cheat Sheet and Test Yourself
- 2 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 in a first data science or data analysis course, junior data analysts, bootcamp learners, career changers, and anyone preparing for a data analyst interview. Assumes basic Python for the NumPy and pandas sheets; the SQL and visualization sheets need no Python.

HOW IT IS MADE
Typeset in LaTeX; every diagram, table and chart is drawn by code from real results, no AI image generator was used. The content and the code were prepared with help from an AI assistant. Every code example was run by a script (NumPy 2.5, pandas 3.1; every SQL query on PostgreSQL, SQLite and DuckDB) and its result checked, and the content went through several independent reviews.

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.
- These are the same files as our NumPy, pandas, SQL and Data Visualization cheat sheet listings: no need to buy those as well.
- These are focused study guides, not a complete reference for any of the tools.
- 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: the Python Beginner Cheat Sheet Bundle, the Python basics before data science.

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