How to display json without column names pandas/python?

Question

We query a df by below code:

json.loads(df.reset_index(drop=True).to_json(orient='table'))

The output is:

{"index": [ 0, 1 ,2, 3, 4],
 "col1": [ "250"],
 "col2": [ "1"],
 "col3": [ "223"],
 "col4": [ "2020-06-12 14:55"]
}

We need the output should be like this:

[ "250", "1", "223", "2020-06-12 14:55"],[.....][.....]

You can use zip. What would be the values in [.....][.....]? Please add minimal reproducible example — Ch3steR
– Ch3steR, Commented Jul 6, 2020 at 4:51

Elsa · Accepted Answer · 2020-07-06 06:09:24Z

2

json.loads(df.reset_index(drop=True).to_json(orient='values'))

change table into values solved my problem.

answered Jul 6, 2020 at 6:09

Elsa

6261 gold badge11 silver badges30 bronze badges

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

Comments

DYZ · Accepted Answer · 2020-07-06 04:52:51Z

0

What you call a "json" (there is no such data type) is a Python dictionary. Extract the values for the keys of interest using list comprehension:

x = .... # Your dictionary
[x[col][0] for col in x if col.startswith("col")]
#['250', '1', '223', '2020-06-12 14:55']

answered Jul 6, 2020 at 4:52

DYZ

57.3k10 gold badges73 silver badges101 bronze badges

json.loads(df.reset_index(drop=True).to_json(orient='values')) change table into values solved my problem.

Jeel Gondaliya · Accepted Answer · 2020-07-06 04:58:42Z

0

We convert json to dataframe and we remove column name.

pd.Dataframe(json_source,header='False')

Then we convert it to json formate

df.to_json(orient='table')

answered Jul 6, 2020 at 4:58

Jeel Gondaliya

1479 bronze badges

json.loads(df.reset_index(drop=True).to_json(orient='values')) change table into values solved my problem.