Re:An introduction to Kerf
by scottlocklin on Wednesday December 16, 2015 @07:33PM
(#10748603)
There are lots of "table" like solutions out there: R's data.frame and data.table are obvious examples.
Speed, the ability to persist data as an actual database system, and the ability to work with data "out of core" would be the advantages over Pandas. I'll be releasing various performance comparisons over coming weeks to demonstrate these advantages.
Re:An introduction to Kerf
by yummyfajitas on Wednesday December 16, 2015 @07:40PM
(#10748632)
Cool, any chance you'll write a blog post discussing that? Being a good column oriented DB combined with a decent vectorized language is definitely not something so easy to find - blaze purports to be that system (sort of), but it isn't really living up to the hype.
Re:An introduction to Kerf
by scottlocklin on Wednesday December 16, 2015 @07:52PM
(#10748682)
Of course we'll blog on this topic! Just not today.
That's what the APL world brings to the table.
FWIIW, you can read about my comparing Jd (another APL related columnar database) to a Blaze like tool (Spark bigDF) on the J list:
http://jsoftware.com/pipermail/database/2015-May/000076.html
Let me emphasize that while I'm about to implement most of his blog post in numpy/pandas, I don't mean to come off as critical or dismiss building a new one. Kerf looks pretty cool. I just don't think this post gives much reason to believe there is nothing comparable to it.
Idiomatic numpy:
Less idiomatic, but analogous to kerf or J: arange(1,6) is equivalent to his range(5), and full((5,), 1) is equivalent to repeat(5,1).The SQL-ish engine looks fairly similar to pandas:
Pandas similarly has joins, averages and other aggregates, etc. E.g.: is equivalent to: Syntactically it's a bit different (embedded SQL is pretty cool) but from this blog post I don't see any major semantic differences.However, if there are important differences under the hood, I'd love to hear about them. Again, I'm really not trying to criticize Locklin for rolling his own, I'm just disputing a minor point.