10 ms·
I have met those people to, but none of those people have ever had a csv file to run queries on. Analysis has a lot of meanings. Getting basic facts (there are
by eof 5y ago
I have met those people to, but none of those people have ever had a csv file to run queries on.
Analysis has a lot of meanings. Getting basic facts (there are N rows that X) and selecting subsets of data are realistic analysis non technical people might do on csv files.
And I want to be clear that parsing a csv file with sqlite or MySQL is much more complex than learning “SELECT .. FROM .. WHERE” (with no joins!) when there is a tool like OPs that magically does the “parsing”.
- Closi 5y agoIn reality, a basic query might be something like "Show me how many units of product code 010201 were sold each month this year", which actually isn't that easy to write in SQL (but very easy to express in plain English).
- wswope 5y ago> And I want to be clear that parsing a csv file with sqlite or MySQL is much more complex than learning “SELECT .. FROM .. WHERE” (with no joins!) when there is a tool like OPs that magically does the “parsing”. Sqlite CSV import: .mode csv .import file.csv tablename