Could not load bigmac.csv: read_csv() got an unexpected keyword argument 'error_bad_lines'

[quoidautre]

Hi,

I'm just trying to convert the bigmac databse (csv) in sqlite. There's an issue (maybe not the same problem) here.
Following the tutorial, the command : csvs-to-sqlite bigmac.csv bigmac.db return an error (due of pandas, it's seems) :

$ csvs-to-sqlite bigmac.csv bigmac.db
Could not load bigmac.csv: read_csv() got an unexpected keyword argument 'error_bad_lines'
Loaded 0 dataframes
Added 1 CSV file to bigmac.db

I'm on :

• Ubuntu 18.04.6 LTS
• Python 3.9.6
• pandas==2.0.3
• csvs-to-sqlite, version 1.3
• datasette==0.64.3

HAve toy an idea please ?

Thanks a lot
F.

[koaning]

Looking at the issue, it seems you'd have to roll back pandas? It's an issue with the csvs-to-sqlite library though which isn't something that I control.

It even seems like there is a PR that might fix this, once Simon merges it ... it may improve things. The PR has been open for a while though. I might feel free to ping him on social media about it, but do remain calm and kind ... I can imagine that Simon is rather busy.