blaze / blaze/odo

[Question] Migrating pandas dataframe from local computer

Open
#453 4 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.