[Python] CSV (TSV) 파일 읽기 및 쓰기

CSV (TSV) 파일 읽기

import csv
import pandas as pd

# read CSV files
with open('input.csv') as f:
	cr = csv.reader(f)
    for row in cr:
    	print(row)

# read CSV files (using pandas)
data = pd.read_csv("input.csv", keep_default_na=False)
for index, row in data.iterrows():
    print(index, row['c1'])


# read TSV files
with open('input.tsv') as f:
	tr = csv.reader(f, delimiter='\t')
    for row in tr:
    	print(row)

# read TSV files (using pandas)
data = pd.read_csv("input.tsv", delimiter='\t', keep_default_na=False)
for index, row in data.iterrows():
    print(index, row['c1'])

 

 

CSV (TSV) 파일 쓰기

import csv

# write CSV files
with open('result.csv', 'w', encoding='utf-8', newline='') as f:
	cw = csv.writer(f)
	cw.writerow(['source', 'target', 'value'])
	cw.writerow(['A', 'B', 10])


# write TSV files
with open('result.tsv', 'w', encoding='utf-8', newline='') as f:
	tw = csv.writer(f, delimiter='\t')
	tw.writerow(['source', 'target', 'value'])
	tw.writerow(['A', 'B', 10])