how to parse non key value json file in python

Question

I have a json file which has data like :

"data": [[1467398683, "GB", "204.0.20", "tracks", "content-based", "b47911d0e80d1a8a959a2b726654bbfa", "Dance & Electronic", 1466640000, 413933, 413933,

I am trying to parse this non key value json file into a dataframe in python, can someone suggest how this can be achieved ?

...because what you've posted, by itself, isn't valid JSON. Typically, the answer to "how do I parse a JSON file with Python" is "use the json module". If you've tried that and it didn't work, it would also help if you updated your question to show the code you've tried and explain how it failed. — larsks
– larsks, Commented Aug 23, 2019 at 13:43

Stanislav Zholobetskyi · Accepted Answer · 2019-08-23 14:01:50Z

1

You have two way:

Pandas read_json method have parameter (orient = 'values')
```
df = pd.read_json(path, orient='values')
```

Or if you need you data like a matrix you can do this

df = pd.DataFrame(json.load('{"data": [[1467398683,..your data...}')['data'])

Please see also this thread (Parsing json values in pandas read_json)

answered Aug 23, 2019 at 14:01

Stanislav Zholobetskyi

815 bronze badges

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

Collectives™ on Stack Overflow

how to parse non key value json file in 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