replace dictionary keys (strings) in Python

Question

After CSV import, I have following dictionary with keys in different language:

dic = {'voornaam': 'John', 'Achternaam': 'Davis', 'telephone': '123456', 'Mobielnummer': '234567'}

Now I want to change keys to English and (also to all lowercase). Which should be:

dic = {'first_name':  'John', 'last_name': 'Davis', 'phone': '123456', 'mobile': '234567'}

How can I achieve this?

Why downvotes? I think I need to know why so that I can improve the question. — chhantyal
– chhantyal, Commented Jul 29, 2013 at 20:08
The question doesn't show much research effort. For example, what approach(es) make sense to you? Have you attempted to implement any of them? What happened when you tried? — kojiro
– kojiro, Commented Jul 29, 2013 at 20:14

roman · Accepted Answer · 2013-07-29 20:08:22Z

24

you have dictionary type, it fits perfectly

>>> dic = {'voornaam': 'John', 'Achternaam': 'Davis', 'telephone': '123456', 'Mobielnummer': '234567'}
>>> tr = {'voornaam':'first_name', 'Achternaam':'last_name', 'telephone':'phone', 'Mobielnummer':'mobile'}
>>> dic = {tr[k]: v for k, v in dic.items()}
{'mobile': '234567', 'phone': '123456', 'first_name': 'John', 'last_name': 'Davis'}

answered Jul 29, 2013 at 20:08

roman

118k30 gold badges205 silver badges209 bronze badges

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

2 Comments

roman Over a year ago

I don't think OP want to convert values to lowecase, am I missed something?

chhantyal Over a year ago

Yes indeed, I want keys to be English and all lowercase, not values.

Maciej Gol · Accepted Answer · 2013-07-29 20:08:00Z

1

name_mapping = {
    'voornaam': 'first_name',
    ...
}

dic = your_dict

# Can't iterate over collection being modified,
# so change the iterable being iterated.
for old, new in name_mapping.iteritems():
    value = dic.get(old, None)
    if value is None:
        continue

    dic[new] = value
    del dic[old]

answered Jul 29, 2013 at 20:08

Maciej Gol

15.9k4 gold badges35 silver badges52 bronze badges

Comments

Sunil · Accepted Answer · 2016-07-12 20:26:41Z

1

Above solution works great if there are NO nested dictionary objects in input dict.

Below is more generalized utility function that replaces existing keys with new set of keys recursively.

def update_dict_keys(obj, mapping_dict):
    if isinstance(obj, dict):
        return {mapping_dict[k]: update_dict_keys(v, mapping_dict) for k, v in obj.iteritems()}
else:
    return obj

Test:

dic = {'voornaam': 'John', 'Achternaam': 'Davis', 
'telephone':'123456', 'Mobielnummer': '234567',
"a": {'Achternaam':'Davis'}}
tr = {'voornaam': 'first_name', 'Achternaam': 'last_name', 
'telephone':'phone', 'Mobielnummer': 'mobile', "a": "test"}

Output:

{
'test': {
    'last_name': 'Davis'
},
'mobile': '234567',
'first_name': 'John',
'last_name': 'Davis',
'phone': '123456'
}

edited Jul 12, 2016 at 20:26

answered Jul 12, 2016 at 20:14

Sunil

975 silver badges12 bronze badges

Collectives™ on Stack Overflow

replace dictionary keys (strings) in Python

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related