I'm a beginner in Python and pandas. I've been attempting to convert a pandas dataframe into JSON with the following format:
{column1 name : [Values], column2 name: [values], Column3 name... }
I have tried using this code:
df.to_json(orient='columns')
However, it gives me the following output:
{"Col1 name":{"row key1": value1, "row key2": value2}, "Col2 name":{"row key1": value1, "row key2": value2}}
If someone could provide assistance or suggest an alternative method for converting the dataframe without including the row keys, I would greatly appreciate it.
For reference, my dataframe looks like this:
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
The desired resulting format is:
{'date':['2010-01-16', '2010-01-16'], 'batch': ['00154354A0', '00164354A2'], 'result':[1100.0, 1070.0], 'LSL':...}
Thank you very much in advance.