Kwihlabathi lohlalutyo lwedatha, kuqhelekile ukudibana nedatha equlethe izitampu zexesha. Ngamanye amaxesha, sinokufuna ukwenza lula kwaye sithathele ingqalelo umhla kuphela, onokuba luncedo kwiinjongo ezahlukeneyo ezinje ngohlalutyo lweentsingiselo, uqikelelo, okanye ukubonwa. Kweli nqaku, siza kukubonisa indlela ** ukuguqula ikholamu yePandas yesitampu sexesha ukuya kuthi ga ngoku ** usebenzisa iPython, ikwenza kube lula kuwe ukuba usebenze kunye nokuqonda idatha yakho. Siza kukuhamba ngesisombululo, sikunikeze inkcazo ngenyathelo ngenyathelo lekhowudi, kunye nokuphonononga kwamanye amathala eencwadi anxulumeneyo kunye nemisebenzi enokuthi ibe luncedo ngakumbi kwizakhono zakho zokukhohlisa idatha.
Ukuguqula izitampu zexesha zibe ngumhla kwiPandas
Ukuze uqalise, kuya kufuneka ube nayo Iipandas efakwe kwindawo yakho yePython. I-Pandas yilayibrari enamandla ebonelela ngokuguqulwa kwedatha kunye nezixhobo zokuhlalutya. Enye yezona zinto zibalulekileyo kwiPandas yiDathaFrame, ekuvumela ukuba ulawule ngokulula kwaye uhlalutye inani elikhulu ledatha kunye nemisebenzi eyahlukeneyo.
Isisombululo sokuguqula umqolo wePandas izitampu zamaxesha zibe ngumhla uquka ukusebenzisa `dt` umncedisi kunye nophawu `lomhla`. Makhe sicinge ukuba sele uneSakhelo seDatha esinoluhlu lwezitampu zamaxesha. Ikhowudi yokwenza uguqulelo ijongeka ngolu hlobo:
import pandas as pd # Assuming your DataFrame is named df and the column with timestamps is 'timestamp_col' df['date_col'] = df['timestamp_col'].dt.date
Isiqwengana sekhowudi engentla yenza umqolo omtsha obizwa 'date_col' kwiDathaFrame, kwaye yabela inxalenye yomhla 'yestamp_col' kuyo.
INyathelo neNyathelo Inkcazo yeKhowudi
Ngoku, masicazulule ikhowudi kwaye siqonde ukuba icandelo ngalinye lenzani.
1. Okokuqala, sithatha ngaphandle ilayibrari yePandas sisebenzisa igama elithi `pd` eliqhelekileyo:
import pandas as pd
2. Okulandelayo, sithatha ukuba sele uneSakhelo seDatha `df` equlethe ikholamu enesitampu sexesha esibizwa ngokuba yi-'timestamp_col'. Ukwenza umqolo omtsha onesiqingatha somhla kuphela sezitampu zexesha, sisebenzisa `dt` isinikezeli esilandelwa luphawu `lomhla`:
df['date_col'] = df['timestamp_col'].dt.date
Isincedisi `dt` sibonelela ngofikelelo kwiipropati zexesha loluhlu lwePandas, ezifana `nonyaka`, `inyanga`, `usuku`, `nomhla`. Kwimeko yethu, sisebenzise uphawu loyelelwano `lomhla` olubuyisela inxalenye yomhla yezitampu zexesha.
Kwaye yiloo nto! Ngale migca ilula yekhowudi, uguqule ngempumelelo ikholamu yePandas yezitampu zamaxesha ukuza kuthi ga ngoku.
Ithala leencwadi lePandas kunye nokubaluleka kwalo
Iipandas lithala leencwadi elivulelekileyo eliye laba sisiseko sokusetyenziswa kwedatha kunye nohlalutyo kwiPython. Inika uluhlu olubanzi lwemisebenzi, okwenza kube lula kubasebenzisi ukucoca, ukuguqula, kunye nokubona idatha yonke ngaphakathi kwesixhobo esinye. Izinto eziphambili kwiPandas yiDathaFrame kunye neSeries, ezenzelwe ukuphatha iintlobo ezahlukeneyo zedatha.
Into ye-DataFrame yitheyibhile enamacala amabini anokuba neekholamu zeentlobo ezahlukeneyo zedatha, njengamanani, imitya, imihla, nokunye. Ibonelela ngemisebenzi eyahlukeneyo ngokufanelekileyo ukubuza, ukuguqula, kunye nokuhlalutya idatha.
Into yoHlobo, kwelinye icala, luluhlu olubhalwe macala onke olukwaziyo ukuphatha naluphi na uhlobo lwedatha. Uthotho ziibhloko zokwakha zeekholamu zeDathaFrame.
Eminye iMisebenzi yokuLawula iDatha kwiPandas
Ukongeza ekuguquleni izitampu zexesha ukuza kuthi ga ngoku, iiPandas zikwabonelela neminye imisebenzi emininzi eluncedo yokukhohlisa idatha. Ezinye zezi ziquka:
1. Ukucoca: Xa uneseti yedatha enkulu, kunokubakho iimeko apho ungathanda ukuhluza idatha ngokusekelwe kwiimeko ezithile. I-Pandas ibonelela ngeendlela ezininzi zokucoca idatha, njenge `loc[]`, `iloc[]`, kunye `nombuzo()`.
2. Ukwenza Iqela: Umsebenzi `iqelaby()` likuvumela ukuba wenze iqela kwaye uhlanganise idatha ngomqolo omnye okanye ngaphezulu, unikezela ngezisombululo ezisebenzayo zokuhlalutya kunye nokushwankathela idatha.
3. Ukudibanisa kunye nokudibanisa: I-Panda inemisebenzi eyakhelweyo, efana `nokudibanisa()` kunye `dibanisa()`, yokudibanisa kunye nokudibanisa iiFrame zeDatha ezininzi kunye.
4. Ukuphatha Idatha Elahlekileyo: Iiseti zedatha zelizwe lokwenyani zihlala ziqulatha amaxabiso angekhoyo, kwaye iPandas ibonelela ngeendlela ezininzi zokujongana nezi meko, ezinje nge `fillna()`, `dropna()`, kunye `interpolate()`.
Ngokusebenzisa uluhlu olubanzi lwemisebenzi ebonelelwe yiPandas, uya kuxhotyiswa ngokufanelekileyo ukuze ujongane nemisebenzi eyahlukeneyo yokukhohlisa idatha kunye nokufumanisa ulwazi oluxabisekileyo kwiiseti zakho zedatha.
