Convert pandas DataFrame to list of JSON-strings

Question

I need to know how to implement to_json_string_list() function in that case:

df = pandas.read_json('[{"rec1" : "val1", "rec2" : "val4"}, {"rec1" : "val3", "rec2" : "val4"}]', orient='records')
json_strings = list()
json_strings = to_json_string_list(df)
for json_string in json_strings:
    print(json_string)

to get output like:

{"rec1" : "val1", "rec2" : "val4"}
{"rec1" : "val3", "rec2" : "val4"}

I know that there are function to_json(orient='records'), but it is not that I need, because I get:

[{"rec1" : "val1", "rec2" : "val4"},
{"rec1" : "val3", "rec2" : "val4"}]

Printing is not only thing I will do with this strings, so simple substitution of [], is not what I need, too.

jezrael · Accepted Answer · 2018-02-02 13:21:58Z

17

I think you need to_json with parameter lines=True:

print (df.to_json(orient='records', lines=True))
{"rec1":"val1","rec2":"val4"}
{"rec1":"val3","rec2":"val4"}

df.to_json('file.json',orient='records', lines=True)

answered Feb 2, 2018 at 13:21

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

2 Comments

Prime Ape Over a year ago

Thanks for the answer, with this lines next thing I need is to split() this string by linefeed to get list?

jezrael Over a year ago

I think yes, a = df.to_json(orient='records', lines=True) print (a.split('\n')) should work.

kluu · Accepted Answer · 2021-02-12 22:10:28Z

1

Another option using a comprehension list:

[dict(v) for _, v in df.iterrows()]

answered Feb 12, 2021 at 22:10

kluu

2,9954 gold badges18 silver badges39 bronze badges

Comments

Lionell Loh Jian An · Accepted Answer · 2021-01-24 13:49:01Z

0

There is another method which gives you the reverse of pd.Daa

import json
json_lst = []
for i in (range(len(df)): 
    d = json.loads(df.iloc[i, :].to_json())
    json_lst.append(d)

answered Jan 24, 2021 at 13:49

Lionell Loh Jian An

1381 silver badge8 bronze badges

Collectives™ on Stack Overflow

Convert pandas DataFrame to list of JSON-strings

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related