2 ms·
A bit overkill since it could do so much more than just filtering nulls, but here is a KDB/Q oneliner: `:20150425.csv 0: csv 0: (`Name; `$"Credit Card") xcol s
by ah- 11y ago
A bit overkill since it could do so much more than just filtering nulls, but here is a KDB/Q oneliner:
`:20150425.csv 0: csv 0: (`Name; `$"Credit Card") xcol select name,creditcard from (.j.k raze read0`:data.json) where 0n<>first each creditcard