How to split csv file line by line into many files?

Question

csv

There is a file in csv format, let's say it has 1000 lines and 2 columns. Q: How can this file be divided into 1000 files, i.e. line by line?

Answer 1

It is possible in Python:

with open('data.csv') as file:
  lines = file.read().splitlines()

def write_line(filename, line):
  with open(filename+'.csv','w') as file:
    file.write(line)

for i,line in enumerate(lines):
  write_line(str(i),line)

This script reads the data.csv file and writes each line to a new file - 0.csv, 1.csv, 2.csv, and so on until the end of the input file.