data.table - How to assign column names with fread in R? -

-

i have following code - 

zz3 <- 'data,key "va1,va2,20140524,,0,0,5969,20140523134902,s7,s1147,140,20140523134902,m/t",4503632376496128 "va2,va3,20140711,,0,0,8824,20140601095714,s1,s6402,175,20140601095839,m/t",4503643113914368 "va1,va3,20140710,,0,0,11678,20140604085203,s1,s1430,250,20140604085329,m/t",4503666467799040 "va2,va1,20140724,,0,0,7109,20140523133835,s7,s793,130,20140523133835,m/t",4503679218483200 "va3,va1,20140925,,0,0,10592,20140604092548,s7,s109,395,20140604092714,m/t",4503694653521920'  columnclasses <- c("or"="factor", "d"="factor", "ddate"="factor", "rdate"="factor", "changes"="integer", "class"="factor", "price"="integer", "fdate"="factor", "company"="factor", "number"="factor", "dur"="integer", "added"="factor", "source"="factor", "key"="null") # skip last column "key" data <- fread(zz3, header = false, sep = ",", skip = 1, na.strings = c(""), colclasses = columnclasses)

but returns error - 

error in fread(zz3, header = false, sep = ",", skip = 1, na.strings = c(""),  :    column name 'or' in colclasses[[1]] not found

i expected colclasses assigns column names, when header = false, looks not case.

how should fix that? similar read.csv code worked well.

it indeed not case.

colclasses enables define column types using fread. suppose have file splitted | column named 'key' , want character, run command: fread(filepath, sep='|', colclasses=c(key='character')).

if have no names in file can use setnames assign column names data.table once read.


Comments

Post a Comment

Popular posts from this blog

How can we post XML strings along with text strings in iOS -

-
nsstring *starcardstr=@"https://starcardsindia.com/test/api/userauthentication"; //nsstring *poststr=[nsstring stringwithformat:@"https://starcardsindia.com/api/otpverification"]; // nsurl *url=[nsurl urlwithstring:poststr]; nsurl *url=[nsurl urlwithstring:starcardstr]; nsmutableurlrequest *request=[[nsmutableurlrequest alloc]init]; [request seturl:[nsurl urlwithstring:starcardstr]]; [request sethttpmethod:@"post"]; nsstring *contenttype = [nsstring stringwithformat:@"text/xml"]; [request addvalue:contenttype forhttpheaderfield: @"content-type"]; nsmutabledata *pbody=[nsmutabledata data]; [pbody appenddata:[[nsstring stringwithformat:@"<xml>"] datausingencoding:nsutf8stringencoding]]; // create post [pbody appenddata: [[nsstring stringwithformat: @"<?xml version=\"1.0\" encoding=\"utf-8\" ?>"] datausingencoding: nsutf8stringencoding]]; //[pbody appenddata:[...
Read more

How to run C# code using mono without Xamarin in Android? -

-
i want create program uses mono runtime run c# code (binary not application). i copied libmono.so unity app , i'm write code using documentation: http://www.mono-project.com/docs/advanced/embedding/ and it's working have problems references can access classes mscorlib.dll , have problems system.reflection.assembly class throwing exception, when print console see: system.missingmethodexception: method not found: 'system.reflection.assembly.op_inequality' can fix it? can use mono runtime in c binary on android? ps. i'm using android tests. edit: found solution loading libraries, need set environment variable mono_path libraries path. but have still problems assembly class. the system.missingmethodexception error have seems .net profile mismatch error, 1 explained here . can use mono runtime in c binary on android? yes, using ndk guess. there alternatives can use instead of rolling own, such xmadevlab .
Read more

c# - cefsharp app remember password option -

-
i embedding webapp using cefsharp working fine. however, when logging app, cef doesn't offer remember username , password when opening app in normal chrome. is there way in cefsharp cef ask remember usernames/password when uses go app, able sign in quicker ? i have tried using command line args e.g. cefsettings cs = new cefsettings(); cs.cefcommandlineargs.add("enable-automatic-password-saving", "enable-automatic-password-saving"); cs.cefcommandlineargs.add("enable-password-save-in-page-navigation", "enable-password-save-in-page-navigation"); cef.initialize(cs); but far, cef has not prompted me save username/password. cefsharp doesn't support remember password prompt. don't believe cef either, though it's worth asking on http://magpcss.org/ceforum/ definitive answer (there's no reference in api current version). i'll point of unless explicitly told cef use in memory cookie store, session cookies ...
Read more