0 ratings 0% found this document useful (0 votes) 30 views 33 pages Python Part 2
The document discusses various data formats commonly used for storing and processing data, particularly focusing on CSV (Comma Separated Values) and spreadsheet formats. It highlights the importance of data types and how to manipulate data using Python's Pandas library for data analysis. Additionally, it provides insights into handling date formats and the significance of optimizing data storage and retrieval.
AI-enhanced title and description
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content,
claim it here .
Available Formats
Download as PDF or read online on Scribd
Carousel Previous Carousel Next
Save python part 2 For Later Revctieg Dew agen
Common 4 ured fide formers
* 30ay torn
> Kise Lorne
> tat fornd~
Fe formate
+ Stared ay ude data a collec & Stored
2 Most Commenly Urecl format for Stonng date & thee
GProodsegar format Wert date & Stored fo wh L
Column g -
+ Sancrvow th Cattacl arecord :
+ Rad column Ge a Spread thur holds dake pees
t0 Same, date. type
e ghar forme Ore Compa,
© otter Roma Gaeuadis Ponh BUF | Jooro rk ops MAPY Ge,
+ Spread Sheet formal [comma Seperated Vetuss|
(2 Pome ‘lesy’
» OU record Us Seperebed Wy & cornma
> Files Whae veCord Cue, Sep ug & Re
Ore Caped tee Separaked Vous
2 csv HS Can be Opsnad Lor thy Notepad oy Miers SH egal
Eaal Spreng Shacks |
+ Spread “Sheek -foone}-
= Park & miaosopp ati
+ formal (yigx*
+ SampbA Vn OWS 2 You Mex mn Collkmny
& Scanned with OKEN ScannerVeet fpvenol™ iB
+ Con bate qb plosd teir oF ort
> Foemar | ur’
Jone oe aE
: paren necersont Girone |
s4raport OS 7 “OS Ubrany to Ganga (RL aan |
a Ampore Yard o% Rd —7 pander’ Urey row
. Changana tre WOH, AWW
Os. adi (“DF \Pendad®)
- Amporting dae (sv)
daw sey = pad resd cay ('Ens_aae—sogle, -eov")
oy doutte qucres
M He can Enctoe Piz name Mt St
sit become thar Dols frame
% dsta_eSv us) ' “
Horank cats or Yeok NAN
Removing a Sha Id Colum hy Pownng Index col =O
dala Cav = PAs eed —esv [Ytns_date— Sample = csv) 1ader_col so)
gopaurs) ie ont FEAR abun of TAO!
eTunk vabittr Gon be ceayural pecan Valuers sa
awn ag a Lit to He Porareter \ nayouurs®
= ‘si compte CSV’, Indah —Col™ 9,
dhakaesy = Pa vend CSV (tric das —comg to ye _veuuts = ["UT)
KUL con be uncle rege. or owe quote’
Aate— Coy = PArremd —Cey ('UIS_date_ Sample CW), indr_cl=0, )
NaWeturs = Uwe, “aaa'))
Arngornne) atv (exer Spreed guet’)
Aare _Klen = Pd Teal Excel ("Ins dole comple - Xl’,
Vneat— pame= Uns dale’)
@ Scanned with OKEN Scanner% dokapax ull ecane tha dale frome @3)
\ ‘ \ e python
Romove maar corn & replace "Ul ond, tH os mtg
Vode
Ake AlGK = Pols read —Ceod (tung dake Sole sxe Wtex—cl =0,
Nea veauen = [NIU, "aany)
Aenpornng date (Text frerar)
> daa tik + pd vreod — teste ('Tng dete sample tr*)
\Laate home. Ly command Neda 10 Yeaol tut Ale
= ON columns veacland Sore O & Sires Column datcframe,
Unoretar ty AVI Ae Prue, PIAL & denier to
Ue Javowatert Weep or Wdauhiier
> D&aur dotimiter Gta yeperented ta NES
okt Oe) = pd-resd taate (| OAS—dakesample hee Sp =\t)
uw yo o= u w C uw W * u 1 debienitey =\t)
WTA datemarey might nol Work, adorn
Reason * Date t& nor teu. daliiniey date
° ote comments) Areal deen) bore are Commas anol Llanes
+ Remoting yates cotainn nck etauy SOU and Ha ae,
sting oles Can be clone fay te, Soone ule the wee
opped fy esvand exer filer,
2 Ancieadh §- wang Food teste), reat —cav() Can attro be
pred tovead DU fits
. Sat a
dota tr02 = Pde veadt sy (NUis_date Sample IK) datuaier = )
@ Scanned with OKEN Scannerat
Pandas Datafrannes re
Trroy ducnos to pandas
2 PON des Wofr—ferporMaNe > coy Pours date Shuthiver
Omak analyrir avele for Wye Geyser Projsnoning \ontnge.
s Open Sour python lorcrey Prondsng, she Pextorran
dake maniPWAN™ anol anabyris “eo | vena tes Powuful—
Boke Tracnxres:
share Pandad % dftved fiom the Wor “Panck Dat, —
On Ecomomamier TOM for MULHAT HENKEL dale
= Pander doaks witty dotstramnty
> Data frame 2 dumentronal- [row t cotums| (muraate]
. nagerro gennour Jesuit Gate (muthure- Udit [ebVtool afee,
Crews Leong)
Anyoenng) Dade cto Spydan
ingore 0g = ‘og Ulrany to Chong, the vomang dneting
\Wrt Pordors o PA > "ardas eal Wy Ls Lali sheen
Vengo NECNTY ov > “norspyy Utreny Ay Pexpoory nurmeut
snares to eae Darcy
OS. Gras ("D *\pardad’)
or
O Ampornag dare
Gavg_ date = Pa -vead. cay (‘Tyo -csv))
ey Josorg (DRO col =O, ste Column beeomer thor
a Pp Column -
Gos _date Po -reodk— eSv (‘T4D-co7, HARK a= 0)
@ Scanned with OKEN Scanneramon ott § omfinat doe, )
Tr pytven thee ave rev woes To create Cepren MHP?
* Srallow ry Sz Samp = Cong deter
oe te ns con lomt=ma)
HK Piny changes mede to Acopy g objetr CALL be yeHecdeol,
Ty We OMY Ober as welt [| YhaWlow cory | Usberery.
» Pony ca mde to o uw une Nera
foe sefurttedk He ONYHA Ohfeur [Deep onl onginel’]
Orbures §, dary
——
in axes) the
Datafyoma > dor — T Gur te Wnaaex (voL ) i
Cox Sidatal Haor olp: teu inet (L Or 12 —w3s5
aype > HAL GYY, onyer yao}
Date frome . Columns = To get tne column Oe
Na
4 - a yea Vt
Corr —dakel sColumne a ee(Citiia NAHE wo Bat Mp
. HP, | od’ !Autymeho, 'Cc’ fons)
gS]: PMs Modcores! $6 ;
* waghr) J, atype object)
Dakkbrome +Giae => TO Jer the feieh number ds Ctarnzaty from
x date frome
[Wace
Date hams. + Uhepe > tp ope We Suet 4
Conk dale L-Ghoper
Cons — dake ae. Olp -1y360
tte,
dake frame
Slr (4368, 10) = yscrws &
\O column
Delafrome «ramen ureqe, ([lretrxy dane |) > The namo
tea Ge Cows column in bytes 1
GAs dal wareony —anege () 0h» cre lee
& Scanned with OKEN ScannerDade frarnt -nduwn pytnen
Co —aataL nun Olp 2 .
WL pwo—duinansral ave" srores dats in a fomnet Snosneg
Of vows & cows
Tindiaging & Sotechng dale
et —1 ‘ep and abbsbute / dotoperctey'.
openen shang oyraroy ae :
axa ured for Haein wok
niges quick onal acer, HOPI Ass Suckeree
3 Po
. ra) = The funchdn Weak rTUMS [tr
pateheme head(til) rcv nr00% fem MRE dale heme
Carr__daleL-neod (6) A VUNG 6 WS
Roy dafeuh the head FENMS Hyp Brows.
= The funchiin Tail ohms He Leak NWS fry te
dbjour haa on pos nen
Conk dated -tallG) > rhaens bar 5 yous
Buy dasulh, toe jerk) TRUE Ish DVowS
2 TD aces a Scaler Nena 1 tet een ne ts to
UW Hye‘ ak ond tal mattrody
§ chored Seater bortups
‘oy prouiees ae
Oy Condotel car [Hs "Fax type | ise
‘Diesey’ ——Op.
a BY VF -{ [
jak Amn! soege peewee (paaK}
Crs — date b fat l < aeger
@ Scanned with OKEN Scanner*TO acces, a ger 4 ws ard Colson e#
wyon
Qoaebi »beEL ] con be wed:
Cosdakl- bef 2, "Tete op. 0 piered
\ menel
a
i Nan
peret
__——_—__— — S
Date types
The Wo0H Anyomnancny Gets gto iH a datefpamt oY
A qUyREEM ObjeU- Offers Me Orahycs nck {PS G Catedsncdrs
These ore hoo movin types Up dale
sense and Uoracter YP
Numewe Deda hyp Wud HUETEA Ord float
fev ey LWNTEPY —10 flock (0-53
F Stand Ore Known o4 O_ILUL wy porary WU COD Store yokrtey
Ained Conyetin NMA and [oy Wrorcdert
Se + (cate
Humeare Types
¥ Pandas and bare PEN MO difjaanr Name for
doteakypes
pyrigon dass THC Panda data type Deccnpnen
a Yotoy Numee Craretiers
Seoat- roar OY Numa Charaterd coy ty decimals
‘Gye siagy rex to ta MOMOVY allocated to store daly
ty ad Le Lobiile Grtecnvery yetata Yo hoo mre ANIC ie
Can Cee. iy Boch" Guin Kh = & BYIEA
@ Scanned with OKEN ScannerC»
H Allocating Gpace areas HME cattows COmpulers piso
40. optimise, Siege Ana Mreenng csficlenty
Choractes YRS
govjet”
pireane Ho comm SO
ane
onc} a fa ar ffesnr yawn,
By Qinng Haba \ OUD of ony _
Cosvernna, Suty Ch Sng) youaele to o Casegprica) Youd
LAU Gave Some mom
o Col, Yariedtle Ake Uva wunt'kd , paced numer
O OWL VLAD -
Ovjeor
Tha Column Uriel bt asriqned o4 Oye hale, .
Laban te hod Talad TYPE (Nurniarr BE. shanaa 4p Ob Colurnn
(mnncans)s Pardor Ut dopeutt hy
Contam ‘not
one = & yor fuk
Ten Sin \srat
checking, dak oka wen of toch co column)
_— reruns OL STs vom ste 7
column,
Quartet + Dalafran odtypts
Sy
CAS tage Pree reg
we foursy
Oojeur
ar oeyeur
an ob\eur
n
tosh wey
@ Scanned with OKEN ScannerCount Of unique dota yp 2%)
ar — drype—counlel) yetuens Counts gp unique Pytso
ska rapes in the dais frome
Syntek Date fame = qeh-ciype— coun | )
Core - diated er Te = coun O)
olp: feearo 2
- qarey
Obie, uy
Atype (atey
Saleen 4 data baxed os date hyper
Pandas. parefra me + SULUr— dq per yoreeng a Sulsser & We
Columns fom datehame Drage ON WL Column dAtyper -
Syntek + Detahhome Serer et rgpes [socal = None, Gxchuclenens
gq rede, Hopeccise =HUiee [nage Me
ConGne Sumnimory G dotahame
\N Fol) wera Usnne See of oa datagram c-
daratine Of HK
+ dade Ms f- Colamnns
couneh Ronn VLA
sme Ur
Splat “Dela frome =f C)
s.-ofoC )
Cox $—d Or & » ve,
Ls sumer Dp WL vertaitas One digleyss
Neat hag been road o% object instead g tH leqey
y wy
Saph has be2r7 vedk 0 w y .
_ Yoder Are prenenl—
@ Scanned with OKEN Scanner