3 ms·
What's the benefit (or tradeoff) of doing this over some variation of "command line data science" of the type outlined in Greg's post [1]? Would it theoretical
by vkb 13y ago
What's the benefit (or tradeoff) of doing this over some variation of "command line data science" of the type outlined in Greg's post [1]?
Would it theoretically be faster than the unix join/grep commands for small CSV files, the kind you get usually via email?
I love SQL and prefer it for data work of this type, but I'm not entirely sure of the benefit of this, since it looks like you're just reading it into SQL, which means having to format and normalize anyway?
[1]http://www.gregreda.com/2013/07/15/unix-commands-for-data-science/ http://www.gregreda.com/2013/07/15/unix-commands-for-data-sc...
- blueblob 13y agoI think the benefit is that a lot of people are proficient with SQL and are not very proficient with awk. I think whether it will be faster or not depends on how complex your query/queries are relative to the amount of data that you need to import.