pandas to json
>>> df.to_json(orient='records')
'[{"col 1":"a","col 2":"b"},{"col 1":"c","col 2":"d"}]'pandas to json
>>> df.to_json(orient='records')
'[{"col 1":"a","col 2":"b"},{"col 1":"c","col 2":"d"}]'python how to create a pandas dataframe from a dictionary
# Basic syntax:
import pandas as pd
pandas_dataframe = pd.DataFrame(dictionary)
# Note, with this command, the keys become the column names
# Create dictionary:
import pandas as pd
student_data = {'name' : ['Jack', 'Riti', 'Aadi'], # Define dictionary
'age' : [34, 30, 16],
'city' : ['Sydney', 'Delhi', 'New york']}
# Example usage 1:
pandas_dataframe = pd.DataFrame(student_data)
print(pandas_dataframe)
name age city # Dictionary keys become column names
0 Jack 34 Sydney
1 Riti 30 Delhi
2 Aadi 16 New york
# Example usage 2:
# Only select listed dictionary keys to dataframe columns:
pandas_dataframe = pd.DataFrame(student_data, columns=['name', 'city'])
print(pandas_dataframe)
name city
0 Jack Sydney
1 Riti Delhi
2 Aadi New york
# Example usage 3:
# Make pandas dataframe with keys as rownames:
pandas_dataframe = pd.DataFrame.from_dict(student_data, orient='index')
print(pandas_dataframe)
0 1 2
name Jack Riti Aadi # Keys become rownames
age 34 30 16
city Sydney Delhi New yorkCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
