Kijan pou m li yon fichye CSV an Python?

Question

Mwen gen yon fichye `vant.csv` ak kolòn `dat, pwodwi, kantite, pri`. Mwen vle kalkile total vant pou chak pwodwi.

Accepted Answer

Pi fasil la se ak **pandas**:

```python
import pandas as pd

df = pd.read_csv('vant.csv', parse_dates=['dat'])
df['total'] = df['kantite'] * df['pri']

rezilta = (
    df.groupby('pwodwi', as_index=False)['total']
      .sum()
      .sort_values('total', ascending=False)
)
print(rezilta)
```

Si fichye a sòti nan Excel an franse, li ka itilize `;` kòm separatè ak `,` pou desimal:

```python
pd.read_csv('vant.csv', sep=';', decimal=',', encoding='utf-8-sig')
```

Si w pa vle enstale pandas pou yon ti script, modil `csv` ki vini ak Python ase:

```python
import csv
from collections import defaultdict

total = defaultdict(float)
with open('vant.csv', newline='', encoding='utf-8') as f:
    for liy in csv.DictReader(f):
        total[liy['pwodwi']] += int(liy['kantite']) * float(liy['pri'])
```

1 réponse