Set Column Names In Pandas Data Frame From_dict With Orient = 'index'

I looked already at this question: pandas create named columns in dataframe from dict. However, my example is slightly different. I have a dictionary: my_dict = {'key1' : [1,2,3],

Solution 1:

Is there a reason you can't set the column names on the next line?

my_dict = {'key1' : [1,2,3], 'key2' : [4,5,6], 'key3' :[7,8,9]}
df = pd.DataFrame.from_dict(my_dict, orient='index')
df.columns = ['one', 'two', 'three']

Should work.

Solution 2:

From version 0.23.0, you can specify a columns parameter in from_dict:

my_dict = {'key1': [1, 2, 3], 'key2': [4, 5, 6], 'key3': [7, 8, 9]}
df = pd.DataFrame.from_dict(my_dict, orient='index', columns=['one', 'two', 'three'])

Solution 3:

my_dict = {'key1' : [1,2,3], 'key2' : [4,5,6], 'key3' :[7,8,9]}
df = pd.DataFrame.from_dict(my_dict, orient='columns')
df.columns = ['one', 'two', 'three']

Changed orient from index to columns. This worked for me.