Isonjululwe: uzishiya njani iintsuku ze-pandas datetime

Ifashoni kunye nenkqubo zinokubonakala ngathi ziihlabathi ezimbini ezahlukeneyo ngokupheleleyo, kodwa xa kufikwa kuhlalutyo lwedatha kunye noqikelelo lwemeko, zinokudibana kakuhle. Kweli nqaku, siza kuphonononga ingxaki eqhelekileyo yohlalutyo lwedatha kwishishini lefashoni: ukushiya iintsuku ezithile ukusuka kwidatha yedatha yepandas. Oku kunokuba luncedo ngakumbi xa uhlalutya iipateni, iintsingiselo, kunye nedatha yokuthengisa. Siza kuhamba ngesinyathelo-nge-nyathelo inkcazo yekhowudi, kwaye sixoxe ngamathala eencwadi ahlukeneyo kunye nemisebenzi eya kusinceda sifezekise injongo yethu.

IiPanda kunye neDatetime kwiFashoni

I-Pandas lithala leencwadi lePython elidumileyo elisetyenziselwa uhlalutyo lwedatha kunye nokukhohlisa. Kwilizwe lefashoni, inokusetyenzwa ukuhluza isixa esikhulu sedatha ukuchonga iintsingiselo, ukuhlalutya ukhetho lwabathengi, kunye nokuqikelela iipateni zexesha elizayo. IiPandas zixhasa ukusebenza kwexesha lomhla, esivumela ukuba sisebenze kunye nemihla kunye namaxesha ngaphandle komzamo.

Kwiimeko ezininzi, kuyafuneka ukuba ushiye iintsuku ezithile okanye uluhlu lweentsuku kwiseti yethu yedatha. Umzekelo, sinokufuna ukungabandakanyi iimpelaveki okanye iiholide ukuze sigxile kwiintsuku zentengiso ezibalulekileyo, njengoLwesihlanu oMnyama okanye uMvulo weCyber.

Ukuqonda Ingxaki

Masithi sinedathasethi equlethe idatha yentengiso yemihla ngemihla kwifomathi ye-CSV, kwaye sifuna ukuhlalutya ulwazi ngelixa singabandakanyi iimpelaveki. Ukufezekisa oku, siza kuqala ukungenisa idatha yedatha usebenzisa i-pandas, kwaye ke siya kukhohlisa idatha ukususa iimpelaveki.

Nantsi inkqubo yenyathelo ngenyathelo:

1. Iilayibrari eziyimfuneko.
2. Layisha iseti yedatha.
3. Guqula ikholamu yomhla ibe yifomathi yexesha (ukuba akukho sele ikuloo fomati).
4. Hluza i-dataframe ukuze ungabandakanyi iimpelaveki.
5. Hlalutya idatha ehluziweyo.

Phawula: Le ndlela inokusetyenziswa kuyo nayiphi na isethi yedatha apho umhla ugcinwe kwikholamu eyahlukileyo.

# 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 iKhowudi

Kwibhloko yekhowudi engentla, siqala ngokungenisa iilayibrari ezimbini ezibalulekileyo: i-pandas kunye ne-BDay (usuku loshishino) ukusuka kwi-pandas.tseries.offsets. Silayisha i-dataset usebenzisa umsebenzi we-pandas funda_csv, kwaye uqinisekise ukuba ikholamu yomhla ikwifomathi yexesha.

The dt.dayofweek uphawu lubuyisela usuku lweveki njengenani elipheleleyo (ngoMvulo: 0, ngeCawa: 6). Ukuhluza ngeempelaveki, sigcina kuphela iirowu ezinexabiso ledayofweek elingaphantsi ko-5.

Ekugqibeleni, sihlalutya idatha ehluziweyo ngokuprinta imiqolo embalwa yokuqala ngokusebenzisa i intloko() msebenzi.

Imisebenzi eyongezelelweyo kunye namaThala eencwadi

Le ndlela inokwandiswa ngakumbi ukubandakanya ezinye iinqobo zokucoca okanye ukusebenza ngoluhlu lwemihla olwahlukileyo. Amanye amathala eencwadi aluncedo kunye nemisebenzi enokuxhasa le nkqubo ibandakanya:

  • I-NumPy: Ithala leencwadi lekhompuyutha yamanani kwiPython, enokusetyenziselwa ukukhohlisa koluhlu kunye nokusebenza kwemathematika.
  • Umhla weXesha: Imodyuli ekwithala leencwadi eliqhelekileyo lePython esinceda ukuba sisebenze ngemihla kunye namaxesha ngokulula.
  • umhla_uluhlu: Umsebenzi ongaphakathi kweepanda osivumela ukuba senze uluhlu lwemihla ngokwesetingi ezahlukeneyo zefrikhwensi, njengeentsuku zokusebenza, iiveki, okanye iinyanga.

Ngokusebenzisa ezi zixhobo kunye nobuchule ngokubambisana ne-pandas kunye nokuguqulwa kwexesha, unokwenza uhlalutyo oluqinileyo lokuhamba komsebenzi ohambelana neemfuno ezithile zeshishini lefashoni, njengokuchonga iintsingiselo, ukhetho lwabathengi, kunye nokusebenza kwentengiso.

Izithuba ezihambelanayo:

Shiya Comment