To demonstrate saving as JSON, we will first save the Excel data we just read into a JSON file and examine the contents:
JSON-based data can be read with the pd.read_json() function:
Note the two slight differences here, caused by the reading/writing of data from JSON. First, the columns have been reordered alphabetically. ...