How to convert key and value of dictionary to a dataframe column?

Question

I have a Python dictionary and I am unable to convert key and value of dictionary to a dataframe column.

import pandas as pd
data={'form-0-publish': ['05/28/2019'], 'form-0-cell': ['81'], 'form-0-cell_name': ['13a'], 'form-0-jam': ['07.00-08.00'], 'form-0-target': ['60'],
      'form-1-publish': ['05/28/2019'], 'form-1-cell': ['81'], 'form-1-cell_name': ['13a'], 'form-1-jam': ['07.00-08.00'], 'form-1-target': ['60'],
      'form-2-publish': ['05/28/2019'], 'form-2-cell': ['81'], 'form-2-cell_name': ['13a'], 'form-2-jam': ['07.00-08.00'], 'form-2-target': ['60'],
      }
df = pd.DataFrame(data.items(), columns=['FormPublish', 'DatePublish', 'FormCell', 'Cell', 'FormCellName', 'FormCellName', 'FormJam', 'Jam', 'FormTarget', 'Target'])
df

Expected result:

> FormPublish      DatePublish FormCell Cell FormCellName FormCellName
> FormJam Jam FormTarget Target 0 form-0-publish ['05/28/2019'] ... 1
> form-0-publish ['05/28/2019'] ... 3 form-0-publish ['05/28/2019'] ...

Possible duplicate of [Convert Python dict into a dataframe](https://stackoverflow.com/questions/18837262/convert-python-dict-into-a-dataframe) — shaik moeed, Jul 09 '19 at 07:01
Use `pd.DataFrame.from_dict(data)` and [doc](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.from_dict.html) — shaik moeed, Jul 09 '19 at 07:19

score 0 · Answer 1 · answered Jul 09 '19 at 11:49

I think directly there is no function to perform this type of task, but I have made 2 for loops to get your result:-

data={'form-0-publish': ['05/28/2019'], 'form-0-cell': ['81'], 'form-0-cell_name': ['13a'], 'form-0-jam': ['07.00-08.00'], 'form-0-target': ['60'],
  'form-1-publish': ['05/28/2019'], 'form-1-cell': ['81'], 'form-1-cell_name': ['13a'], 'form-1-jam': ['07.00-08.00'], 'form-1-target': ['60'],
  'form-2-publish': ['05/28/2019'], 'form-2-cell': ['81'], 'form-2-cell_name': ['13a'], 'form-2-jam': ['07.00-08.00'], 'form-2-target': ['60'],
  }

my_list = []  #Getting all keys and values in a single list.
for key,value in data.items():
    my_list.append(key)
    my_list.append(*value)

new_list = []
extra_list = []
for index,var in enumerate(my_list):   # Making pairs of 10 elements from my_list.
    if index%10==0:
        new_list.append(extra_list)
        extra_list = [] 
        extra_list.append(var)
    else:      
        extra_list.append(var)
new_list.append(extra_list)
new_list.pop(0)
# Now we will use this new_list in DataFrame

df = pd.DataFrame(new_list, columns=['FormPublish', 'DatePublish', 'FormCell', 'Cell', 'FormCellName', 'FormCellName', 'FormJam', 'Jam', 'FormTarget', 'Target'])
df

Output

    FormPublish DatePublish FormCell    Cell    FormCellName    FormCellName    FormJam Jam FormTarget  Target
   0    form-0-publish  05/28/2019  form-0-cell 81  form-0-cell_name    13a form-0-jam  07.00-08.00 form-0-target   60
   1    form-1-publish  05/28/2019  form-1-cell 81  form-1-cell_name    13a form-1-jam  07.00-08.00 form-1-target   60
   2    form-2-publish  05/28/2019  form-2-cell 81  form-2-cell_name    13a form-2-jam  07.00-08.00 form-2-target   60

I hope it may help you.

How to convert key and value of dictionary to a dataframe column?

1 Answers1