How do I replace keys in strings in a pandas data frame in a loop from dictionaries with values?

Question

I have a dictionary called mapped

{'A=': 0,
  'B=': 1,
  'C=': 2,
  'D=': 3}

and a series called subject

0       [A=4.2, B=402, C=100]
1       [A=4.2, B=399, C=200]
2       [A=FIX.4.2, B=398, C=150]

I want the string instances in my series to be replaced by the value of dictionary in following way

0       [0=4.2, 1=402, 2=100]
1       [0=4.2, 1=399, 2=200]
2       [0=FIX.4.2, 1=398, 2=150]

I tried

subject=subject.replace(mapped_1, regex=True)
df=subject.apply(lambda x : x,mapped)

but I cannot replace inside the strings and python only changes the first instance.

could you include the DataFrame and Series constructors for your data posted here? — user7864386
– user7864386, Commented Jan 24, 2022 at 20:00

azro · Accepted Answer · 2022-01-24 20:09:44Z

1

I'd suggest a method that replace all keys by all values, then apply it

def replacer(value, mappings):
    for k, v in mappings.items():
        value = value.replace(k, v)
    return value



mapped = {'A=': 0, 'B=': 1, 'C=': 2, 'D=': 3}
subject = pd.Series(["[A=4.2, B=402, C=100]", "[A=4.2, B=399, C=200]", "[A=FIX.4.2, B=398, C=150]"])
mapped_ok = {k.replace("=", ""): str(v) for k, v in mapped.items()}
subject = subject.apply(lambda x: replacer(x, mapped_ok))
print(subject)

0        [0=4.2, 1=402, 2=100]
1        [0=4.2, 1=399, 2=200]
2    [0=FIX.4.2, 1=398, 2=150]
dtype: object

Or with functools.reduce

from functools import reduce

def replacer(value, mappings):
    return reduce(lambda val, kv: val.replace(kv[0], kv[1]),
                  mappings.items(),
                  value)

answered Jan 24, 2022 at 20:09

azro

54.2k9 gold badges39 silver badges75 bronze badges

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

Collectives™ on Stack Overflow

How do I replace keys in strings in a pandas data frame in a loop from dictionaries with values?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related