如何替换pandas数据框架中某些字符前面的字符串

Question

这是我的数据集

Id  Text
1   Animation_and_Cartoon - Comics and Anime/Cartoon_and_anime
2   Animation_and_Cartoon - Comics and Anime/Manga_and_anime

期望输出是-之前的全部_被' '取代，但-之后不

Id  Text
1   Animation_and_Cartoon - Comics and Anime/Cartoon_and_anime
2   Animation_and_Cartoon - Comics and Anime/Manga_and_anime

Answer 1

您可以使用:

df['Text'] = df['Text'].str.replace(
r'^([^-]+)',
lambda m: m.group().replace('_and_',' and '),
regex=True)

输出:

Id                                                        Text
0   1  Animation and Cartoon - Comics and Anime/Cartoon_and_anime
1   2    Animation and Cartoon - Comics and Anime/Manga_and_anime