🐍
← Back to Blog

Python Cashar 20 — Pandas: falanqaynta xogta iyo waxa xiga

Pandas waa maktabadda ugu muhiimsan ee falanqaynta xogta. Waxay kuu oggolaan inaad shaqeyso miisas (sida Excel) adigoo isticmaalaya koodh. Rakib: pip install pandas. Laba shay oo aasaasi ah ayaa jira: Series (tiir) iyo DataFrame (miis).

Series

import pandas as pd
qiimo = pd.Series([12, 7, 9], index=['Muuz', 'Cambe', 'Liin'])
print(qiimo)
print(qiimo['Cambe'])
print(qiimo.mean())
Muuz     12
Cambe     7
Liin      9
dtype: int64
7
9.333333333333334

DataFrame

df = pd.DataFrame({
    'magac': ['Axmed', 'Cali', 'Faadumo', 'Maryan', 'Xasan'],
    'fasal': ['A', 'B', 'A', 'B', 'A'],
    'buundo': [88, 72, 95, 60, 79],
})
print(df)
print(df.shape)
     magac fasal  buundo
0    Axmed     A      88
1     Cali     B      72
2  Faadumo     A      95
3   Maryan     B      60
4    Xasan     A      79
(5, 3)

Fiiri xogta

print(df.head(3))
print(df.describe())
     magac fasal  buundo
0    Axmed     A      88
1     Cali     B      72
2  Faadumo     A      95
          buundo
count   5.000000
mean   78.800000
std    13.663821
min    60.000000
25%    72.000000
50%    79.000000
75%    88.000000
max    95.000000

Dooro tiirar iyo saf

print(df['buundo'].mean())
print(df[df['buundo'] >= 80])              # shaandhayn
print(df.sort_values('buundo', ascending=False))
78.8
     magac fasal  buundo
0    Axmed     A      88
2  Faadumo     A      95
     magac fasal  buundo
2  Faadumo     A      95
0    Axmed     A      88
4    Xasan     A      79
1     Cali     B      72
3   Maryan     B      60

Tiir cusub

df['guulaystay'] = df['buundo'] >= 75
print(df)
     magac fasal  buundo  guulaystay
0    Axmed     A      88        True
1     Cali     B      72       False
2  Faadumo     A      95        True
3   Maryan     B      60       False
4    Xasan     A      79        True

groupby: koox-koox u xisaabi

print(df.groupby('fasal')['buundo'].mean())
print(df.groupby('fasal')['buundo'].agg(['min', 'max', 'count']))
fasal
A    87.333333
B    66.000000
Name: buundo, dtype: float64
       min  max  count
fasal                 
A       79   95      3
B       60   72      2

Qiimayaal maqan

import numpy as np
d = pd.DataFrame({'a': [1, np.nan, 3], 'b': [4, 5, np.nan]})
print(d.isna().sum())
print(d.fillna(0))
print(d.dropna())
a    1
b    1
dtype: int64
     a    b
0  1.0  4.0
1  0.0  5.0
2  3.0  0.0
     a    b
0  1.0  4.0

Akhrinta iyo qorista CSV

df.to_csv('ardayda.csv', index=False)
laga_akhriyay = pd.read_csv('ardayda.csv')
print(laga_akhriyay.head())

Waxa xiga ee aad baran karto

  • SciPy: isku-darka tirooyinka, hagaajinta, isla-jaadinta xogta.
  • Jupyter / Colab: qoraal iyo koodh isku mar u socda.
  • Testing (pytest): hubi in koodhkaaga si sax ah u shaqeeyo.
  • Git: ilaali taariikhda beddelka koodhkaaga.
  • Classes iyo OOP: nidaamin barnaamijyo waaweyn.

Layli aakhiro

  • Samee DataFrame oo ku jira 5 alaab, qiimahooda iyo tirada, kadibna ku dar tiir wadar (qiime × tiro).
  • Hel alaabta ugu iibka badan.
s = pd.DataFrame({'alaab': ['Shaah', 'Sonkor', 'Bur', 'Saliid', 'Bariis'],
                  'qiime': [2.0, 1.2, 0.9, 3.5, 1.1],
                  'tiro': [30, 50, 80, 20, 60]})
s['wadar'] = s['qiime'] * s['tiro']
print(s)
print(s.loc[s['wadar'].idxmax(), 'alaab'])
    alaab  qiime  tiro  wadar
0   Shaah    2.0    30   60.0
1  Sonkor    1.2    50   60.0
2     Bur    0.9    80   72.0
3  Saliid    3.5    20   70.0
4  Bariis    1.1    60   66.0
Bur
Hambalyo! Waxaad dhammaysay koorsada. Hadda waxaad haysataa aasaas adag oo aad ku dhisan karto mashaariic dhab ah: falanqaynta xog, otomaatig, iyo AI.
Koorsada Python (20 cashar):
← Python Cashar 19 — Matplotlib: sawirka xogta

Maqaallo Kale