Pandas waa maktabad awood leh oo Python ah oo loogu talagalay falanqaynta xogta iyo wax-is-daba-marinta, oo si ballaaran loogu isticmaalo qaybo kala duwan, oo ay ku jiraan adduunka moodada. Ka faa'iidaysiga Pandas, khubarada moodada iyo horumariyayaashu waxay ogaan karaan isbeddellada, qaababka, iyo fikradaha iyagoo falanqaynaya xog-ururinta la xidhiidha warshadaha moodada. Maqaalkan, waxaan ku dhex geli doonaa shaqooyinka Pandas ee xoogga badan, macneheedu waa iyo wadarta, iyo codsiyadooda falanqaynta xogta moodada.
Hawlahani waxay aad u caawin karaan helitaanka macluumaadka muhiimka ah ee ku saabsan alaabta moodada sida iibka, isbeddellada qiimaha, qiimeynta alaabta, iyo in ka badan. Marka la xisaabiyo celceliska iyo wadarta sifooyin kala duwan, waxaan ka soo qaadan karnaa fikrado qiimo leh si aan u gaarno go'aamo xog ogaal ah oo ku saabsan hab-dhaqanka iyo moodooyinka.
Xalka dhibaatada
Si loo muujiyo isticmaalka pandas macneheedu waa iyo wadarta Hawlaha, aynu ka soo qaadno in aanu haysano xog-ururin ka kooban tafaasiil ku saabsan alaabta moodada ee kala duwan sida qaabkooda, midabadooda, qiimaha, iyo qiimayntooda. Waxaan u soo dhoofin doonaa xogtan pandas DataFrame waxaanan bilaabi doonaa falanqaynta annaga oo adeegsanayna celceliska iyo hawlaha wadarta.
import pandas as pd
# Read data from a CSV file and load it into a DataFrame
data = pd.read_csv('fashion_items.csv')
# Calculate mean and sum of the price column
mean_price = data['price'].mean()
sum_price = data['price'].sum()
print('Mean price:', mean_price)
print('Total price:', sum_price)
Sharaxaada tallaabo-tallaabo ee koodka
- Marka hore, waxaan soo dejineynaa maktabadda pandas ee loo yaqaan 'pd'.
- Marka xigta, waxaanu akhrinay xogta faylka CSV ee lagu magacaabo 'fashion_items.csv' oo ku dheji DataFrame oo loo yaqaan 'data' anagoo adeegsanayna shaqada pd.read_csv. Dataset-ka waxaa ku jira macluumaad ku saabsan waxyaabaha moodada kala duwan.
- Kadibna, waxaan xisaabineynaa celceliska qiimaha dhammaan alaabta moodada anagoo adeegsanayna celceliska() shaqada lagu dabaqay tiirka 'qiimaha' ee DataFrame. Qiimahan waxa lagu kaydiyaa doorsoome lagu magacaabo 'mean_price'.
- Sidoo kale, waxaan xisaabineynaa wadarta qiimaha dhammaan alaabta moodada anagoo waceynaa wadarta() shaqada ee tiirka 'qiimaha'. Qiimahan waxa lagu kaydiyaa doorsoome lagu magacaabo 'sum_price'.
- Ugu dambeyntii, waxaan daabacnaa celceliska la xisaabiyay iyo wadarta qiimaha alaabta moodada.
Maktabadaha la xidhiidha iyo shaqooyinka Pandas
Waxaa jira tiro badan oo maktabado ah iyo shaqooyin kaaba isticmaalka pandas ee falanqaynta xogta ee warshadaha moodada. Qaar ka mid ah hawlahan waxtarka leh marka laga reebo macneheedu waa iyo wadarta waxaa ka mid ah:
Pandas groupby function
The koox koox Shaqadu waxay si gaar ah waxtar u leedahay isu geynta xogta ku salaysan tiirar gaar ah. Tusaale ahaan, haddii aan rabno inaan falanqeyno celceliska iyo wadarta qiimaha alaabta moodada ee qaab kasta oo ku jira xog-ururintayada.
# Group data by style and calculate mean and sum of the price
grouped_data = data.groupby('style')['price'].agg(['mean', 'sum'])
print(grouped_data)
Pandas milmaan shaqada
The isku dar Shaqadu waxay noo ogolaanaysaa inaan isku geyno laba DataFrames oo ku salaysan tiir guud. Tusaale ahaan, ka soo qaad in aanu hayno xog ururin gaar ah oo ka kooban macluumaad ku saabsan caannimada qaab kasta. Marka la isku daro labada DataFrames, waxaan u bedeli karnaa macluumaadkan fikrado qiimo leh.
# Import data related to style popularity
style_popularity_data = pd.read_csv('style_popularity.csv')
# Merge the original data and style_popularity_data based on the 'style' column
merged_data = pd.merge(data, style_popularity_data, on='style')
print(merged_data.head())
Fahamka iyo hirgelinta hawlahan xoogga leh ee gudaha maktabadda Pandas, khubarada moodada iyo horumariyayaashu waxay gaari karaan go'aamo xog ogaal ah oo ay si fudud u falanqeeyaan isbeddellada iyo qaababka ugu dambeeyay.
