Replace column with another column in CSV on Python

Question

I have this code that replaces a string for another string and I'm wondering if there's an easier way to do this. Instead of doing the .replace for each one, I want to just read a column and replace it with the column next to it instead of writing out .replace.

text = open('thecode.csv','r') text = ''.join([i for i in text]) \ .replace('Salam', 'Hello') \ .replace('somebody', 'anybody') \

How can I go about this quicker if I have two columns that look like this:

Column1         Column2
Salam            Hello 
somebody         anybody

Chris · Accepted Answer · 2020-06-01 19:29:47Z

1

This would be easier in Pandas.

import pandas as pd
df = pd.read_csv('thecode.csv') 
df['Column1'] = df['Column2']
df.to_csv('fixed_output.csv', index=False)

answered Jun 1, 2020 at 19:29

Chris

16.3k3 gold badges26 silver badges41 bronze badges

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

Comments

snatchysquid · Accepted Answer · 2020-06-01 19:30:32Z

0

may I suggest using Pandas? read your file using pd.read_csv simply create a Series from your new column and replace it with the column in the correction position where you want. don't foreget to use to_csv at the end to write the result.

answered Jun 1, 2020 at 19:30

snatchysquid

1,38212 silver badges25 bronze badges

Collectives™ on Stack Overflow

Replace column with another column in CSV on Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related