I-Pandas iyithuluzi elibalulekile emhlabeni wokukhohlisa nokuhlaziya idatha lapho usebenza nePython. Ukuvumelana nezimo nokusebenziseka kalula kwayo kuyenza ifanele imisebenzi eminingi ehlobene nokuphatha nokuhlaziya idatha. Inkinga eyodwa evamile okubhekwana nayo lapho usebenza ne-Pandas ukuguqula i-dtypes yedethi isuka ku-Object iye ku-ns ngezoni yesikhathi ye-UTC. Lokhu kuguqulwa kuyadingeka ngoba, kwamanye amasethi wedatha, amakholomu edethi awabonwa njengezinsuku ze-dtype ngokuzenzakalela futhi esikhundleni salokho abhekwa njengezinto. Lokhu kungabangela izinkinga uma uzama ukwenza imisebenzi efana nokuhlunga, ukuhlunga, nokuhlanganisa. Kulesi sihloko, sizohlola le nkinga ethile futhi sinikeze isisombululo sokuguqula kalula i-dtype yamakholomu edethi ukusuka ku-Object kuya ku-ns (UTC) sisebenzisa i-Pandas, ehlanganisa inqubo yesinyathelo ngesinyathelo ukuqonda ikhodi.
Isingeniso samaPanda kanye nokusebenzisana nezinsuku
I-Pandas ilabhulali yomthombo ovulekile evumela ukuguqulwa okulula, ukukhohlisa, nokuhlaziywa kwedatha. Ihlinzeka ngezakhiwo zedatha, njenge-DataFrame kanye nochungechunge, okwenza ukusebenza ngedatha ku-Python kusebenze kahle futhi kube okunembile. Uma usebenzisana nedatha yochungechunge lwesikhathi, i-Pandas iza nenhlobonhlobo yokusebenza edizayinelwe ukusebenza namadethi, izikhathi, nedatha enenkomba yesikhathi.
Nokho, lapho ungenisa lolu hlobo lwedatha kusuka emithonjeni ehlukene, njengamafayela e-CSV noma e-Excel, ama-Panda angase angawaboni njalo amakholomu edethi ngendlela efanele. Lokhu kubangela ukuthi izinsuku zithathwe njengezinto, kukhawulelwe ukusebenza kwazo futhi kuzenze zingakufanelekeli ukubala nokusebenza okuhlobene nedethi.
Isixazululo: Ukuguqula i-Date dtypes isuke ku-Object iye ku-ns (UTC) ngamaPanda
Isixazululo sale nkinga siwukuguqula ngokucacile amakholomu edethi ukusuka kokuthi Into ukuya kufomethi yedethi oyifunayo (kulokhu, ns ngezoni yesikhathi ye-UTC) usebenzisa i-Pandas. Lokhu kungazuzwa ngokusebenzisa i- pd.to_datetime() umsebenzi, ovumela ukuguqulwa okulula kwamakholomu edethi.
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)
Incazelo Yesinyathelo Nesinyathelo Yekhodi
- Ngenisa umtapo wezincwadi wePanda ngesibizo pd.
- Layisha ifayela le-CSV eliqukethe idatha nge- pd.read_csv() umsebenzi.
- Guqula ikholomu yedethi usebenzisa i- pd.to_datetime() umsebenzi, ukudlulisa ikholomu yesithakazelo kanye nendawo yesikhathi oyifunayo (utc=Iqiniso) kanye nefomethi (uma kunesidingo).
- Phrinta i-DataFrame dtypes ukuze uqinisekise ukuthi ikholomu yedethi iguqulwe ngempumelelo isuka ku-Object yayiswa ku-ns (UTC).
Amathiphu engeziwe kanye Nemikhuba Engcono Kakhulu
I-Pandas inikeza izindlela eziningana nokusebenza kokuphatha izinsuku nezikhathi. Nawa amanye amathiphu engeziwe nemikhuba engcono kakhulu ongayilandela lapho usebenza namakholomu edethi:
- Njalo hlola izinhlobo zamakholomu akho ngemva kokungenisa idathasethi ukuze uqinisekise ukuthi asesimweni esifanele.
- Uma usebenza nezindawo zesikhathi, cabanga ukusebenzisa i- pytz umtapo wolwazi ukuze uthole izinketho ezithuthuke kakhulu zokuphatha izoni yesikhathi.
- Ezimweni ezivamile zokusetshenziswa, akudingekile ngaso sonke isikhathi ukuguqula i-dtype yekholomu yedethi ibe ama-nanosecond (ns). I-dtype ezenzakalelayo esetshenziswa ama-Pandas (datetime64[ns]) ngokuvamile yanele.
Ngokulandela lo mhlahlandlela nokuqonda inqubo yokuguqula ama-dethi e-dtypes ukusuka ku-Object ukuya ku-ns (UTC) usebenzisa i-Pandas, ungaqinisekisa ukuthi idatha yakho yochungechunge lwesikhathi ifomethwe kahle futhi ilungele ukukhohliswa nokuhlaziywa okwengeziwe. Lokhu akwenzi nje kuphela isigaba sokucubungula kusengaphambili idatha kodwa futhi kuvumela ukuhlaziya okunembe kakhudlwana nokusebenza kahle. Ngokuqonda okuqinile kulawa maqhinga, uzohlonyiswa kahle ukuze ubhekane nedatha yochungechunge lwesikhathi kumaphrojekthi wakho wesikhathi esizayo.
