Pandas sanannen ɗakin karatu ne na Python wanda ke sauƙaƙe sarrafa bayanai da bincike, yana ba da ayyuka da yawa don sarrafa ranaku da lokuta. Ɗayan yanayin amfani gama gari a cikin nazarin bayanai shine ƙididdige bambanci tsakanin kwanakin a cikin watanni. A cikin wannan labarin, za mu bincika hanyar da za a cimma wannan ta amfani da Pandas, tare da bayanin mataki-mataki na lambar. Bugu da ƙari, za mu tattauna wasu dakunan karatu da ayyuka masu dacewa don haɓaka fahimtarmu game da matsalar.
Karɓar kwanan wata da bayanan lokaci koyaushe ƙalubale ne ga manazarta bayanai da masu haɓakawa. Laburaren Pandas na Python yana sa wannan aikin ya fi sauƙi ta hanyar samar da ayyuka masu ƙarfi da yawa don sarrafa ranaku, lokuta, da lokaci. A cikin wannan labarin, za mu nuna yadda ake ƙididdige bambanci tsakanin kwanakin biyu a cikin watanni ta amfani da Pandas.
Maganin Matsala
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)
Bayanin Code
1. Da farko, muna shigo da ɗakin karatu na Pandas azaman pd. Wannan yana ba mu damar yin amfani da ingantaccen tsarin ayyuka na Pandas don aiki tare da kwanan wata.
2. Sa'an nan kuma mu ayyana wani aiki da ake kira 'date_diff_in_months' wanda ke ɗaukar gardama biyu, `kwana 1`, da `kwana biyu`. Wannan aikin zai dawo da adadin watanni tsakanin kwanakin shigarwa biyu.
3. A cikin aikin, muna ƙididdige bambance-bambance a cikin watanni ta hanyar cire abubuwan shekara da watanni na 'date1' daga abubuwan da suka shafi 'date2', sannan mu daidaita sakamakon don bambancin shekaru.
4. Na gaba, muna ƙirƙirar abubuwa guda biyu na Pandas Timestamp, `date1` da `date2`, ta amfani da aikin `pd.to_datetime`. Waɗannan suna wakiltar kwanakin samfur guda biyu don shari'ar gwajin mu.
5. Muna kiran aikin `date_diff_in_months` tare da `kwana 1` da `kwana 2`, muna adana sakamakon a cikin mabambanta `watanni_diff`.
6. A ƙarshe, muna buga canjin `months_diff`, wanda zai nuna adadin watanni tsakanin kwanakin shigarwa biyu.
Pandas da Tambarin Lokaci
Abubuwan Pandas' Timestamp suna da matuƙar dacewa, suna ba da damar yin amfani da kwanan wata da kwatance. Ta kiran aikin `pd.to_datetime`, za mu iya canza kewayon tsarin kwanan wata zuwa abubuwan Pandas Timestamp. Ana iya kwatanta waɗannan abubuwa cikin sauƙi, sarrafa su, da amfani da su don yin ƙididdiga masu rikitarwa. A cikin maganinmu, muna yin amfani da ƙarfin abubuwan Timestamp don ƙididdige bambanci tsakanin kwanakin biyu a cikin watanni.
Madadin Dakunan karatu da Ayyuka
- Lambu: Wani mashahurin ɗakin karatu na Python don aiki tare da kwanan wata da lokaci shine Numpy. Tare da abubuwan 'numpy.datetime64', Numpy yana ba da kwatankwacin ayyuka ga abubuwan Pandas' Timestamp. Numpy kuma yana ba da ayyuka kamar `numpy.timedelta64` don ƙididdige bambance-bambance tsakanin kwanakin.
- kwanan wata: Laburaren dateutil kayan aiki ne mai ƙarfi don tantancewa da sarrafa kwanakin a Python. Yana ba da ɗimbin ayyuka da azuzuwan sarrafa lissafin kwanan wata, gami da aikin `dateutil.relativedelta.relativedelta`, wanda ke da amfani musamman don ƙididdige bambance-bambance a cikin kwanakin dangane da shekaru, watanni, da kwanaki.
A taƙaice, ƙididdige bambanci tsakanin kwanakin biyu a cikin watanni ta amfani da Pandas ana iya samun su ta hanya mai sauƙi amma mai tasiri. Za mu iya dogara da abubuwan Pandas Timestamp da aikin al'ada don yin wannan aikin cikin sauƙi. Haka kuma, madadin dakunan karatu kamar Numpy da dateutil suna ba da wasu hanyoyin da za su taimaka wajen magance matsaloli da yawa da suka shafi kwanan lokaci.
