[TOC]

## Python bits

### CSV
#### Open CSV
```python
csv_data="""
RUT,Name,LastName,E-mail,ISBN1,ISBN2
333,Pablo3,Alar3,mail3,0,0
"""

# recreate file
from pathlib import Path
Path('data.csv').write_text(csv_data)

import csv
with open('data.csv') as f:
     data = [row for row in csv.reader(f)]

# Or using dict reader
with open('data.csv') as f:
     data = [row for row in csv.DictReader(f)]
```
#### Write CSV
```python
with open('data.csv', 'w') as f:
    csv.writer(f).writerows(data)

# or using dict writer
with open('data.csv', 'w') as f:
    writer_obj = csv.DictWriter(f, fieldnames=data[0].keys())
    writer_obj.writeheader()
    writer_obj.writerows(data)
```
#### Edit a cell
To change from
```
RUT,Nombre,Apellido,E-mail,ISBN1,ISBN2
333,Pablo3,Alar3,mail3,0,0
```
```
RUT,Nombre,Apellido,E-mail,ISBN1,ISBN2
333,Pablo3,Alar3,mail3,777,0
```
```python
# open using dict reader
for row in data:
        if row['RUT'] == rut:
            row['ISBN1'] = new_isbn1
```

### Pandas
#### CSV
```python
import pandas as pd
df = pd.read_csv('data.csv', index_col=0)
df.loc[333,'ISBN1'] = 777
print(df)
# export example
df.to_csv('temp2.txt')
```
<!--stackedit_data:
eyJoaXN0b3J5IjpbMTUyMjQxMDU1LDEwMTg2NTY4MDEsLTE5ND
cxMDU3NDIsOTMwOTQ5MDc5LDM2ODY5MTk3LC0xOTcxMDE2NzA3
LC0yMDYxNjc2NTUzXX0=
-->