Deleting values in a vector

[Eddie1]

Hi, I am new to R and in need of some assistance.

I would like to delete some values from a vector but struggling to do this.

I have tried boolean operators, filter() and a few other combinations from things I've read online but nothing has worked so far.

Any help appreciated

I want to delete the 7, 8, and 9 and all their observations from my data set.

[bustosmiguel]

#If I want to remove 123456789:

df <- data.frame(first = c(1, 1, 1,1, 1, 1),
second = c(1,1,1,1,1,1),
thirth = c(1,1,123456789,123456789, 1, 1),
fourth = c(1,1,1,1,1, 123456789))
df
df$thirth[(3:4)] <- 0
df$fourth[6] <- 0
df

[technocrat]

Without a reprex (see the FAQ: How to do a minimal reproducible example reprex for beginners), it's difficult to infer the structure of the w2q7.1 object, so I have to use synthetic data.

set.seed(42)
v1 <- sample(1:100,10)
v2 <- sample(LETTERS,10)
d <- data.frame(v1 = v1, v2 = v2)
d
#>     v1 v2
#> 1   49  E
#> 2   65  N
#> 3   25  T
#> 4   74  R
#> 5   18  O
#> 6  100  C
#> 7   47  I
#> 8   24  D
#> 9   71  Z
#> 10  89  M
# subset data frame d to include only those rows whose first
# column does not include the values 49, 25 or 18
d[which(!d$v1 %in% c(49,25,18)),]
#>     v1 v2
#> 2   65  N
#> 4   74  R
#> 6  100  C
#> 7   47  I
#> 8   24  D
#> 9   71  Z
#> 10  89  M

[Eddie1]

@technocrat

d[which(!d$v1 %in% c(49,25,18)),]

Thanks for replying. When I get to the datapasta section of the reprex it says this:

[Eddie1]

Is this helpful in place of the reprex?

Reading back, not sure i have been 100% clear.

So basically I want to delete the columns 'Mssing', 'Do not understand the question, 'Cant choose', and 'Decline to answer' and all the responses to those options.

[technocrat]

Working with the table object makes things much more difficult than they need be. What does the WAVE_4_SPSS object look like?

[Eddie1]

Why does table make things more difficult?

I just went through the data in SPSS and manually deleted all the value so no longer an issue

[wakibia]

I would like you to provide a reprex of your problem. It will b easier to help.