Write data from multiple input CSV file to a single CSV in column format

Question

I'm trying to

loop over multiple csv files,
extract information from them
write an output into one new csv file with a row for each of the original files.

I take the information:

Name, Date, Time, Test, Navg, Percent

for each row.

I have tried to do it, however I have the problems:

It writes each of Name, Date, Time, Test, Navg, Percent to a NEW ROW...I want each word in a new column

It writes each new file to the a new row underneath(I do want it underneath, but with each word in a column.

b = open('C:\Users\AClayton\Desktop\Data.csv', 'a')
a = csv.writer(b,delimiter='\t',lineterminator='\n')
a.writerows((Name, Date, Time, Test, Navg, Percent))
b.close()

Note the file has been read and the data extracted in earlier code.

Please don't add text like "[Python]" to your question's title - tagging the question correctly is sufficient. — John Parker
– John Parker, Commented Sep 10, 2013 at 9:24

sebastian · Accepted Answer · 2013-09-10 09:26:51Z

1

writerows interpretes the input argument as a list of rows, hence each item in your tuple is written into a separate row. Using writerow should write it into a single row.

answered Sep 10, 2013 at 9:26

sebastian

9,71628 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ashleigh Clayton Over a year ago

thanks, Sebastian, it's half way there. However, I would like to put each in a new cell in the csv. At the moment it is all in one cell

Ashleigh Clayton Over a year ago

ahh changed the delimiter to a comma and it worked perfectly :)

Collectives™ on Stack Overflow

Write data from multiple input CSV file to a single CSV in column format

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related