Pandas: Convert dictionary to dataframe where keys and values are the columns

Question

I have a dictionary like so:

d = {'3a0fe308-b78d-4080-a68b-84fdcbf5411e': 'SUCCEEDED-HALL-IC_GBI', '7c975c26-f9fc-4579-822d-a1042b82cb17': 'SUCCEEDED-AEN-IC_GBI', '9ff20206-a841-4dbf-a736-a35fcec604f3': 'SUCCEEDED-ESP2-IC_GBI'}

I would like to convert my dictionary into something like this to make a dataframe where I put all the keys and values in a separate list.

d = {'key': ['3a0fe308-b78d-4080-a68b-84fdcbf5411e', '7c975c26-f9fc-4579-822d-a1042b82cb17', '9ff20206-a841-4dbf-a736-a35fcec604f3'],
     'value': ['SUCCEEDED-HALL-IC_GBI', 'SUCCEEDED-AEN-IC_GBI', 'SUCCEEDED-ESP2-IC_GBI']

What would be the best way to go about this?

Manuel · Accepted Answer · 2020-12-23 15:59:19Z

3

You can easily create a DataFrame like this:

import pandas as pd

d = {'3a0fe308-b78d-4080-a68b-84fdcbf5411e': 'SUCCEEDED-HALL-IC_GBI',
     '7c975c26-f9fc-4579-822d-a1042b82cb17': 'SUCCEEDED-AEN-IC_GBI',
     '9ff20206-a841-4dbf-a736-a35fcec604f3': 'SUCCEEDED-ESP2-IC_GBI'}
table = pd.DataFrame(d.items(), columns=['key', 'value'])

If you just want to rearrange your Dictionary you could do this:

d2 = {'key': list(d.keys()), 'value': list(d.values())}

answered Dec 23, 2020 at 15:59

Manuel

666 bronze badges

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

1 Comment

bhagerty Over a year ago

This use of items() to pass in keys and values as individual columns was just what I was looking for. Not obvious; very clever. Thanks!

Quang Hoang · Accepted Answer · 2020-12-23 15:55:24Z

1

Since you tagged pandas, try:

pd.Series(d).reset_index(name='value').to_dict('list')

Output:

{'index': ['3a0fe308-b78d-4080-a68b-84fdcbf5411e',
  '7c975c26-f9fc-4579-822d-a1042b82cb17',
  '9ff20206-a841-4dbf-a736-a35fcec604f3'],
 'value': ['SUCCEEDED-HALL-IC_GBI',
  'SUCCEEDED-AEN-IC_GBI',
  'SUCCEEDED-ESP2-IC_GBI']}

Pure python:

{'key':list(d.keys()), 'value': list(d.values())}

output:

{'key': ['3a0fe308-b78d-4080-a68b-84fdcbf5411e',
  '7c975c26-f9fc-4579-822d-a1042b82cb17',
  '9ff20206-a841-4dbf-a736-a35fcec604f3'],
 'value': ['SUCCEEDED-HALL-IC_GBI',
  'SUCCEEDED-AEN-IC_GBI',
  'SUCCEEDED-ESP2-IC_GBI']}

answered Dec 23, 2020 at 15:55

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

Comments

juananthony · Accepted Answer · 2020-12-23 16:03:41Z

1

You can create the dataframe zipping the key/value lists with zip function:

import pandas as pd

df = pd.DataFrame(list(zip(d.keys(),d.values())), columns=['key','value'])

answered Dec 23, 2020 at 16:03

juananthony

196 bronze badges

Collectives™ on Stack Overflow

Pandas: Convert dictionary to dataframe where keys and values are the columns

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related