I-Pandas yilayibrari yePython eyaziwayo eququzelela ukuguqulwa kwedatha kunye nohlalutyo, inika uluhlu olubanzi lwemisebenzi yokusingatha imihla kunye namaxesha. Imeko enye yokusetyenziswa okuqhelekileyo kuhlalutyo lwedatha ibala umahluko phakathi kwemihla kwiinyanga. Kweli nqaku, siza kuphonononga indlela yokuphumeza oku kusetyenziswa iiPandas, kunye nenkcazo yenyathelo ngenyathelo lekhowudi. Ngapha koko, siza kuxoxa ngamanye amathala eencwadi afanelekileyo kunye nemisebenzi ukukhulisa ukuqonda kwethu ingxaki.
Ukuphatha idatha yomhla kunye nexesha kuhlala kungumngeni kubahlalutyi bedatha kunye nabaphuhlisi. Ilayibrari yePython's Pandas yenza lo msebenzi ube lula kakhulu ngokubonelela ngeseti enamandla neguquguqukayo yemisebenzi yokukhohlisa imihla, amaxesha, kunye nexesha le-deltas. Kweli nqaku, siza kubonisa indlela yokubala umahluko phakathi kweentsuku ezimbini kwiinyanga usebenzisa iiPandas.
Isisombululo kwiNgxaki
import pandas as pd
def date_diff_in_months(date1, date2):
return (date2.year - date1.year) * 12 + (date2.month - date1.month)
date1 = pd.to_datetime("2021-01-01")
date2 = pd.to_datetime("2022-05-01")
months_diff = date_diff_in_months(date1, date2)
print(months_diff)
Ingcaciso yeKhowudi
1. Okokuqala, singenisa ilayibrari yePandas njenge pd. Oku kusivumela ukuba sisebenzise iPandas'robust suite yemisebenzi yokusebenza nemihla.
2. Emva koko sichaza umsebenzi othi `umhla_ukwahlukana_kwiinyanga_ezithatha iimpikiswano ezimbini, `umhla1`, `umhla2`. Lo msebenzi uza kubuyisela inani leenyanga phakathi kweentsuku ezimbini zokufaka.
3. Ngaphakathi komsebenzi, sibala umahluko kwiinyanga ngokuthabatha amacandelo onyaka nenyanga `umhla1` kumacandelo awo ngokwahlukeneyo `kumhla2`, emva koko silungelelanise isiphumo somahluko weminyaka.
4. Okulandelayo, sidala izinto ezimbini zesitampu sexesha sePandas, `umhla1` kunye `nomhla2`, sisebenzisa `pd.to_datetime` umsebenzi. Ezi zimele iintsuku ezimbini zeesampulu zetyala lethu lovavanyo.
5. Siwubiza `umhla_ukwahlukana_ngeenyanga` umsebenzi `nomhla1` kunye `nomhla2`, sigcina isiphumo kuguquguquko `iinyanga_diff`.
6. Okokugqibela, siprinta `iinyanga_diff` eziguquguqukayo, eziza kubonisa inani leenyanga phakathi kwemihla emibini yokufaka.
IiPanda kunye nezitampu zexesha
Izinto ze-Timestamp zePandas ziguquguquka ngendlela emangalisayo, zivumela ukuqhatha kunye nokuthelekisa ixesha elingenamthungo. Ngokubiza `pd.to_datetime` umsebenzi, sinokuguqula uluhlu olubanzi lweefomati zomhla zibe zizinto zePandas Timestamp. Ezi zinto ke zinokuthelekiswa ngokulula, zisetyenziswe, kwaye zisetyenziswe ukwenza izibalo ezinzima. Kwisisombululo sethu, sisebenzisa amandla ezinto zeTimestamp ukubala umahluko phakathi kweentsuku ezimbini kwiinyanga.
Amanye amathala eencwadi kunye neMisebenzi
- numpy: Enye ilayibrari yePython eyaziwayo yokusebenza kunye nemihla kunye namaxesha yiNumpy. Ngezinto zayo `numpy.datetime64`, iNumpy ibonelela ngokusebenza okuthelekisekayo kwizinto zeTimestamp zePandas. I-Numpy ibonelela ngemisebenzi efana ne `numpy.timedelta64` yokuhlanganisa umahluko phakathi kwemihla.
- dateutil: Ithala leencwadi ledatitil sisixhobo esinamandla sokwahlula kunye nokukhohlisa imihla kwiPython. Ibonelela ngeseti ebanzi yemisebenzi kunye neeklasi zokuphatha izibalo zomhla, kubandakanywa umsebenzi we `dateutil.relativedelta.relativedelta`, oluncedo kakhulu ekubaleni umahluko kwimihla ngokweminyaka, iinyanga, kunye neentsuku.
Isishwankathelo, ukubala umahluko phakathi kweentsuku ezimbini kwiinyanga usebenzisa iPandas kunokufezekiswa ngendlela elula kodwa esebenzayo. Sinokuthembela kwizinto zePandas Timestamp kunye nomsebenzi wesiko wokwenza lo msebenzi ngokulula. Ngapha koko, amanye amathala eencwadi afana neNumpy kunye nedateutil abonelela ngeendlela ezizezinye ukunceda ukujongana noluhlu olubanzi lweengxaki ezinxulumene nomhla.
