r - Fill option for fread -
let's have txt file:
"aa",3,3,3,3 "cc","ad",2,2,2,2,2 "zz",2 "aa",3,3,3,3 "cc","ad",2,2,2,2,2 with read.csv can:
> read.csv("linktofile.txt", fill=t, header=f) v1 v2 v3 v4 v5 v6 v7 1 aa 3 3 3 3 na na 2 cc ad 2 2 2 2 2 3 zz 2 na na na na na 4 aa 3 3 3 3 na na 5 cc ad 2 2 2 2 2 however fread gives
> library(data.table) > fread("linktofile.txt") v1 v2 v3 v4 v5 v6 v7 1: cc ad 2 2 2 2 2 can same result fread?
not currently; wasn't aware of read.csv's fill feature. on plan add ability read dual-delimited files (sep2 sep mentioned in ?fread). variable length vectors read list column each cell vector. but, not padding na.
could add the list please? way you'll notified when status changes.
are there many irregular data formats out there? recall ever seeing regular files, incomplete lines considered error.
update : unlikely done. fread optimized regular delimited files (where each row has same number of columns). however, irregular files read list columns (each cell vector) when sep2 implemented; not filled in separate columns read.csv can do.
Comments
Post a Comment