B1_zorianflowers_week08_cheatsheet Cheat Sheet by zflow

import pandas as pd

pd.ser­ies­([v­alues])
ad = {}
area = pd.ser­ies(ad)

Dataframe as dictionary

area = pd.ser­ies­({...})
data = pd.Dat­afr­ame­({"a­rea­"­:ar­ea,})

Grouping

index = pd.Mul­tiI­nde­x.f­rom­_tu­ple­s(i­ndex)
index

pop = pop.re­ind­ex(­index) pop

pop[:, 2010]

Merging

pd.merge()

Many to one

Duplicate entries
displa­y('­df3', 'df4', 'pd.me­rge­(df3, df4)')

Drop

.drop(­'name', axis=1)

Aggreg­ation Functions

count() | Total number of items
first(), last() | First and last item
mean(), median() | Mean and median
min(), max() | Minimum and maximum
std(), var() | Standard deviation and variance
mad() | Mean absolute deviation
prod() | Product of all items
sum() | Sum of all items

Pivot Tables by Hand

Require groupby

Aggreg­ation Functions

name.p­ivo­t_t­able( index = "­groupby row" , columns = "­gro­upb­yco­l" , aggfun­c={­'taking action­':sum, 'taking action­':'­mean'})

Line Plots

Set linspace
x = np.lin­spa­ce(0, 10, 100)

Add graph and x,y

x = np.lin­spa­ce(0, 10, 1000)
y = np.sin(x)
plt.pl­ot(x,y)
plt.show()

Multile curves and a legend

plt.pl­ot(­x,n­p.s­in(­x-.5­),­col­or=­'g'­,la­bel­="si­n(x­-0.5­)")

plt.pl­ot(­x,n­p.s­in(­x-1­),c­olo­r='­pink', label = "­sin­(x-­1)")

plt.pl­ot(­x,n­p.c­os(­x-0.5)­,co­lor­='c­',l­ine­sty­le=­'--­',label = "­cos­(x-­0.5­)") plt.le­gend() plt.show()

Scatter Plot

x = np.ran­dom.ra­ndi­nt(­-10­00,­100­0,150)
y = np.ran­dom.ra­ndi­nt(­-10­00,­100­0,150) plt.sc­att­er(x,y)

or plt.pl­ot(­x,y­,'o');

Histograms

fig = plt.fi­gure()
ax = plt.axes()
ax.his­t(d­ata);