Page No.
Dat
2 PYTHON PANDAS
TTE RATING OVER A DATAFRANE
Sn auch a cae,tiing denenate Atabeme
fot aiqntag Laceuing eiduidua! vau
l maRe th pAs umbersome hu
fot ch a thing,yeu need te
to iterate
waiys aiaing
Ling ishich yau
j¿u Can Hinate
lue a datarame Mot coåmon shich
e <DFobje ct>. tterTóws)and tfsject
<Dfobjet. terttems C.
# BINARY PERATIONS' IN A OATAFRANE:
|Binay AoatinA meandatt
thede yalues Ae plcked aiemnt-ise
n a bininy battenthe data' eon
tuo datyams ane aigneds
the dls atneie Hes and couma
Linderes and et inl matchino Het
Kms tnder the qien snuatien e
nyemed and pe the nonmotching
A c t u mendeXe NaN alue is
# fUNCTUONS: NIN) AND MAX C)
<datoframe >min (axís =None, skipna- None
.umeriC-ony =None)
<datoframe >.Mr(axs =None. kipna = None,
numeric-only= None)
Page No.
Date
the minimium maimum waue
daa
Llataame
PARAMETERS
0AXIS - (o ot 1) [Link] bot maximu
Acalculated along auis:o ftndex (o).celumn
(1
b) SKeNA - (Tue cr false) Exclude NAn NAN valuea
when computtug tae 1esult
ONUNERIC-ONLY - (True or false) fnclucde att e
float ntboolean coluns for callulatin
NA B} max4 None,. wl will attempt to e
Aeynng than ute sny nimeic data.
#UNCTIONS mode ()meanci MedianC
uncteA model meanc me dianc)ate
the felSuing
’ Mode0
’netuN the mode yalue lie he vaue hat
Malliea)tm
<datarame>. mode (oxis =O, numeric -ony = false)
Page No
Date
he mode ) gcta the mode(s) ad eachaeme
ot node
wlt NaN
’MeanCy
Retwn he cênputed mean (aérag) en
a det Vale
<data frame s. mean(axis- None, skipna =None
DuMeric-onlyeNone)
he uncien Meac Htwcns th
Kemputed inean taage e equst
Median C)
RttA the midde numbe Jum
qeem adit
Hetus themedian
hay e a'dct.
<datafrom.e>.median(axí=NGNe,stipna=None
Dumenic-onyNpnc
vabes ot the EquELted' ali
Page No.
Date
tt FUNCILONS couatc, iand sum)
vaueA NoneNaNtC e Lonaidued
NA en fandas.
ceuntC)
Kd ataframecount (ais =0, numeric-ony= false)
LSyntar 4et sumO
kdatatrame~. sum[axis =None skipna
skipna =
= None, nunMeric-onu=None
min-coto)
# he descx ibewuntLên
dhe dscxintçn cunctlens ike count
meaa, minimummaximun etc. can be
namely .describe )
<DF> describeO
th. desccibe ) functlen qied yeleung
datail:
Count
Meaa
Std
Min:
25/. 5o%5%
Hax
Page No
Date
INSPECTíoN FUNCTION tafoC)
Ne insuct tebady e to qet baic
injermatten. alout ysueLdatarame
<DF> ofoC)
dhis funtlen qiuei qoleng inotmay
Indea Valuel
Data coumns &Values in them
Dataty pe e each coumn
DATAFRANES Top AND 9oTTOM ROwsUSiNG
head andtal()
<DF>.head (Cn=51)
<DF> tail(Cn= 6])
HANDLNG MISSING A TA
tiaing vae Ae the values that ican
Nt entbte to any cenuputatten
ualeesae
thevas that cau no emutattona
Page No
Date
Algntcatien
# DETECTING ELTERNG MISSNG DATA
isnulcO to cect mMing
Nalues na fandau obËect Jt ilwn True
ot false qot Lach vaue en a Panday objet
<fandaobËect>. îsnul O
>>> dtSer. tsnll ()
False
True
2 False
True
false
dtype: boo|
>>> patent DF. Rsnull l)
First-name Last-name Age Sex Val BeforeValAfter
false false folse false Palse False
True True True True Tyue True
2 false false false false True True
False false false False false False
false false fale false False false