15.003 - Data Science Tools

My twin brother Shervine and I created this set of illustrated study guides covering the content of the Data Science part of the 15.003 Software Tools class that I have been teaching at MIT since 2020. They can (hopefully!) be useful to all students of this course as well as to anyone interested in Data Science.

Data retrieval

SQL
SQL
  • Filtering, conditions and data types
  • Types of joins (inner, full, left, right, cross)
  • Aggregations, window functions
  • Table manipulation
PDF Web

Data manipulation

R
R
  • Filtering, conditions and data types
  • Types of joins (inner, full, left, right, cross)
  • Aggregations, window functions
  • Data frame transformations
PDF Web
Python
Python
  • Filtering, conditions and data types
  • Types of joins (inner, full, left, right, cross)
  • Aggregations, window functions
  • Data frame transformations
PDF Web
R-Python conversion
R-Python conversion
  • Conversion made easy between R (tidyr, dplyr, lubridate) and Python (pandas, numpy, datetime)
Web

Data visualization

R
R
  • Scatterplots, line plots, histograms
  • Boxplots, maps
  • Customized legend
PDF Web
Python
Python
  • Scatterplots, line plots, histograms
  • Boxplots, maps
  • Customized legend
PDF Web
R-Python conversion
R-Python conversion
  • Conversion made easy between R (ggplot2) and Python (matplotlib, seaborn)
Web

Engineering tips

Git, Bash
Git, Bash
  • Version control with Git
  • Working with the terminal with Bash
  • Mastering editors with Vim
PDF Web

Would you like to see this set of cheatsheets in your native language? You can help us translating them on GitHub!