Pandas value error when converting JSON into an excel

Question

JSON File:-

 {"customer_name":"james",
   "customer_id":41
 }

my Python code below gives the error message :-

  " ValueError: If using all scalar values, you must pass an index "

Please let me know what is the issue in the below code.

import pandas
pandas.read_json("p1.json").to_excel("out-put.xlsx")

cors · Accepted Answer · 2019-01-05 21:59:12Z

2

You can try:

pandas.read_json("p1.json", typ = 'series')

It creates pd.Series

answered Jan 5, 2019 at 21:47

cors

5374 silver badges11 bronze badges

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

2 Comments

TypeError: read_json() got an unexpected keyword argument 'type'

Sorry, it is typ