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!
The short answer is: yes. Use the CSV module: read a line from the CSV and write the line to a text file.
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 pdimport numpy as np
import pandas as pd
src = csvfile
tab = pd.io.parsers.read_table(str(src), sep=',')
uniquerows = np.unique(tab['fc'])
for key in uniquerows:
exprow = tab[tab['fc'] == key]
exprow.to_csv(r'H:\Documents\\' + str(key) + '.csv')
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!
Retrieving data ...