TypeError: from_dict () got unexpected keyword argument 'columns' in Python
I have a dictionary object of the view:
my_dict = {id1: val1, id2: val2, id3: val3, ...}
I want to create this in a DataFrame where I want to name 2 columns 'business_id
' and 'business_code
'.
I have tried:
business_df = DataFrame.from_dict(my_dict,orient='index',columns=['business_id','business_code'])
But it says it from_dict
doesn't take a column argument.
TypeError: from_dict () got unexpected keyword argument 'columns'
-
J1
Jose Luis Sep 15 2021
You can loop over the elements:
pd.DataFrame(list(my_dict.iteritems()), columns=['business_id','business_code'])
#Output
# business_id business_code 0 id2 val2 1 id3 val3 2 id1 val1
-
N0
Nguyen Quang Thai Sep 15 2021
To get the same functionality as the documentation and to avoid code workarounds, make sure you are using the most recent version of Pandas. I recently ran into the same error when running a line of code from the Pandas tutorial:
pd.DataFrame.from_dict(dict([('A', [1, 2, 3]), ('B', [4, 5, 6])]),orient='index', columns=['one', 'two', 'three'])
I checked the Pandas version and found that I have version 22 running when version 23 is available.
import pandas as pd pd.__version__ Out[600]: '0.22.0'
I updated with pip:
install --upgrade pandas
I confirmed that my version has been updated to 23 and the same
from_dict ()
code worked without error.No code changes are required.
* Type maximum 2000 characters.
* All comments have to wait approved before display.
* Please polite comment and respect questions and answers of others.