Pandas dataframe to json with format {column1 name : [Values], column2 name: [values], Column3 name... }

Question

I'm new in python and pandas. I'm trying to convert a pandas dataframe to a json with format:

{column1 name : [Values], column2 name: [values], Column3 name... }

I've trying using:

df.to_json(orient='columns')

with this option I get something line

{"Col1 name":{"row key1": value1, "row key2": value2}, "Col2 name":{"row key1": value1, "row key2": value2}}

I'll be very grateful if someone can help me or give an idea on how to convert the dataframe and obtain the format without the rows keys.

As reference my dataframe looks like:

      date       batch          result            LSL            USL    target
0    2010-01-16  00154354A0     1100.0           680.0          1210.0  1100.0
1    2010-01-16  00164354A2     1070.0           680.0          1210.0  1100.0

And what I want to achieve is:

{'date':['2010-01-16', '2010-01-16'], 'batch': ['00154354A0', '00164354A2'], 'result':[1100.0, 1070.0], 'LSL':...}

Many thanks in advance

Mayank Porwal · Accepted Answer · 2021-01-20 17:24:18Z

1

Try this:

In [1773]: df.to_dict(orient='list')
Out[1773]: 
{'date': ['2010-01-16', '2010-01-16'],
 'batch': ['00154354A0', '00164354A2'],
 'result': [1100.0, 1070.0],
 'LSL': [680.0, 680.0],
 'USL': [1210.0, 1210.0],
 'target': [1100.0, 1100.0]}

answered Jan 20, 2021 at 17:24

Mayank Porwal

34.2k9 gold badges45 silver badges65 bronze badges

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

1 Comment

Leonel Garcia Over a year ago

Many thanks!!!!, definitely I need to study and practice more.

Collectives™ on Stack Overflow

Pandas dataframe to json with format {column1 name : [Values], column2 name: [values], Column3 name... }

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related