From Python dataframe to nested dictionary

Question

I want to use an api and would need to put my dataframe in a dictionary format first. The dataframe df that looks like this:

    OrigC  OrigZ  OrigN Weigh  DestC   DestZ    DestN
0      PL     97    TP    59     DE      63       SN

Exepected output of the first row:

{"section":[
    {"location":
        {
        "zipCode":
            {"OrigC": "PL",
            "OrigZ":"97"},
        "location": {"id": "1"},
        "OrigN": "TP"
            },
    "carriageParameter":
        {"road":
            {"truckLoad": "Auto"}
        },
    "load":
        {"Weigh": "59",
        "unit": "ton",
        "showEmissionsAtResponse": "true"
        }
    },
    {"location":
        {
        "zipCode":
            {"DestC": "DE",
            "DestZ":"63"},
        "location": {"id": "2"},
        "DestN": "SN"
            },
    "carriageParameter":
        {"road":
            {"truckLoad":"Auto"}
        },
    "unload":
        {"WEIGHTTONS":"59",
        "unit": "ton",
        "showEmissionsAtResponse": "true"
        }
    }]}

Note that there is static information in the dictionary that doesn't require any change.

How can this be done in Python?

warped · Accepted Answer · 2020-07-01 09:34:33Z

3

You can use iterrows.

dic = {}
dic['section'] = []
for ix, row in df.iterrows():
    
    in_dict = {
        'location': {
            'zip_code': {
                'OrigC': row['OrigC'],
                'OrigZ': row['OrigZ'],
                },
            'location': {'id': ix+1}, # I am guessing here.
            'OrigN': 'TP',  
        },
        'CarriageParameter': {
            'road': {
                'truckLoad': 'Auto'}
            },
        'load': {
            'Weigh': str(row['Weigh']),
        } 
        }
    
    
    dic['section'].append(in_dict)

Note that this is not the entire entry, but I think it is clear enough to illustrate the idea.

answered Jul 1, 2020 at 9:34

warped

9,6655 gold badges26 silver badges55 bronze badges

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

7 Comments

Gomelsar BARO Over a year ago

Thanks @warped, i tried the code, executed but nothing is printed on the ouput, there is no errors showed

warped Over a year ago

What would you like to print?

Gomelsar BARO Over a year ago

the dictionary structure as described in the expected output

warped Over a year ago

try print(dic) ?

warped Over a year ago

for prettier prints you can check out pprint. In your case: import pprint and then pprint.pprint(dic)

|

Collectives™ on Stack Overflow

From Python dataframe to nested dictionary

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related