avcontentteam — Updated On June 24th, 2019
Big data Cheatsheet Data Science Database Intermediate Machine Learning Python R SQL Statistics


  • Data Science is constantly evolving with new tools, frameworks and technologies
  • Each tool/technique has its own unique use case along with features and functions
  • Refer to this exhaustive list of cheat sheets concerning popular Data Science concepts


Data Science is an ever-growing field, there are numerous tools & techniques to remember. It is not possible for anyone to remember all the functions, operations and formulas of each concept. That’s why we have cheat sheets. But there are a plethora of cheat sheets available out there, choosing the right cheat sheet is a tough task. So, I decided to write this article.

Here I have selected the cheat sheets on the following criteria: comprehensiveness, clarity, and content.

After applying these filters, I have collated some 28 cheat sheets on machine learning, data science, probability, SQL and Big Data. For your convenience, I have segregated the cheat sheets separately for each of the above topics. There are cheat sheets on tools & techniques, various libraries & languages.

Read on to know which cheat sheet to use for a particular topic.



Python for Data Science Cheat Sheets

1.Quick Guide to learn Python for Data Science python

If you are starting to learn Python, then this cheat sheet is the best resource for you. In this cheat sheet, you will find a step-by-step guide to learn Python. It gives out resources to follow, Python libraries you must know and few helpful tips.


2. Python for Data Science Cheat sheet  python, data science

This cheat sheet by Datacamp covers all the basics of Python required for data science. If you have just started working on Python then keep this as a quick reference. Mug up these cheat codes for variables & data types functions, string operation, type conversion, lists & commonly used NumPy operations. The unique aspect of this cheat sheet is it lists down important Python libraries & gives cheat codes for selecting & importing these libraries.


3. Python For Data Science Cheat Sheet NumPy numpy, python

NumPy is a core library for scientific computing in Python. In this cheat sheet from DataCamp you will find cheat codes for creating NumPy arrays, performing mathematics operation on array, subsetting, slicing, indexing & array manipulation. The unique aspect of this cheat sheet is it gives each function has been categorized & explained in simple English.


4. Exploratory Data Analysis in Python EDA, exploratory data analysis, python

Your best resource to perform data exploration in Python using NumPy, Pandas & Matplotlib. With this cheat sheet you will learn how to load files in python, convert variables, sort data, create plots, create sample datasets, treat missing values & many more. It is one of the simplified cheat sheet on data exploration.


5. Data Exploration using Pandas in Python  pandas, python

Pandas is one of the important libraries in Python. This cheat sheet on data exploration operation in Python using Pandas is your go-to resource to know each step involved in data exploration. You will find cheat codes for reading & writing data, preview of dataframes, rename columns of dataframe, aggregate the data, etc.


6. Data Visualisation in Python data visualization, python, seaborn, numpy, scipy, pandas

Be it a data scientist or a non-techie, visualization is easily interpreted by both. In visual graphs & plots, data comes to life & speaks for itself. In this cheat sheet, learn how to perform data visualization in Python. Explore the different ways in which you can plot your data. Find step by step approach to plot histograms, bar charts, line graph, scatter plot, etc.


7. Python For Data Science Cheat Sheet Bokeh data visualization, python, bokeh

This cheat sheet on Bokeh, an interactive visualization library in Python is especially useful with large datasets. In this cheat sheet by DataCamp, you will get basic steps for plotting, renderers & visual customization, save plots & create statistical charts.


8. Cheat Sheet: Scikit Learn sklearn, python, machine learning, scikit-learn

Here is a cheat sheet on scikit-learn for each technique in Python. It provides different functions used for pre-processing, regression, classification, clustering, dimensionality reduction, model selection & metric along with their description. The unique aspect of this cheat sheet is it depicts the complete stages of machine learning.


9. Steps To Perform Text Data Cleaning in Python   python, data cleaning

Text cleaning can be a cumbersome process. And knowing the right procedures is the key to getting the desired result. Refer this cheat sheet to perform text data cleaning in Python step by step. Follow this cheat sheet to know when you remove stop words, punctuation, expressions, etc. The unique aspect of this cheat sheet is each step has been explained with codes & examples.


R for Data Science Cheat Sheets

1.R Reference Card R

Use this reference sheet for cheats codes for all functions & operators under R. Understand what the different terms mean under R. It explains all the functions under data creation, data processing, data manipulation, model function, selection and many more.


2. Data Import in R R, data import, readr, tibble, tidyr

Learn how to import data with readr, tibble and tidyr. Find functions to write & read functions in tibble. It also provides you useful arguments, reshape data, combine cells with tidyr.


3. Data Transformation with dplyr  R, data transofrmation, dplyr

This cheat sheet from RStudio is a reference material for data transformation with dplyr. Get short codes & operators for all operations under data transformation. Then be it summarize cases, group case, manipulation, vectorize & combine variables.


4. Cheat sheet – 11 Steps for Data Exploration in R (with codes) R, data exploration

This cheat sheet gives a step by step guide to  data exploration in R. Learn how to load file in R, convert variables to different data types, transpose a dataset, sort dataframe, create plots & many more.


5. Data Visualization in R   data visualization, R

Above we saw cheat sheet on data visualization in Python. Here is a data visualization cheat sheet to give the different graphs by which you can plot the data. With a few lines of code, you can create beautiful charts and data stories. R has awesome libraries to create basic and more evolved visualizations like Bar Chart, Histogram, Scatter Plot, Map visualization, Mosaic Plot and various others.


6. Data Visualization with ggplot2  R, data visualization, ggplot2

This cheat sheet is specifically for creating a visualization in R using ggplot2. ggplot2 works on the grammar of graphics and is built on a set of visual marks that represent data point. Get cheat codes to create one variable & two variable graphical component. Along with different techniques for creating plots in R.


7. Cheat sheet: Caret Package  R, caret

Caret package provides a set of functions that streamlines the process of creating predictive models. The cheat sheet includes functions for data splitting, pre-processing, feature selection, model tuning & visualization.


8. R Reference Card for Data Mining R, data mining

This cheat sheet provides functions for text mining, outlier detection, clustering, classification, social network analysis, big data, parallel computing using R. This cheat sheet gives you all the functions & operators used for data mining in R.


9. Guide to quickly learn Cloud Computing in R Programming  R, cloud computing

Cloud computing has made it very easy for us to access our files & data from anywhere. In this cheat sheet, you will learn about how to use cloud computing in R. Follow this step by step guide to use R programming on AWS.


Machine Learning Cheat Sheets

1.Cheat sheet – Python & R codes for common Machine Learning Algorithmsmachine learning, R, Python

In this cheat sheet, you will get codes in Python & R for various commonly used machine learning algorithms. The algorithms included are Linear regression, logistics regression, decision tree, SVM, Naive Bayes, KNN, K-means, random forest & few others.


2. Scikit Learn algorithm Cheat sheet  scikit-learn, sklearn

This cheat sheet is provided from the official makers of scikit-learn. Many people face the problem of choosing a particular machine learning algorithm for different data types & problems. With the help of this cheat sheet, you have the complete flow for solving a machine learning problem.


3. Microsoft Azure Machine Learning: Algorithm Cheat Sheet microsoft azure, azure, machine learning

This cheat sheet helps you choose the best Azure Machine Learning Studio algorithm for your predictive analytics solution. Developed by Microsoft Azure team itself cheat sheet gives you a clear path as per the nature of the data.


Probability Cheat Sheets

1. Probability Basics  Cheat Sheet statistics, probability

This cheat sheet provides you a comprehensive reference material for probability & statistics. Each concept has been explained marvelously with a diagrammatical explanation. It covers from the basic probability rules to advanced statistical concepts in a very precise & accurate manner. Developed by the University of Pennsylvania, it is one of the most comprehensive cheat sheets you can lay your hands on.


2. Probability cheat sheet for distribution statistics, probability, distributuion, probability distributiion function, pdf

Refer this cheat sheet for a quick overview on Poisson Distribution, Normal distribution, Binomial Distribution, Geometric Distribution and many more. It gives notation, formulas & a brief explanation in simple English for each distribution.


SQL & MySQL Cheat Sheets

1. SQL Cheat Sheet SQL, sql

In this cheat sheet, learn how to perform basic operations in SQL. Get function for inserting data, update data, deleting data, grouping data, order data, etc. If you have started using SQL this the best reference guide.


2. MySQL & SQL Cheat Sheet  sql, mysql

In this cheat sheet, you will find commonly used MySQL & SQL commands. Get cheat codes for MySQL mathematical function, MySQL string function, basic MySQL commands. You will also find SQL commands for modifying & querying.


Big Data Cheat Sheets

1. Hadoop Cheat sheet hadoop, big data

It is rightly said Hadoop has a vast ecosystem & includes various operations. Learn about the various operators, how they work & what operation they are responsible for. The cheat sheet has been broken down into a respective general function like distributed systems, processing data, getting data in/out & administration.


2. Apache Spark Cheat sheet  apache spark, spark, big data, rdd

Here is a cheat sheet for Apache Spark for various operations like transformation, actions, persistence methods, additional transformation & actions, extended RDD, streaming transformation, RDD persistence, etc.


3. Hive Function Cheat Sheet hive, big data

In this cheat sheet, get commands for Hive functions. It provides cheat codes for data functions, mathematical function, string function, collection function, built-in aggregate function, built-in table generating function, conditional function and functions for text analytics.


End Notes

I hope you enjoyed reading this article. If I have missed out any cheat sheet which you think should be included in the list. Then post them in the comments section. The other reader & I would like to know about them.

If you have any suggestions/feedback then don’t forget to share it by dropping in your comments. Tell us what more cheat sheets you would like us to publish.

Learn, compete, hack and get hired!

About the Author


Our Top Authors

Download Analytics Vidhya App for the Latest blog/Article

31 thoughts on "Top 28 Cheat Sheets for Machine Learning, Data Science, Probability, SQL & Big Data"

Shortt says: February 17, 2017 at 1:35 pm
HTML cheat sheet Reply
Virat says: February 17, 2017 at 2:51 pm
Thanks Swati, these are really helpful! Reply
rob van putten
rob van putten says: February 17, 2017 at 4:21 pm
It's already getting old.. tensorflow will be in higher demand than scikit-learn.. Reply
Aman Sinha
Aman Sinha says: February 17, 2017 at 6:13 pm
This is great! Thanks. Reply
Swati Kashyap
Swati Kashyap says: February 17, 2017 at 6:16 pm
Hi Shortt, Thanks for a suggestion. Do you happen to know any particular cheat sheet for HTML? Reply
Swati Kashyap
Swati Kashyap says: February 17, 2017 at 6:17 pm
Thanks Virat! I'm glad you found it helpful. Reply
Swati Kashyap
Swati Kashyap says: February 17, 2017 at 6:17 pm
Hi Rob, We can only wait & watch. Reply
Swati Kashyap
Swati Kashyap says: February 17, 2017 at 6:19 pm
I'm glad Aman,you found it helpful. Reply
Swati Kashyap
Swati Kashyap says: February 17, 2017 at 6:19 pm
I'm glad Aman, you found it helpful. Reply
Alfredo says: February 18, 2017 at 10:49 pm
Very, very nice and useful ... Thankyou!!! Reply
Carlos says: February 19, 2017 at 1:02 am
Dude, this was one of the most helpful tool for those who works with data! This is so handy! Smart is not who has all answers, but who can find them where they are... Tks a lot. Carlos Reply
Swati Kashyap
Swati Kashyap says: February 19, 2017 at 6:55 am
Thanks Carlos :) Reply
Swati Kashyap
Swati Kashyap says: February 19, 2017 at 6:55 am
Your welcome Alfredo. Reply
Ganesh Verma
Ganesh Verma says: February 19, 2017 at 7:09 am
Amazing guys! Genuinely I needed them. All the best and Thanks a lot :) Reply
Srinivas says: February 19, 2017 at 11:56 am
Very useful, awesome work Swathi. Reply
Lokesh Sharma
Lokesh Sharma says: February 19, 2017 at 5:47 pm
Great work! Reply
Prashant Kumar Mehta
Prashant Kumar Mehta says: February 21, 2017 at 6:15 am
Thanks Swati ..really needed the probability cheatsheet Reply
shan4224 says: February 21, 2017 at 2:53 pm
Nice compilation. How about adding SAS sheet in it.. Thanks for the effort . Reply
Viswaprakash91 says: February 21, 2017 at 3:21 pm
These are some amazing stuffs..really helpful for beginners. A big thank you :) Reply
Jinson Fernandez
Jinson Fernandez says: February 26, 2017 at 5:59 pm
awwsumm stuff.......its a one-stop-shop for cheat sheets Reply
[email protected] says: February 28, 2017 at 6:27 am
Great help!! Reply
Deepak Jha
Deepak Jha says: April 02, 2017 at 6:34 pm
Great job for freshers. Thank you. Reply
sampath says: April 21, 2017 at 3:51 pm
Hi Swati, Very good article. Most of the things put to together. I would like to add sparklyr and pyspark cheatsheet to the list. http://spark.rstudio.com/images/sparklyr-cheatsheet.pdf https://www.datacamp.com/community/blog/pyspark-cheat-sheet-python#gs.L8_uwbo Regards, Sampath. Reply
Datta Tele
Datta Tele says: April 23, 2017 at 4:41 pm
Excellently simplified in one page! Reply
Amit Kumar Kashyap
Amit Kumar Kashyap says: May 17, 2017 at 1:16 pm
Great post !!! This is really helpful. Thanks a ton Swati. Reply
Hanu says: March 20, 2018 at 7:42 pm
One page solution to All my headaches to start my journey wit data analysus. Tq Reply
Tushar says: April 05, 2018 at 10:01 pm
One of the best article, I have come across. Reply
Sanjeev kumar
Sanjeev kumar says: April 07, 2018 at 6:10 pm
This is great . Keep on writing . Data Science community is thankful to you Reply
Aishwarya Singh
Aishwarya Singh says: April 09, 2018 at 1:09 am
Hi Sanjeev, Thank you for the feedback. Reply
Shailesh says: April 10, 2018 at 12:11 am
This is the best compilation of cheatsheets for Data Science I've ever found. Thank you so much Swati! Reply
Dhiraj says: August 23, 2022 at 12:48 am
Thanks a lot to the analyticsvidhya team for posting such great article with huge information which is the key of every beginner for clearing interviews as a data scientist Thanks a lot . Reply

Leave a Reply Your email address will not be published. Required fields are marked *