[Question] Migrating pandas dataframe from local computer
Open
- Dominant language
- Python
- Stars
- 1k
- Forks
- 131
- PR merge metrics
- No merged PRs in 30d
Description
I am not sure how to load a pandas dataframe into a table.
```
meta = MetaData(bind=engine)
table = Table('testaccounts', meta, schema='custom')
odo(df, table)
```
I tried the code above but it throws this error
> ValueError: Column names of incoming data don't match column names of existing SQL table
> Names in SQL table: []
> Names from incoming data: ['id', 'name', 'country']
I also tested this by manually creating the table with these 3 columns but it still shows the same error. I think i'm doing something wrong but not sure what. Can someone point me in the right direction?
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.