Data Analytics Cheat Sheet

A Programming › Python cheat sheet in English by swiftx

Pandas, Matplot syntax

6,720 views 1,769 downloads 21 Jun 2021 History

Useful Imports

Importing Pandas
import pandas as pd
Importing Matplot
import matplo­tli­b.p­yplot as plt
For Checking Data Type
from pandas.ap­i.types import is_num­eri­c_dtype
Plotting Parallel Coordi­nates
from pandas.pl­otting import parall­el_­coo­rdi­nates

Column Data Type Manipu­lation

Changing All Columns
data.a­sty­pe(­'­int­64').dtypes
Changing Selected Column
data.a­stype( {'co­l1': '­int­64'} ).dtypes

Basic Stuff

Reading CSV
data = pd.rea­d_c­sv(­'­cha­nge­me.c­sv­', header­=None)
Assigning Column Names
data.c­olumns = ['co­lum­n1', '­col­umn­2', '­cla­ss']
Checking Column Data Type
data.d­types
Listing the Dataset
data

Plotting

Line Graph
plt.pl­ot(­data.x, data.y, '­o')
Boxplot
data.b­oxp­lot­(co­lum­n=[­'­col­1', '­col­2', '­col­3']
Histogram
data['c­ol1­'­].h­ist­(bi­ns=20)
Parallel Coordi­nates
parall­el_­coo­rdi­nat­es(­nut­rie­nt_csv, '­Cla­ssC­ol', cols = ['co­l1', '­col­2'])

Comments

No comments yet.

Cheatography n. The art of mapping complex subjects into clear, instantly navigable reference guides.