Using regex to map values in dataframe using python

Question

have a df with values :


name   number     addition

tom    123        this is tom , number is [[number]]
mark   1234       this is mark , number is [[number]]

using regex how to map value in number column with [[number]] in addition column like this


name   number     addition

tom    123        this is tom , number is 123
mark   1234       this is mark , number is 1234

Code Different · Accepted Answer · 2020-10-13 11:25:07Z

3

You can use apply:

df['addition'] =  df.apply(lambda row: row['addition'].replace('[[number]]', str(row['number'])), axis=1)

answered Oct 13, 2020 at 11:25

Code Different

93.4k16 gold badges154 silver badges175 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1