Imfashini nezinhlelo kungase kubonakale njengemihlaba emibili ehluke ngokuphelele, kodwa uma kuziwa ekuhlaziyweni kwedatha nokubikezela kwethrendi, kungahlangana kahle. Kulesi sihloko, sizohlola inkinga evamile yokuhlaziywa kwedatha embonini yemfashini: ukushiya izinsuku ezithile kudatha ye-pandas datetime. Lokhu kungaba usizo ikakhulukazi lapho uhlaziya amaphethini, amathrendi, nedatha yokuthengisa. Sizodlula encazelweni yesinyathelo nesinyathelo sekhodi, futhi sixoxe ngemitapo yolwazi ehlukahlukene kanye nemisebenzi ezosisiza ukuthi sifinyelele umgomo wethu.
Pandas kanye Datetime in Fashion
I-Pandas iwumtapo wezincwadi odumile wePython osetshenziselwa ukuhlaziya idatha nokukhohlisa. Emhlabebeni wemfashini, ingasetshenziswa ukuhlunga inani elikhulu ledatha ukuze kuhlonzwe amathrendi, kuhlaziywe okuthandwa ngamakhasimende, nokubikezela amaphethini esikhathi esizayo. I-Pandas isekela ukusebenza kwedethi, okusivumela ukuthi sisebenze nezinsuku nezikhathi kalula.
Ezimweni eziningi, kuyadingeka ukuthi ushiye izinsuku ezithile noma ububanzi bezinsuku kudathasethi yethu. Isibonelo, singafuna ukungafaki izimpelaviki noma amaholide ukuze sigxile ezinsukwini zokuthengisa ezibalulekile, njenge-Black Friday noma i-Cyber Monday.
Ukuqonda Inkinga
Ake sithi sinedathasethi equkethe idatha yokuthengisa yansuku zonke ngefomethi ye-CSV, futhi sifuna ukuhlaziya ulwazi singafaki izimpelasonto. Ukufeza lokhu, sizoqala ngokuthi ukungenisa idathasethi kusetshenziswa ama-panda, futhi sizobe sikhohlisa idatha ukuze sisuse izimpelaviki.
Nansi inqubo yesinyathelo ngesinyathelo:
1. Ngenisa imitapo yolwazi edingekayo.
2. Layisha idathasethi.
3. Guqula ikholomu yedethi ibe ifomethi yedethi (uma ingekho kuleyo fomethi).
4. Hlunga uhlaka lwedatha ukuze ungabandakanyi izimpelaviki.
5. Hlaziya idatha ehlungiwe.
Qaphela: Le ndlela ingasetshenziswa kunoma iyiphi isethi yedatha lapho usuku lugcinwa khona kukholomu ehlukile.
# Step 1: Import the necessary libraries
import pandas as pd
from pandas.tseries.offsets import BDay
# Step 2: Load the dataset
data = pd.read_csv('sales_data.csv')
# Step 3: Convert the date column to datetime format
data['date'] = pd.to_datetime(data['date'])
# Step 4: Filter the dataframe to exclude weekends
filtered_data = data[data['date'].dt.dayofweek < 5]
# Step 5: Analyze the filtered data
print(filtered_data.head())
Ukutolika Ikhodi
Ku-block yekhodi engenhla, siqala ngokungenisa imitapo yolwazi emibili ebalulekile: ama-panda kanye ne-BDay (usuku lwebhizinisi) kusuka ku-pandas.tseries.offsets. Silayisha isethi yedatha sisebenzisa umsebenzi we-pandas read_csv , futhi siqinisekise ukuthi ikholomu yosuku ikwifomethi ye-datetime.
Isici se -dt.dayofweek sibuyisela usuku lwesonto njengenombolo ephelele (uMsombuluko: 0, iSonto: 6). Ukuze sihlunge izimpelasonto, sigcina kuphela imigqa enenani le-dayofweek elingaphansi kuka-5.
Ekugcineni, sihlaziya idatha ehlungiwe ngokuphrinta imigqa embalwa yokuqala sisebenzisa umsebenzi we-head().
Imisebenzi Eyengeziwe kanye Nemitapo yolwazi
Le ndlela inganwetshwa ukuze ihlanganise nezinye izimo zokuhlunga noma ukusebenza ngebanga ledethi elihlukile. Amanye amalabhulali awusizo nemisebenzi engasekela le nqubo ihlanganisa:
- I-NumPy: Ilabhulali yekhompuyutha yezinombolo ku-Python, engasetshenziselwa ukukhohlisa kwamalungu afanayo okusebenzayo nokusebenza kwezibalo.
- IdethiIsikhathi: Imojula kumtapo wolwazi ojwayelekile wePython osisiza ukuthi sisebenze ngezinsuku nezikhathi kalula.
- date_range: Umsebenzi ongaphakathi kwama-panda osivumela ukuthi sidale ibanga lamadethi ngokuya ngezilungiselelo ezihlukile zemvamisa, njengezinsuku zebhizinisi, amaviki, noma izinyanga.
Ngokusebenzisa lawa mathuluzi namasu ngokuhlangana nama-panda kanye nokukhohlisa kwedethi, ungakha ukugeleza komsebenzi okuqinile kokuhlaziywa kwedatha okuhlangabezana nezidingo ezithile zomkhakha wemfashini, njengokuhlonza amathrendi, okuthandwayo kwamakhasimende, nokusebenza kokuthengisa.
