r - I cannot subset my data frame using column values -
i want subset data frame based on specific values of a column. code :
data <- read.csv("file.csv") data1 <- data[ ,week_no < 2] write.csv(data1, "joda.csv",row.names=false)
but r gives me error :
error in `[.data.frame`(data, , week_no < 2) : object 'week_no' not found
the column exists,but don't know why receive error. thankful if can help.
there 3 errors in code, follows
use mtcars dataset example; subset dataset condition disp < 200
data(mtcars)
first index position wrong c8h10n4o2 noted in comments). when subsetting column wanting select rows match constraint. adding constraint in row position data[row, col]
mtcars[mtcars$disp < 200, ]
you need tell r disp
is. will give error there no object called disp
in global environment. seems presistent mistake making.
mtcars[disp < 200, ]
error in
[.data.frame
(mtcars, disp < 200, ) : object 'disp' not found
so need pass dataframe name in constraint mtcars$disp < 200
as user227710 noted in comment, r case-sensitive, if incorrectly spelled variable passed, not found no rows returned
mtcars[mtcars$disp < 200, ]
you misspelled column name. guess should week_no
, capital 'w' , capital 'o' instead of zero.
if error remains, check out names(data)
see correct spelling.
Comments
Post a Comment