Add column to pandas dataframe indexed by another column

Question

I have a pandas dataframe that looks like

        some_data  another_id
id                                                            
312871     ...     abc
312977     ...     def
...

and a dictionary letters = {"abc": "x", "def": "y"}. I want to add letters as a column to my dataframe, but it is morally indexed by another_id so I can't just set df["letters"] = letters.

I'm sure there's a beautiful, elegant way to do this. What is it?

Rutger Kassies · Accepted Answer · 2013-06-28 08:39:55Z

1

I hope i understand your question correct. Do you want something like:

df['letters'] = df['another_id'].map(letters)

        some_data another_id letters
id                                  
312871          5        abc       x
312977          6        def       y

answered Jun 28, 2013 at 8:39

Rutger Kassies

65k17 gold badges119 silver badges102 bronze badges

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

Comments

Katriel · Accepted Answer · 2013-06-28 08:41:55Z

0

Aha!

df.merge(pd.DataFrame({"letters": letters}), left_on="dscode", right_index=True)

answered Jun 28, 2013 at 8:41

Katriel

124k19 gold badges141 silver badges172 bronze badges

Collectives™ on Stack Overflow

Add column to pandas dataframe indexed by another column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related