PYTHON

converting a csv into python list

import csv
with open('records.csv', 'r') as f:
  file = csv.reader(f)
  my_list = list(file)
print(my_list)

list to csv

import csv

with open("out.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerows(a)

python csv to list

import csv
mycsv = list(csv.reader(datafile, delimiter=","))

how to convert csv into list

open('file.csv', 'r').read().splitlines() #assuming you want each row to be an individual element in the list

list to csv python

import csv
  
  
# field names 
fields = ['Name', 'Branch', 'Year', 'CGPA'] 
    
# data rows of csv file 
rows = [ ['Nikhil', 'COE', '2', '9.0'], 
         ['Sanchit', 'COE', '2', '9.1'], 
         ['Aditya', 'IT', '2', '9.3'], 
         ['Sagar', 'SE', '1', '9.5'], 
         ['Prateek', 'MCE', '3', '7.8'], 
         ['Sahil', 'EP', '2', '9.1']] 
  
with open('GFG', 'w') as f:
      
    # using csv.writer method from CSV package
    write = csv.writer(f)
      
    write.writerow(fields)
    write.writerows(rows)