topic Re: export a each row from a CSV, with 100s of rows, as an individual text file in Developers Questions

export a each row from a CSV, with 100s of rows, as an individual text file

Anonymous User — Mon, 25 Aug 2014 20:20:40 GMT

Is there a way to have python export a single row from a CSV, with 100s of rows, as an individual text file? IE if you had a CSV with 100 rows you would get 100 .txt files for each row/record.

Thanks in advanced!

Re: export a each row from a CSV, with 100s of rows, as an individual text file

DarrenWiens2 — Mon, 25 Aug 2014 20:33:25 GMT

The short answer is: yes. Use the CSV module: read a line from the CSV and write the line to a text file.

Re: export a each row from a CSV, with 100s of rows, as an individual text file

JamesCrandall — Sat, 11 Dec 2021 07:07:00 GMT

Alternative option is to use the Pandas library to read in the .csv, go thru the unique rows and export each one to it's own .csv file. In this example it just names each of the unique .csv files using the first column specified ('fc')

import pandas as pd
import numpy as np


import pandas as pd





def exportCSVbyRow(csvfile):
    src = csvfile
    tab = pd.io.parsers.read_table(str(src), sep=',')
    uniquerows = np.unique(tab['fc'])
    for key in uniquerows:
        print key
        exprow = tab[tab['fc'] == key]
        exprow.to_csv(r'H:\Documents\\' + str(key) + '.csv')





exportCSVbyRow(r'H:\Documents\arlist.csv')

Re: export a each row from a CSV, with 100s of rows, as an individual text file

Anonymous User — Tue, 26 Aug 2014 20:58:20 GMT

Thanks all for the help, really appreciate it! I was asking for a colleague and it looks like she figured it out. Ill post her script when she sends it. Great community we got here!