Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Compatibility with pandas 0.23.3 #15

Open
jgrady-omico opened this issue Nov 14, 2018 · 0 comments
Open

Compatibility with pandas 0.23.3 #15

jgrady-omico opened this issue Nov 14, 2018 · 0 comments

Comments

@jgrady-omico
Copy link

I'm using pandas 0.23.3 and pysqldf is not compatible - the flavor argument for to_sql has been removed, so the call fails.

I've edited the code in _write_table of pysqldf/sqldf.py to read
to_sql(df, name=tablename, con=self.conn, dtype=dtype)
instead of
to_sql(df, name=tablename, con=self.conn, flavor="sqlite", dtype=dtype)
which corrects the problem for this version of pandas. I guess a try/except would fix it generically?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant