How can I remove NULL values from a dataframe in R? -

-

i made function in r accepts string , outputs patterns in it. example, string, "abcabcabc", outputs "abc" if have string as, "abcdefghi", outputs, " ". now, on running function on dataframe containing 1000's of rows, obtained output, output dataframeconsists of several rows having " " output. how can remove this? output dataframe of following type:

1 2 abc 2 3 bc 3 4 t 4 5 " " 5 3 ui

so, want remove row containing values in first 2 columns 4 , 5. thanks!

an empty string not null (try is.null(" ")). you're seeing factor level " " (nothing between quotes). can remove rows of data.frame searching string.

xy[!xy$col %in% " ", ] # added ! select inverse, advertized

or if appropriate, can merge other factor level redefining levels(xy).

here's example

set.seed(357) xy <- data.frame(first = c("a", "a", "b", "b", "b", " ", " ", " ", "d", "d"),                   second = runif(10))  xy[!xy$first %in% " ", ] # can select multiple values (see below) xy[!xy$first == " ", ] # alternative, can select 1 value  # bonus xy[!xy$first %in% c("a", " "), ]

Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

how does one get csharp-sqlite to throw exceptions for duplicates or foreign key constraint violations -

-
i making use of csharp-sqlite. in sqlite database have uniqueness , foreign key constraints. when write "duplicate" table exception not raised , way found check exception use following: var error = sqlitecommand.getlasterror(); i hoping able following: var sqlstring = "some insert sql"; var command = sqlitecommand(sqlstring); command.parameters.add(... parameter...); using (var sqlconnection = new sqliteconnection(connectionstring)) { try { command.executenonquery(); } catch (exception ex) { exception } { sqlconnection.close(); } } the "catch" block never hit, though var error = sqlitecommand.getlasterror(); does return description of error expecting. have idea how solve this, or standard practice using csharp-sqlite library?
Read more

Simple Angular 2 project fails 'Unexpected reserved word' -

-
i trying create simple angular2 project based on ng2do project. using quickstart , have following code... <script src="js/quickstart/dist/es6-shim.js"></script> .... import {component, template, bootstrap, foreach} 'js/quickstart/angular2/angular2'; this gives me following error... uncaught syntaxerror: unexpected reserved word what missing? don't know if helps have been having issues day realised because starting code script reference <script src="app.js"> </script> instead of using <script> system.import('app'); </script> hope helps using in tsconfig { "version": "1.5.0-beta", "compileroptions": { "target": "es6", "module": "amd", "declaration": false, "noimplicitany": false, "removecomments": true, "nolib": fal...
Read more