How split json file in dataframe python

Question

I have a .txt file, named 'data.txt' which is a list of dictionaries, i.e., something like,

{"958464": ["item1", "item3"], "917654": [], "1347584": ["item2", "item5", "item6", "item7"], "914082": [], "946178": ["item1", "item4", "item15"], ...}

How can form a dataframe, with the above file?

My idea is cross information (about ID) with another database, so I think form dataframe like,

      ID            ITEMS
0    958464    "item1", "item3"
1    917654
2    1347584   "item2", "item5", "item6", "item7"
3    914082
4    946178    "item1", "item3", "item5"
...

Or maybe, create a dataframe like

      ID        Item1   item2   item3   ...
0    958464       1      0        1
1    917654       0      0        0
2    1347584      0      1        0   
3    914082       0      0        0
4    946178       1      0        1
...

I tried

data = pd.read_csv('data1.txt')
pd.DataFrame(data.items())

Possible duplicate of Parse JSON in Python

GalAbra
– GalAbra

2019-06-20 06:56:20 +00:00
Commented Jun 20, 2019 at 6:56 — GalAbra
– GalAbra, Commented Jun 20, 2019 at 6:56

Vikas Periyadath · Accepted Answer · 2019-06-20 07:06:13Z

1

Try this :

k = {"958464": ["item1", "item3"], "917654": [],
 "1347584": ["item2", "item5", "item6", "item7"], "914082": [], "946178": ["item1", "item4", "item15"]}

import pandas

df1=pandas.DataFrame.from_dict(k,orient='index')
print(df1)

O/P :

             0      1       2      3
958464   item1  item3    None   None
917654    None   None    None   None
1347584  item2  item5   item6  item7
914082    None   None    None   None
946178   item1  item4  item15   None

answered Jun 20, 2019 at 7:06

Vikas Periyadath

3,1961 gold badge25 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

How split json file in dataframe python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related