title: Basic Python CSV
tags: python csv

Read [the docs here](https://docs.python.org/3/library/csv.html).

# Reading
## From file
```py
import csv

data = []
with open(filename) as csvfile:
    reader = csv.reader(csvfile)
    for row in reader:
        data.append(row)
```

## From string
Use `StringIO`
```py
from io import StringIO
import csv

scsv = """text,with,Polish,non-Latin,letters
1,2,3,4,5,6
a,b,c,d,e,f
gęś,zółty,wąż,idzie,wąską,dróżką,
"""

f = StringIO(scsv)
reader = csv.reader(f, delimiter=',')
for row in reader:
    print('\t'.join(row))
```

# Writing
## Writing To File
```py
import csv
data = [ [ "hello", "world" ], [ 1, 2 ], [ 3, 4 ], [ "need,quote", 'quote "quote"' ] ]
with open('out.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    for row in data:
        writer.writerow(row)        
```