How to drop a Date column in R

Question

I have a date-time stamp column and i was able to convert the column to R date-time format, in a bid for me to split the column, i created 2 new columns with the date information in one and time information in the order. Now I have found a way to split the original Date...Timestamp column so i want to drop the 2 new columns but I'm getting this error.

I tried this code:

newpHdata = subset(newpHdata, select = -c(newpHdata$Dates))
newpHdata = subset(newpHdata, select = -c(newpHdata$Time))

And I'm getting this error

> newpHdata = subset(newpHdata, select = -c(newpHdata$Dates))
Error in `-.Date`(c(newpHdata$Dates)) : 
  unary - is not defined for "Date" objects
> newpHdata = subset(newpHdata, select = -c(newpHdata$Time))
Error in -c(newpHdata$Time) : invalid argument to unary operator

akrun · Accepted Answer · 2022-11-04T17:06:10.857

Use the column name alone in subset without any $ as the $ extracts the values of the columns whereas we need only the column names

newpHdata <- subset(newpHdata, select = -c(Dates))

-testing

newpHdata <- head(iris)
newpHdata$Dates <- Sys.Date()
subset(newpHdata, select = -c(Dates))
  Sepal.Length Sepal.Width Petal.Length Petal.Width Species
1          5.1         3.5          1.4         0.2  setosa
2          4.9         3.0          1.4         0.2  setosa
3          4.7         3.2          1.3         0.2  setosa
4          4.6         3.1          1.5         0.2  setosa
5          5.0         3.6          1.4         0.2  setosa
6          5.4         3.9          1.7         0.4  setosa
 subset(newpHdata, select = -c(newpHdata$Dates))
Error in `-.Date`(c(newpHdata$Dates)) : 
  unary - is not defined for "Date" objects

How to drop a Date column in R

1 Answers1