python convert json to pandas dataframe
# Basic syntax: dataframe = pd.DataFrame.from_dict(json_data, orient="index") # Example usage: import json import pandas as pd # Make json-formatted string: json_string = '{ "name":"John", "age":30, "car":"None" }' your_json = json.loads(json_string) print(your_json) --> {'name': 'John', 'age': 30, 'car': 'None'} # Convert to pandas dataframe: dataframe = pd.DataFrame.from_dict(your_json, orient="index") print(dataframe) 0 name John age 30 car None # Note, orient="index" sets the keys as rownames. orient="columns" is # the default and is supposed to set the keys as column names, but I # couldn't seem to get it to work with this example