[csv] 읽고 쓰기

 

CSV파일을 읽고 쓰고자 할 때

 

읽기

with open(CSV_FILEPATH, 'r', newline='') as file:
  lines = csv.reader(file)
  rows = []
  for row in lines:
  	rows.append(row)

 

 

 

 

쓰기  - list 활용 

with open (CSV_FILEPATH ,'w', newline='') as csvfile:
  writer = csv.writer(csvfile)
  writer.writerow(['id', 'username'])
  for list in userlist:
    writer.writerow(list)

 

 

 

쓰기 - dict 활용

with open (CSV_FILEPATH ,'w', newline='') as csvfile:
  writer = csv.DictWriter(csvfile, fieldname=['id', 'username'])
  writer.writeheader()

  for list in lines_ls:
    writer.writerow({'id':list[0], 'username':list[1]})