How to insert data into a specific cell in csv with python?

Question

I am trying to insert data into a specific cell in csv. My code is as follows.

The existing file.

Output

The data in cell A1("Custmor") is replaced with new data("Name").

My code is as follows.

import pandas as pd

#The existing CSV file
file_source = r"C:\Users\user\Desktop\Customer.csv"

#Read the existing CSV file
df = pd.read_csv(file_source)

#Insert"Name"into cell A1 to replace "Customer"
df[1][0]="Name"

#Save the file
df.to_csv(file_source, index=False)

And it doesn't work. Please help me finding the bug.

Ynjxsjmh · Accepted Answer · 2022-05-29 08:21:03Z

2

Customer is column header, you need do

df = df.rename(columns={'Customer': 'Name'})

answered May 29, 2022 at 8:21

Ynjxsjmh

30.3k7 gold badges43 silver badges64 bronze badges

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

Comments

Saravanan Ramanathan · Accepted Answer · 2022-05-29 08:41:51Z

-1

I am assuming you are going to want to work with header less csv so if that's the case, your code is already correct, just need to add header=None while reading from csv

import pandas as pd

#The existing CSV file
file_source = r"C:\Users\user\Desktop\Customer.csv"

#Read the existing CSV file
df = pd.read_csv(file_source,header=None) #notice this line is now different

#Insert"Name"into cell A1 to replace "Customer"
df[1][0]="Name"

#Save the file
df.to_csv(file_source, index=False,header=None) #made this header less too

edited May 29, 2022 at 8:41

answered May 29, 2022 at 8:31

Saravanan Ramanathan

516 bronze badges

1 Comment

Thierry Lathuille Over a year ago

The cell the OP tries to modify is a header. Trying to consider headers as part of the data is a very bad choice.

Collectives™ on Stack Overflow

How to insert data into a specific cell in csv with python?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related