Answers for "make datframe key a column"

22

pandas dataframe from dict

data = {'col_1': [3, 2, 1, 0], 'col_2': ['a', 'b', 'c', 'd']}
pd.DataFrame.from_dict(data)
Posted by: Guest on March-30-2020
3

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 york
Posted by: Guest on October-03-2020
0

create a dataframe from dict

create a dataframe from dict (function)

import pandas as pd
def create_df():
    data = {'col_1': [3, 2, 1, 0], 'col_2': ['a', 'b', 'c', 'd']}
    return pd.DataFrame.from_dict(data)
create_df()
Posted by: Guest on December-08-2020

Code answers related to "make datframe key a column"

Python Answers by Framework

Browse Popular Code Answers by Language