How to add a add a value to a pre-existing row in a csv file using python

Question

So I am trying to add a value to a pre-existing row in a csv file using python. I have literally scoured the web for any websites, previous StackOverflow Questions which have the answer I am looking for. But I can't find any. So basically, I want to change a csv file from

example,example,example
example2,example2,example2

to

example,example,example,example
example2,example2,example2,example2

I don't have any code because I have no idea how I could possibly do it.

You need to read the CSV from the file, add the column, add the row with the new column, and write the CSV back to a file. I suggest using `csv.DictReader` and `csv.DictWriter` from the standard library. — dh762, Aug 26 '20 at 09:31
instead of `example,example,example,example` add some meaningful data — deadshot, Aug 26 '20 at 09:32
Does this answer your question? [How to add a new column to a CSV file?](https://stackoverflow.com/questions/11070527/how-to-add-a-new-column-to-a-csv-file) — deadshot, Aug 26 '20 at 09:34
Traceback (most recent call last): File "C:/Users/myname/Desktop/folder123/testing.py", line 9, in row = next(reader) StopIteration — ComputerMecha123, Aug 26 '20 at 09:42

score 0 · Answer 1 · answered Aug 26 '20 at 10:01

0

if you want to add column to the last row only you can just append it like this

with open("file.csv","a") as csv_file:
    csv_file.write(",example2")

answered Aug 26 '20 at 10:01

Super Vegetoo

1
1

How to add a add a value to a pre-existing row in a csv file using python

1 Answers1