search

simonw / csvs-to-sqlite

Convert CSV files into a SQLite database
Apache License 2.0
879 stars 69 forks source link

Replace deprecated argument `error_bad_lines` and method `iteritems()` for pandas #92

Open LuighiV opened 1 year ago

LuighiV commented 1 year ago

With new pandas version 2.0.0, the argument and method were removed, retrieving an error.

Reference: https://pandas.pydata.org/docs/whatsnew/v2.0.0.html#removal-of-prior-version-deprecations-changes

closes https://github.com/simonw/csvs-to-sqlite/issues/88 closes https://github.com/simonw/csvs-to-sqlite/issues/93

fgregg commented 1 year ago

@simonw it would be great to get this pulled in.

taniki commented 1 year ago

If you need to work with csvs-to-sqlite before this PR gets merged

pip install --force-reinstall "pandas~=1.0"
chrismp commented 1 year ago

@simonw Anything more you need before merging this request?

chrismp commented 1 year ago

@LuighiV You should try a pull request with the csvs-update-sqlite repo: https://github.com/dkaoster/csvs-update-sqlite. It is updated more often. Selfishly, I would like to see your pull request incorporated in that repo because I've switched to using csvs-update-sqlite!

simonw commented 8 months ago

OK, let's fix this!