Replacing characters in Pandas Column

Question

Would like to replace every character with another specific character in panda df['column'] or create a new column with new output. Replace all K with B, 1 to 4, 2 to 3, 3 to 8.

Original column values:

0    K123D
1    K312E
2    K231G

Output:

0    B438D
1    B843E
2    B384G

check this: https://stackoverflow.com/questions/28986489/how-to-replace-text-in-a-column-of-a-pandas-dataframe — Harish Vutukuri, Dec 17 '20 at 16:40
Have you search about `str.replace()` & `.astype()` in pandas? — Ice Bear, Dec 17 '20 at 16:40

score 2 · Answer 1 · answered Dec 17 '20 at 16:40

2

Check replace

df.col = df.col.replace({'K':'B','1':'4','3':'8','2':'3'},regex=True)
0    B438D
1    B843E
2    B384G
Name: col, dtype: object

answered Dec 17 '20 at 16:40

BENY

317,841
20
164
234

score 1 · Accepted Answer · answered Dec 17 '20 at 16:40

You could use str.translate:

df = pd.DataFrame(data=["K123D",
                        "K312E",
                        "K231G"], columns=['data'])

table = str.maketrans({'K' : 'B', '1' : '4', '2' : '3', '3': '8'})

df['res'] = df['data'].str.translate(table)

print(df)

Output

    data    res
0  K123D  B438D
1  K312E  B843E
2  K231G  B384G

Replacing characters in Pandas Column

2 Answers2