How to replace certain values in a column with the values in another column?

Question

Keep in mind the 'None' value is a string so can't use .fillna

df[df['TRIPLINE'] == 'None']

I want to fill these string values with the corresponding value in the 'LINE' column

share the data in text format. not as an imagr – Onyambu Jun 03 '22 at 15:19 — Onyambu, Jun 03 '22 at 15:19

score 0 · Answer 1 · answered Jun 03 '22 at 15:19

0

As long as None is truly a string and not a np.nan or None you can use np.where()

import numpy as np
df['TRIPLINE'] = np.where(df['TRIPLINE'] == 'None', df['LINE'], df['TRIPLINE'])

answered Jun 03 '22 at 15:19

ArchAngelPwn

score 0 · Answer 2 · answered Jun 03 '22 at 15:21

0

Use .loc with your == 'None' mask:

act_thruput_raw.loc[act_thruput_raw['TRIPLINE'] == 'None', 'TRIPLINE'] = act_thruput_raw['LINE']

answered Jun 03 '22 at 15:21

score 0 · Answer 3 · answered Jun 03 '22 at 15:29

0

IIUC,

df['TRIPLINE'] = df['TRIPLINE'].mask(df['TRIPLINE'] == 'None', df['LINE'])

answered Jun 03 '22 at 15:29

Ynjxsjmh

3 Answers3