Data Science Guides
Home Ideas
<!--kg-card-begin: html-->Cheat Sheet<!--kg-card-end: html--> Cheat Sheet
Pandas Cheat Sheet for Data Science Pandas vs SQL Cheat Sheet
Home Ideas
<!--kg-card-begin: html-->Cheat Sheet<!--kg-card-end: html--> Cheat Sheet
Pandas Cheat Sheet for Data Science Pandas vs SQL Cheat Sheet
<!--kg-card-begin: html-->Getting started<!--kg-card-end: html-->

Getting started

Basic concepts

Installations

Series

DataFrame

Create

Data Types

Exercise

Cheat Sheet

<!--kg-card-begin: html-->DataFrame Attributes<!--kg-card-end: html-->

DataFrame Attributes

Basic concepts

Row

Column

Index

MultiIndex

Exercise

<!--kg-card-begin: html-->Import<!--kg-card-end: html-->

Import

Basic concepts

read_csv()

read_excel()

read_dict()

Kaggle

Exercise

read_xml()

<!--kg-card-begin: html-->Export<!--kg-card-end: html-->

Export

Basic concepts

to_csv()

to_excel

to_dict()

to_list()

to_sql()

Exercise

<!--kg-card-begin: html-->Access Data<!--kg-card-end: html-->

Access Data

Basic concepts

iloc()

Find

Filter

sort_values()

query()

Get

Exercise

<!--kg-card-begin: html-->Modify DataFrame<!--kg-card-end: html-->

Modify DataFrame

Basic concepts

groupby()

pivot_table()

Reshape

melt()

Exercise

<!--kg-card-begin: html-->String operation<!--kg-card-end: html-->

String operation

Basic concepts

replace()

split()

Regex

Search

Exercise

<!--kg-card-begin: html-->Special operation<!--kg-card-end: html-->

Special operation

Basic concepts

apply()

aggfunc

Convert

count()

unique()

Other

Performance

Exercise

map()

<!--kg-card-begin: html-->Merge & Concat<!--kg-card-end: html-->

Merge & Concat

Basic concepts

merge()

join()

concat()

Exercise

<!--kg-card-begin: html-->Data<!--kg-card-end: html-->

Data

Basic concepts

Data Validation

Data Cleaning

Categorical

Duplicate

Time Series

<!--kg-card-begin: html-->Visualization<!--kg-card-end: html-->

Visualization

Basic concepts

Styling

Table

Chart

Display

<!--kg-card-begin: html-->Challenge<!--kg-card-end: html-->

Challenge

Beginners

Advanced

Master

to_sql()

John D K
John D K
Nov 30, 2021
1 min read
Export

By using Data Science Guides, you agree to our Cookie Policy.

Accept
Data & privacy All posts Contribute → About Us Please Help
Powered by Ghost