I-Pandas sisixhobo esibalulekileyo kwihlabathi lokuguqulwa kwedatha kunye nohlalutyo xa usebenza nePython. Ukuguquguquka kwayo kunye nokulula kokusetyenziswa kwenza ukuba ilungele uluhlu olubanzi lwemisebenzi enxulumene nokuphatha kunye nokuhlalutya idatha. Enye ingxaki eqhelekileyo ejongene nayo xa usebenza neePandas kukuguqula ii-dtypes zomhla ukusuka kwi-Object ukuya kwi-ns nge-UTC yexesha lendawo. Olu guqulelo luyimfuneko kuba, kwezinye iiseti zedatha, imihlathi yomhla ayiqatshelwanga njengee-dtypes ngokwendalo kwaye endaweni yoko ijongwa njengezinto. Oku kunokubangela imiba xa uzama ukwenza imisebenzi efana nokuhlelwa, ukuhluza, kunye nokudibanisa. Kweli nqaku, siza kuphonononga lo mbandela othile kwaye sinikeze isisombululo sokuguqula ngokulula i-dtype yeentsika zomhla ukusuka kwi-Object ukuya kwi-ns (UTC) usebenzisa i-Pandas, egubungela inkqubo yesinyathelo-nge-nyathelo ukuqonda ikhowudi.
Intshayelelo kwiiPanda kunye nokusebenza kunye neMihla
I-Pandas yilayibrari yomthombo ovulekileyo evumela ukuguqulwa okulula, ukukhohlisa, kunye nohlalutyo lwedatha. Inika izakhiwo zedatha, njengeDathaFrame kunye neSeries, eyenza ukusebenza kunye nedatha kwiPython isebenze ngakumbi kwaye inembile. Xa ujongene nedatha yochungechunge lwexesha, i-Pandas iza kunye neentlobo ezahlukeneyo zokusebenza ezenzelwe ukusebenza kunye nemihla, amaxesha, kunye nedatha ye-indexed time.
Nangona kunjalo, xa ungenisa olu hlobo lwedatha kwimithombo eyahlukeneyo, njenge-CSV okanye iifayile ze-Excel, i-Pandas ayinakuhlala ibona iikholamu zomhla ngokufanelekileyo. Oku kubangela ukuba imihla iphathwe njengezinto, ukunciphisa ukusebenza kwazo kwaye kubenze bangafaneleki ukubala kunye nokusebenza okunxulumene nomhla.
Isisombululo: Ukuguqula Umhla we-dtypes ukusuka kwinto ukuya kwi-ns (UTC) ngeePanda
Isisombululo sale ngxaki kukuguqula ngokucacileyo iikholamu zomhla ukusuka kwinto ukuya kwifomati yexesha elifunekayo (kulo mzekelo, ns nge-UTC timezone) usebenzisa iPandas. Oku kunokufezekiswa ngokuthi pd.to_datetime() umsebenzi, ovumela uguqulelo olulula lwemihlathi yomhla.
import pandas as pd
# Load the CSV file
data = pd.read_csv('data.csv')
# Convert the date column from Object to ns (UTC)
data['date_column'] = pd.to_datetime(data['date_column'], utc=True, format='%Y-%m-%d')
# Print the DataFrame with the updated dtype for the date column
print(data.dtypes)
INyathelo neNyathelo Inkcazo yeKhowudi
- Thatha ngaphandle ilayibrari yePandas ngegama pd.
- Layisha ifayile ye-CSV equlethe idatha nge pd.read_csv() msebenzi.
- Guqula umhlathi womhla usebenzisa i pd.to_datetime() umsebenzi, ugqithisa umhlathi womdla kunye nomda wexesha ofunekayo (utc=Yinyani) kunye nefomati (ukuba kuyimfuneko).
- Shicilela i-DataFrame dtypes ukuqinisekisa ukuba ikholamu yomhla iguqulwe ngempumelelo ukusuka kwi-Object ukuya kwi-ns (UTC).
Iingcebiso ezongezelelweyo kunye neZenzo ezilungileyo
IiPandas zibonelela ngeendlela ezininzi kunye nokusebenza kokuphatha imihla kunye namaxesha. Nazi ezinye iingcebiso ezongezelelweyo kunye neendlela ezifanelekileyo zokulandela xa ujongene nemihlathi yemihlathi:
- Soloko uhlola i-dtypes zekholamu zakho emva kokurhweba ngaphandle kwedatha yedatha ukuqinisekisa ukuba zikwifomathi eyiyo.
- Ukuba usebenza ngezowuni zamaxesha, cinga ukusebenzisa i pytz ilayibrari yokhetho oluthe kratya lwezowuni yexesha.
- Kwiimeko zokusetyenziswa rhoqo, akusoloko kuyimfuneko ukuguqula i-dtype yekholamu yomhla kwi-nanoseconds (ns). I-dtype engagqibekanga esetyenziswa yiPandas (datetime64[ns]) ihlala yanele.
Ngokulandela esi sikhokelo kunye nokuqonda inkqubo yokuguqula i-dtypes yomhla ukusuka kwi-Object ukuya kwi-ns (UTC) usebenzisa i-Pandas, unokuqinisekisa ukuba idatha yakho yochungechunge lwexesha ifomathwe ngokufanelekileyo kwaye ilungele ukuguqulwa nokuhlalutya okuqhubekayo. Oku akugcini nje ukwenza lula isigaba sokulungisa idatha kodwa kwakhona kuvumela uhlalutyo oluchanekileyo nolusebenzayo. Ngokuzibamba ngokuqinileyo ezi ndlela zobuchule, uya kuxhotyiswa kakuhle ukuze ujongane nothotho lwedatha kwiiprojekthi zakho zexesha elizayo.
