Search code examples
pythonpandascsvdictionaryexport-to-csv

pandas to csv TypeError: get_handle() got an unexpected keyword argument 'errors'


I had big table which I sliced to many smaller tables based on their dates:


dfs={}
for fecha in fechas:
    dfs[fecha]=df[df['date']==fecha].set_index('Hour')
#now I can acess the tables like this:
dfs['2019-06-23'].head()

I have done some modifictions to the dfs['2019-06-23'] specific table and now I would like to save it on my computer. I have tried to do this in two ways:

#first try:
dfs['2019-06-23'].to_csv('specific/path/file.csv')

#second try:
test=dfs['2019-06-23']
test.to_csv('test.csv')

both of them raised this error:

TypeError: get_handle() got an unexpected keyword argument 'errors'

I don't know why I get this error and haven't find any reason for that. I have saved many files this way but never had that before.

My goal: to be able to save this dataframe after my modification as csv


Solution

  • In the end what worked was to use pd.DataFrame and then to export it as following:

    to_export=pd.DataFrame(dfs['2019-06-23'])
    
    to_export.to_csv('my_table.csv')
    

    that suprised me because when I checked the type of the table when I got the error it was dataframe . However, this way it works.