Append data to csv columns python

Question

How the csv looks like

col1,col2,col3,col4,col5
value1,value2,value3,value4,value5
,,value6,value7,value8,value9
,,value10,value11,value12,value13

how my function looks so far

def append(file, value1, value2):
    with open(file, 'a',) as file:
        writer = csv.writer(file, quoting=csv.QUOTE_NONE, escapechar=' ')
        writer.writerow([value1, value2])

The append function is called inside a function where value 1 and value 2 are passed from.

If the csv file looks like the below, the function does the job

col1,col2,col3,col4,col5
value1,value2,value3,value4,value5

How could I write to a particular cell for as long as value1 and value2 are passed in. Don't need to wory about the values being passed, just for the function to introduce the arguments.

the csv would look like:


col1,col2,col3,col4,col5
value1,value2,value3,value4,value5
,,value6,value7,value8,value9
,,value10,value11,value12,value13

Expected result


col1,col2,col3,col4,col5
value1,value2,value3,value4,value5
argument1,argumen2,value6,value7,value8,value9
argument3,argument3,value10,value11,value12,value13

Use \n at begining of the line, and in the final. The idea is know if your files always comes without the return of line. — Vahram Danielyan
– Vahram Danielyan, Commented May 9, 2021 at 22:51
Thanks. I've updated the post, do you have a suggestion for the quotes? — Scilla
– Scilla, Commented May 9, 2021 at 23:17
I forgot about it. When i started thinking about this I was convinced that i will write to it, but then i realised I need to append because writing will overwrite the file. — Scilla
– Scilla, Commented May 9, 2021 at 23:30
Read the two articles I think you can understand. thispointer.com/how-to-append-text-or-lines-to-a-file-in-python — Vahram Danielyan
– Vahram Danielyan, Commented May 10, 2021 at 21:10

Vahram Danielyan · Accepted Answer · 2021-05-11 06:17:10Z

1

That way is how I was learned and is so easy:

def append_csv(file, *argv):
    my_line = ','.join([elem for elem in argv]) + '\n'
    file.write(my_line)
  
my_file = open('my_csv_file.csv', 'a')
append_csv(my_file, 'val1', 'val2', ... , 'valN')
my_file.close() # you need to close to save the changes.

edited May 11, 2021 at 6:17

answered May 9, 2021 at 23:28

Vahram Danielyan

3094 silver badges13 bronze badges

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

9 Comments

Scilla Over a year ago

I will give your code a try tmrw, but what i have it's pretty readable. your's is fancy.

Scilla Over a year ago

don't know what type of code is that. is it python3.8 ?

Vahram Danielyan Over a year ago

When I put out of loop is a comment. Is Python3 yes. It is easier work with file.write instead of writer

Scilla Over a year ago

I just updated the post, I found a bug that i did not consider, if you have the time to take a look.

Vahram Danielyan Over a year ago

It has a little job. Actually I will sleep, tomorrow I give you the answer. You can pass into function *args, and you don’t have to care about number of arguments

|

Collectives™ on Stack Overflow

Append data to csv columns python

1 Answer 1

9 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Related