Using pandas cell as a key [duplicate]

Question

I have a df where each row has a code that indicates a department.

On the other hand, I have a dictionary in which each code corresponds to a region name (a region is constituted of multiple departments).

I thought of a loop to put the value in a new column that indicates the region.

Here is what I thought would work:

for r in df:
    dep = r["dep"].astype(str)
    r["region"] = dep_dict.get(dep)

But the only thing I get is "string indices must be integers". Do you people know how could I make it work ? Or if I should take a totally different route (like joining) ?

Thanks ! 🙏

The r in for r in df is a column header (which is a string, in your case). So, r["dep"] is an attempt to index a string with a string. — DYZ
– DYZ, Commented Jul 4, 2018 at 23:15

Bartek Malysz · Accepted Answer · 2018-07-04 23:48:18Z

0

df.region =  df.dep.apply(lambda x: dep_dict[x])

Would this help?

edited Jul 4, 2018 at 23:48

answered Jul 4, 2018 at 23:06

Bartek Malysz

1,0227 gold badges17 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

Using pandas cell as a key [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related