[R] remove a row
Ashta
@ew@@hm @end|ng |rom gm@||@com
Fri Nov 29 00:16:39 CET 2019
Hi all, I want to remove a row based on a condition in one of the
variables from a data frame.
When we split this string it should be composed of 3-2- 5 format (3
digits numeric, 2 characters and 5 digits numeric). Like
area code -region-numeric. The max length of the area code should be
3, the max length of region be should be 2, followed by a max length
of 5 numeric digits. The are code can be 1 digit, or 2 digits or
3 digits but not more than three digits. So the max length of this
variable is 10. Anything outside of this pattern should be excluded.
As an example
dat <-read.table(text=" rown varx
1 9F209
2 FL250
3 2F250
4 102250
5 102FL
6 102
7 1212FL250
8 121FL50",header=TRUE,stringsAsFactors=F)
1 9F209 # keep
2 FL250 # remove, no area code
3 2F250 # keep
4 102250 # remove , no region code
5 102FL # remove , no numeric after region code
6 102 # remove , no region code and numeric
7 1212FL250 #remove, area code is more than three digits
8 121FL50 # Keep
The desired output should be
1 9F209
3 2F250
8 121FL50
How do I do this in an efficient way?
Thank you in advance
More information about the R-help
mailing list