convert json perline to panads data frame
Sometimes we have a file that contains a json object per line. For example log file in json format
{foo: 1, bar: 2}
{foo: 3, bar: 4}
if we want to read this in python pandas we need to convert it to
[
{foo: 1, bar: 2},
{foo: 3, bar: 4}
]
easy way to do this is with
jq --slurp
$ cat file.json | jq --slurp . > one_array.json
then you can read it in python pandas (notebook) like this
sf = pd.read_json('one_array.json')
Last modified 1yr ago