3 ms·
I wrote a script to find all csv files in a directory and figure out the best way to load them into SQLite. It gives me a handy way to run queries on data. I
by mrfusion 5y ago
I wrote a script to find all csv files in a directory and figure out the best way to load them into SQLite.
It gives me a handy way to run queries on data.
I tried to make it super smart too and really make educated guesses on what data types to use and even linking foreign keys.
- lenkite 5y agoA language like R (https://www.r-project.org/ https://www.r-project.org/) helps more for CSV data-science. https://www.tutorialspoint.com/r/r_csv_files.htm https://www.tutorialspoint.com/r/r_csv_files.htm
- eigenvalue 5y agoYou can use Python with Pandas as an easy and powerful way to import from CSV files and then directly write or append the tables to an sqlite db. The whole thing can be done in just a couple lines of code.