string manipulation with python pandas and replacement function

Question

I'm trying to write a code that checks the sentences in a csv file and search for the words that are given from a second csv file and replace them,my code is as bellow it doesn't return any errors but it is not replacing any words for some reasons and printing back the same sentences without and replacement.


import string
import pandas as pd
text=pd.read_csv("sentences.csv")
change=pd.read_csv("replace.csv")
for row in text:
    print(text.replace(change['word'],change['replacement']))

the sentences csv file looks like

and the change csv file looks like

Does this answer your question? [Use dictionary to replace a string within a string in Pandas columns](https://stackoverflow.com/questions/46342492/use-dictionary-to-replace-a-string-within-a-string-in-pandas-columns) — rpanai, Dec 24 '19 at 12:59

score 3 · Accepted Answer · answered Dec 24 '19 at 12:47

3

Try:

text=pd.read_csv("sentences.csv")
change=pd.read_csv("replace.csv")
toupdate = dict(zip(change.word, change.replacement))
text = text['sentences'].replace(toupdate, regex=True)
print(text)

answered Dec 24 '19 at 12:47

Rakesh

81,458
17
76
113

1

thank you that worked fine can you explain the dict and zip function what they do in short for this code please – programming freak Dec 24 '19 at 12:49
2

zip creates an iterable tuple with two lists and dict will create a dictionary out of the tuples as key, value pair – cerofrais Dec 24 '19 at 12:51

score 1 · Answer 2 · answered Dec 24 '19 at 12:48

1

dataframe.replace(x,y) changes complete x to y, not part of x.

you have to use regex or custom function to do what you want. for example :

change_dict = dict(zip(change.word,change.replacement))
def replace_word(txt):
    for key,val in change_dict.items():
        txt = txt.replace(key,val)
return txt
print(text['sentences'].apply(replace_word))

answered Dec 24 '19 at 12:48

cerofrais

1,117
1
12
32

thank you I tried this as well but it should be in a for loop to do all sentences because it is just replacing the first sentence, can you enplane the first line of your code please the dict and zip what they do – programming freak Dec 24 '19 at 12:53
.apply takes care of the loop, explained zip and dict on answer post – cerofrais Dec 24 '19 at 12:55
then your code is just doing it for the first replacement and stops – programming freak Dec 24 '19 at 13:01

score 0 · Answer 3 · edited Dec 24 '19 at 18:24

0

// to create one more additonal column to avoid any change in original colum

text["new_sentence"]=text["sentences"]

for changeInd in change.index:
    for eachTextid in text.index:
        text["new_sentence"][eachTextid]=text["new_sentence"][eachTextid].replace(change['word'][changeInd],change['replacement'][changeInd])

clear code: click here plz

edited Dec 24 '19 at 18:24

julka

1,172
2
13
29

answered Dec 24 '19 at 17:53

Nitesh Srivastava

1

string manipulation with python pandas and replacement function

3 Answers3