Hi everyone
I am new here and I am seeking for some help on python
I using Jupyter to practice
and I just got the following error while executing my code
TypeError: coerce_kw_type() got an unexpected keyword argument 'dest'
have look up this error on the net but can't get anything.
Here is my :
import sqlite3
import pandas as pd
from sqlalchemy import create_engine
file = 'un.xlsx'
output = 'output.xlsx'
engine = create_engine('sqlite://', echo=False)
df = pd.read_excel(file, sheet_name='Goma-Bukavu UN Agencies-NGO')
df.to_sql('contacts', engine, if_exists='replace', index=False)
results = engine.execute('select * from contacts')
final=pd.DataFrame(results, columns=df.columns)
final.to_excel(output, index=False)
final
I am new here and I am seeking for some help on python
I using Jupyter to practice
and I just got the following error while executing my code
TypeError: coerce_kw_type() got an unexpected keyword argument 'dest'
have look up this error on the net but can't get anything.
Here is my :
import sqlite3
import pandas as pd
from sqlalchemy import create_engine
file = 'un.xlsx'
output = 'output.xlsx'
engine = create_engine('sqlite://', echo=False)
df = pd.read_excel(file, sheet_name='Goma-Bukavu UN Agencies-NGO')
df.to_sql('contacts', engine, if_exists='replace', index=False)
results = engine.execute('select * from contacts')
final=pd.DataFrame(results, columns=df.columns)
final.to_excel(output, index=False)
final