How to Replace Pandas Series with Dictionary Values

Question

I want to link my dictionary values to pandas series object. I have already tried replace method and map method still no luck.

As per link: Replace values in pandas Series with dictionary

Still not working, my sample pandas looks like:

index                    column
0                      ESL Literacy
1    Civics  Government Team Sports
2      Health  Wellness Team Sports
3              Literacy Mathematics
4                       Mathematics

Dictionary:

{'civics': 6,
 'esl': 5,
 'government': 7,
 'health': 8,
 'literacy': 1,
 'mathematics': 4,
 'sports': 3,
 'team': 2,
 'wellness': 9}

Desired Output:

0 [5,1]
1 [6,7,2,3]
2 [8,9,2,3]
3 [1,4]
4 [4]

Any help would be appreciated. Thank you :)

IanS · Accepted Answer · 2019-07-29 18:55:01Z

6

A fun solution

s=df.column.str.get_dummies(' ')
s.dot(s.columns.str.lower().map(d).astype(str)+',').str[:-1].str.split(',')
Out[413]: 
0          [5, 1]
1    [6, 7, 3, 2]
2    [8, 3, 2, 9]
3          [1, 4]
4             [4]
dtype: object

Or in pandas 0.25.0 we can use explode:

df.column.str.split().explode().str.lower().map(d).groupby(level=0).agg(list)
Out[420]: 
0          [5, 1]
1    [6, 7, 2, 3]
2    [8, 9, 2, 3]
3          [1, 4]
4             [4]
Name: column, dtype: object

edited Jul 29, 2019 at 18:55

IanS

16.3k9 gold badges64 silver badges87 bronze badges

answered Jul 29, 2019 at 18:34

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Comments

user3483203 · Accepted Answer · 2019-07-29 18:26:06Z

4

Using str.lower, str.split, and a comprehension.

u = df['column'].str.lower().str.split('\s+')

pd.Series([[d.get(word) for word in row] for row in u])

0          [5, 1]
1    [6, 7, 2, 3]
2    [8, 9, 2, 3]
3          [1, 4]
4             [4]
dtype: object

answered Jul 29, 2019 at 18:26

user3483203

51.3k10 gold badges72 silver badges104 bronze badges

Collectives™ on Stack Overflow

How to Replace Pandas Series with Dictionary Values

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related