csvs-to-sqlite
csvs-to-sqlite copied to clipboard
simonw
Convert CSV files into a SQLite database
I can see the "!csvs-to-sqlite /content/sample_data aldb.sqlite3" command works fine in google colab but ends up with extra leading "./" in database table name. I wish to know if there...
It would be great if `csvs-to-sqlite` could quite happily churn through a multiple GB CSV file without using up all available RAM on a machine. https://plot.ly/python/big-data-analytics-with-pandas-and-sqlite/ has some good patterns...
Hi Simon, Is there currently a way to specify a column(s) to be unique and prevent duplicate data? If I have a csv file, I could parse it with awk...
I use it inside a Docker container (datasette) but seems that tab separated files (tsv) are not properly processed. All columns are reduced to one. ``` csvs-to-sqlite my-file.tsv my-file.db -s...
My [sqlite-utils](https://github.com/simonw/sqlite-utils) library has evolved to the point where I think it would make a good foundation for the next version of `csvs-to-sqlite`. The main feature I'm excited about here...
Hello, Assume I have a sqlite3 database with a table `foo`, and a file named `foo.csv` which I'd like to import. The behavior is to add these data into the...
This command line flag skips the creation of a table if it already exists
https://data.sfgov.org/Economy-and-Community/Mobile-Food-Facility-Permit/rqzj-sfat Say for example there's a `FoodItems` column in the CSV that has data in it like this: `Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs:...
Suppose I have to following table named `Test` in a SQLite database: | Id | Text | | --- | --- | | 1 | | | 2 | |...
Consider this for example: https://san-francisco.datasettes.com/registered-business-locations-3d50679/Registered_Business_Locations_-_San_Francisco "NAICS Code" and " NAICS Code Description" are two columns that always reflect each other.