How to fix AttributeError: 'list' object has no attribute 'replace' when I try to replace some text in a csv read

Question

I try to replace a text in csv read with some data dictionary, but I got an Error.

import csv

dataset = open('../sentimenprabowo.csv', 'r')
sentiment = csv.reader(dataset, delimiter=',')

newDok = open('../sentimenprabowopreproses.csv', 'w')
save = csv.writer(newDok)

data= open("convertcsv.json", "r")
APPOSTOPHES=data.read()

new_sentence = []
for row in sentiment:     
    print(row)
    for candidate_replacement in APPOSTOPHES:                
        if candidate_replacement in row:            
            #print(candidate_replacement)
            row = row.replace(candidate_replacement, APPOSTOPHES[candidate_replacement])
    new_sentence.append(row)
rfrm = "".join(new_sentence)
print(rfrm)

I hope this can be replace all the text in my csv who same text with data dictionary (correction spelling).

but the result is error:

  File "readdata.py", line 45, in <module>
    row = row.replace(candidate_replacement, APPOSTOPHES[candidate_replacement])
AttributeError: 'list' object has no attribute 'replace'

help me please...

this is my convertcsv.json file:

{"@":"di","ababil":"abg labil","abis":"habis","acc":"accord","ad":"ada","adlah":"adalah"}

`replace` can only apply to `str`, seems `row` is `list` here. — recnac, Apr 10 '19 at 06:07
To replace list items check https://stackoverflow.com/questions/2582138/finding-and-replacing-elements-in-a-list-python — Anonymous, Apr 10 '19 at 06:11
I think you should figure out the composition of your data, I can not debug the context, maybe `for s in row`? — recnac, Apr 10 '19 at 06:13

Shahin Shemshian · Answer 1 · 2019-04-10T06:25:55.907

3

As the error says your row is a list and doesn't have replace method. You can convert it to string replace as you wish then again cast to array:

row = str(row).replace(candidate_replacement, APPOSTOPHES[candidate_replacement]).split(',')

edited Apr 10 '19 at 06:25

answered Apr 10 '19 at 06:14

Shahin Shemshian

356
1
11

score 1 · Answer 2 · answered Apr 10 '19 at 06:13

1

You can do this with list comparison

use this

for r in range(len(row)):
    if row[r] == candidate_replacement:
        row[r] = APPOSTOPHES[candidate_replacement]

answered Apr 10 '19 at 06:13

Alif Jahan

793
1
7
20

How to fix AttributeError: 'list' object has no attribute 'replace' when I try to replace some text in a csv read

2 Answers2