Adding data from a list to csv columns that already have data

Question

I am new to Python, so I would like to ask:

I have a csv with two columns A and B.

A	B
1	testa
2	testb

What I want to do is to add data to this CSV. I have the data which I want to add in a list in Python. This is mydata_list: [[3, 'testd'], [4, 'teste'], [5, 'testf'], [6, 'testg']]

How do I add this mydata_list to my csv columns, which already have data? I have been trying with something like this, but it doesn't work.

with open(filename, 'w') as file:
    writer = csv.DictWriter(file, fieldnames=["A", "B"])
    if row['A'] == 4:
        for e in mydata_list:
            writer.writerow(e)

Abhishek Kumar Saw · Accepted Answer · 2021-03-08 16:41:48Z

1

you can use csv library for the same. Refer below:

# Importing library 
import csv 
  
# data to be written row-wise in csv file 
data = [[3, 'testd'], [4, 'teste'], [5, 'testf'], [6, 'testg']]
  
# opening the csv file in 'a+' mode 
file = open(filename, 'a+', newline ='') 
  
# writing the data into the file 
with file:     
    write = csv.writer(file) 
    write.writerows(data)

answered Mar 8, 2021 at 16:41

Abhishek Kumar Saw

3492 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Adding data from a list to csv columns that already have data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related