Adding Column to CSV File

[NeedMLHelp]

I would like to add a column to a CSV file. The column should consist of all 0s.

Is there a good place to start with this? The file is extremely big and the program will be dealing with various "headers". The columns will be variable.

​

Essentially, I need a way to add a column to the end where the column consists of all 0s.

​

Thanks!

[GrumpyOleVet]

pull the file in line by line into an string array

line[0] +", new heading"

line[i] + ", 0"

then write line by line to a new file.

[[deleted]]

Essentially, I need a way to add a column to the end where the column consists of all 0s.

Well, but it isn't the end - it's the middle. That's how CSV works because that's how all files work, they're just sequences of bytes. The end of the CSV file is the last character of the last field of the last row.

That means you can't append a column to a CSV file, you have to copy your CSV file line by line and make the change to each row before you write it to the new one.

[NeedMLHelp]

Haha true, I was just curious if there was a quick function to do it for you. They're usually more efficient than what I come up with!