0% found this document useful (0 votes)
12 views

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.

Uploaded by

Chaitanya reddy
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
0% found this document useful (0 votes)
12 views

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.

Uploaded by

Chaitanya reddy
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
You are on page 1/ 33
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 Scanner Veet 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 Scanner at 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 Scanner amon 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 Scanner Dade 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 Scanner C» 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 Scanner Count 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

You might also like