andas s— 2 4 eS bane eee preiling — Thigh - performanae dato manipulation an analysis i —~ Ue] using H3 powerful data Structures, 2. (GIS bul He Jo +he Nump Package and i+s key daky Sructure jS called +he DatoHame . 3. pate frames allo us-to stove and Manipulate ~pabul aa | deta in @owS of Observations and columna of Yartableg, Impose —> impost pandas as pd gi] eee 4 a 11.2. [Uoe of Pandas 3— |. Import datusets from datoboses , spreadsheets _commo— Separsated Values CCSv)-file, andirrome- t 2: Clean datasets ~fos example y by dealing With missing oe Object isan Ordered, one=dimenslona) aarayof Values , 3,\Tidy datasets by ceshaping thelr Shucture into. Sultable -fowmat—for analysis, : 4 Visualize datasets and uncovers, insights. \ S13 fondas Series $— ae E data @b, and index. Able anray is capable of holding any data ype Ciotegess [Stings floating Polnt+ Numbers , python object ) KJ All-the data ing Geries is of the aame data Type: ot eet © basic method +o eare Has follows — i |a Imporee pandos a5 ed impooy_numpy 09 OP ar = Np. anmran Cl2 416) B 101 1S} = pd, GerieS (ave) punt Csi) Ho] pris ! xoy) § @ 1a has |pP 20 PIR |) I - |g °° r index ara data 2. mes}. viaon : + |\Oato eee 13.0 +d0H cine ae Orrray 00} heterageneous data, 1 r We can Convert a Pytnon's fist, dichonamy on none Otray +o a Pandas data-frame. © 8- tthe “eyntog of DatoFtame j3 a9 follows: pane 49% cee index oo sige ‘ eo py Dawa p pa linelt sé he —> The a io needed to in a ‘This Oequment+ helde -the index value of each Tolement_in the Dateframe . Oefault index 1 np.arrange Cn) vcolumns—> ‘The default Values feo columns in sive — this is he datetype of the date oe ee in -the method. 2 » Copy— Bt-+akes co Booleon value to specify whether oraok-to Copy the dato . the default Value is false - / ‘els \\.\ «lxample.— limpet pandas as pd p= 1219,415,69 df = pde OatofiameC tid soy puat Caf) _ : us oO)! aos , , aaah 0 +t 0* columo 'ort Pandas a3 Pa df = ed. readacov C'd Hon RadioButton lay SC En 12.1 Tntroducten ~to Hiloter != =a provides a simple Way to Greate Windows jbusttong J tHiater Ja Python's Standard +°GUL CGraphicah } User Tirterface ) librany. labels , and other Uf clements « : «Thinker compes pre -installed whth PAthon ) 3e /ou don+ need ~fo Inatall HE sepawately, fra mple “= impowt +hinter a9 H. | es ; Liclgets “are UD components Nive buttons tlabels » and teat fields, Below ave Some commonly used widges — In Tklater + |. Lobeti— A label is used to diapiay toxt on Images jn window, 2 : 2ex label = 4K Label (rook ent =I Heo _stKinren] U), label, pack C) ae rea —_. Button t— — |p Button performs an acHoo When clickeo , Sc. [def on—clickC). sl eHotC!! Button clicked |"). : 4 1 . butten = “Hk. Button Chroot, teat = Uclick men omnia = | al On— click ): ‘ cok J 7 [button packe) 4 = b Radio Buctto i i A Radio ce Alows USerS -++o Selectione option a. form a ee : + eI St RadtobwetHtont ety text= option, a Mavieble —Selected—opHooValue=lyt)— 4 ——_| Stlected_ opHon = +4 StringVarc) a _ we yse alas mse) = — Connectow.— python Module - 2.|This allows us-to fnteract alth a MySaL aehibase from a Pythen program:application sto connect andu interact witha derakese aa A database dejiver {sa piece of softmare reucthataleos ame aystem, aN Here we need -to instal) _a python Mysql Connector+o - interact witha Mysel database. Navigate your Comenard line +0 ne location of PPP ;and dype the follow! oq. ple install _mysg| —Cannectow— python on rsor( ject $- ‘ i Ttlean object-hat is uged --o make the ConnecHoo -for Xearting SQl quesies, a St acts a9 middleocqre bekoeen Saute database Connection and SSL queny. TH te created after giving connection +o sauite database. + syntag!— Cursor— object = Connection. object , oxecet©("! Sql query ny eouteC) meto: «|The first appreoch uses jhe same Cursors executec) method at you! ve been using until nod. You wrtte the INSERT ONTO query ina Steing “and poss t+ +o cua. exectte O: +|We can thie method +o jnsent- data into the Sone Dota Sql = NONSERT QNTO STUDENT CTO, NAME) ast Cl "Ana')”! fyfoursor -exXecicte C991) ‘ bs pilot ( myCursor, toweount, geeeends) ae iy) Conns: commit) + FAS Slteseypm se geen as] rome:= oe = pe Reiches ellinina ae Taae fetches all the SF i Vane bat excouted stui maining tuples from the Fa 1 See ae Creare a Wet oe ial [OP dhere are no tuples “then }F PormS SO Soy = *Pxample’- | mayeu son «exe cures CN SELECT. & FROM son myresult+ = nncursor .fe+chal IC) er x In mryresult' Hint Coc) Ht op: C1, 1 RAR") e Coy BBB) Csi ete »y Oy ppp) Creating Simple Pre Connect database 3— impoot orysq) «connector cH Connect ~fo: Mys@u database Conn = rrysq) nConnector.Connectl >. host = 'localhost", user = '! hoot "! Pass wor = tyfeur —passioord |). s datubage = "testudb" aiaiAp! ) Seki A tutsoyr = Conn. Cutsosc) ct Greate stable iA not'exfats Ma sob Mele 163 Cursor. execute ( CREATE TABLE DF Not Extsrs students ( fol NT AUTO — DNCREMENT eromacy HED Dame VARCHAR (255), age INT»)| print (Table created Successfully") eee eet excotere CON Ser achmos Students: Creme VAWES C! Alice! +) 249.) Cursor. execcte (MONSERT tprTo ee mare Lage) VAWES C!Bob", 23)") : conn. Commit) t pric ( " Records toserted Sucesely i) 2234) lt fetch “and elephad aa Curson sexecerbe ( SELECT & FROM, So records = ctitsor. Fetchall C) pent (Students Recosds") for eoW Jn recosds: pilot Crow) sHclose connection Cursors close C’) Curgoy., closec) peta: _C' Database connectHon clesed ')SS aE _| Baplain Pondas and Pandas se “Whetis use of pandas t. 3 ae nih jes JAN “3-| What ls Datefraes Gnd: COSAIA — 3 Puplaia Thine ondiihe Witdgers 2 sii a E lao | Create > a aimple Gut pplication US TI ectow % a 6: | Hew +olnstall! mysq} 008 st. | What Is cursor 4 3 f 3. [Explain execute 0) and fecha!) C) metrod . F G. | pifference bet? exeaste and fetchallC). y lo. | Wntte a@ simple progtarn to connect dotobase, dl