Pandas chishandiso chakakosha munyika yedata manipulation uye ongororo kana uchishanda nePython. Kuchinja kwayo uye nyore-kwe-kushandisa kunoita kuti ive yakakodzera kune yakawanda yemabasa ane chekuita nekubata uye kuongorora data. Rimwe dambudziko rinowanzosangana naro paunenge uchishanda nePandas kushandura date dtypes kubva kuObject kuenda kuns neUTC timezone. Shanduko iyi inodiwa nekuti, mune mamwe madheti, makoramu emazuva haazivikanwe semazuva dtypes nekukasira uye anotorwa sezvinhu. Izvi zvinogona kukonzera nyaya paunenge uchiedza kuita maoparesheni akadai sekuronga, kusefa, nekubatanidza. Muchinyorwa chino, tichaongorora iyi chaiyo nyaya uye nekupa mhinduro yekushandura nyore dtype yemakoramu emazuva kubva kuObject kuenda ku ns (UTC) tichishandisa Pandas, tichivhara nhanho-ne-nhanho maitiro ekunzwisisa kodhi.
Nhanganyaya kuPandas uye Kushanda Nemazuva
Pandas iraibhurari yakavhurika-sosi inobvumira kutendeuka kuri nyore, kunyengedza, uye kuongororwa kwedata. Inopa zvimiro zvedata, seDataFrame uye Series, izvo zvinoita kuti kushanda nedata muPython kushande uye kunzwisisika. Paunenge uchibata nedata yenguva yakatarwa, Pandas inouya neakasiyana mashandiro akagadzirirwa kushanda nemazuva, nguva, uye nguva-yakaiswa data.
Nekudaro, kana uchiunza iyi mhando yedata kubva kwakasiyana masosi, senge CSV kana Excel mafaera, Pandas inogona kusagaroziva iyo mazuva makoramu nemazvo. Izvi zvinoita kuti misi inobatwa sezvinhu, zvichidzikamisa kushanda kwayo uye kuita kuti isakodzere kune mamwe masvomhu ane hukama nemazuva.
Solution: Kushandura Date dtypes kubva kuObject kuenda ku ns (UTC) nePandas
Mhinduro yedambudziko iri ndeye kushandura zviripachena makoramu emazuva kubva kuChinhu kuenda kune yaunoda datetime fomati (munyaya iyi, ns neUTC timezone) uchishandisa Pandas. Izvi zvinogona kuwanikwa kuburikidza ne pd.to_datetime() function, iyo inobvumira kushandurwa kuri nyore kwemakoramu emazuva.
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)
Tsanangudzo-nhanho-nhanho yeCode
- Ngenisa raibhurari yePandas ine alias pd.
- Rodha iyo CSV faira ine data neiyo pd.read_csv() basa.
- Shandura iyo date column uchishandisa iyo pd.to_datetime() basa, kupfuudza koramu yekufarira pamwe neinodiwa nguva zone (utc=Chokwadi) uye fomati (kana zvichidikanwa).
- Dhinda iyo DataFrame dtypes kuti usimbise kuti iyo date column yakabudirira kushandurwa kubva kuObject kuenda ku ns (UTC).
Mamwe Mazano uye Maitiro Akanakisisa
Pandas inopa akati wandei nzira uye mashandiro ekubata misi nenguva. Heano mamwe matipi ekuwedzera uye akanakisa maitiro ekutevera kana uchibata nemazuva columns:
- Gara uchiongorora ma dtypes emakoramu ako mushure mekutumira dhataset kuti uone kuti ari mufomati chaiyo.
- Kana uchishanda netimezones, funga kushandisa iyo pytz raibhurari yemamwe epamusoro nguva manejimendi sarudzo.
- Kune zviitiko zvekushandisa nguva dzose, hazviwanzodikanwa kushandura date column's dtype kuita nanoseconds (ns). Iyo default dtype inoshandiswa nePandas (datetime64[ns]) inowanzokwana.
Nekutevera gwara iri uye nekunzwisisa maitiro ekushandura date dtypes kubva kuObject kuenda ku ns (UTC) uchishandisa Pandas, unogona kuve nechokwadi chekuti data rako rekuteedzera data rakanyatso kurongeka uye rakagadzirira kuenderera mberi nekunyengedza uye kuongororwa. Izvi hazvingorerutsa danho rekugadzirisa data asi zvakare zvinobvumira kuongororwa kwakaringana uye kwakanaka. Nekunzwisisa kwakasimba pane aya matekiniki, iwe uchave wakashongedzerwa zvakakwana kubata nguva yakatevedzana data mumapurojekiti ako emangwana.
