How To Replace A Word In A Csv File In Specific Column With Python

Good day, I tried to change a word in a certain column,using index, in a csv file ,but it is not changed. My code that I tried to use: import csv with open('INPUT.CSV', 'r') as fi

Solution 1:

A working example would be better (output is open as file2 but writer is given outfile)

But in any case your problem is replace

• replace returns a copy of the string (with replaced text if the criteria matches)

But you are discarding the returned value. You are actually changing nothing in row[0]

Answer :

replaced = row[0].replace('word','changed word')  # I want to replace in first column=row[0] 'word' with 'changed word'
row[0] = replaced
writer.writerow(row)

Solution 2:

row[0].replace() does not replace anything in row[0]. From the docstring:

S.replace(old, new[, count]) -> string

Return a copy of string S with all occurrences of substring old replaced by new. If the optional argument count is given, only the first count occurrences are replaced.

If you want to change the value of row[0] you need something like row[0] = new_value.