Issue removing duplicates

Hello, I am having issues trying to remove duplicates from the data. I believe I have entered the correct function, but an error keeps showcasing as you can see below While I have looked up the reason why this error may be occurring, I don't see the issue. Can someone provide some assisant. Thank you

Divvy_Trips_2015_Q1<- Divvy_Trips_2015_Q1 %/%

  • distinct("bike_id", .keep_all = TRUE)
    Error in UseMethod("distinct") :
    no applicable method for 'distinct' applied to an object of class "character"

class(Divvy_Trips_2015_Q1)
[1] "spec_tbl_df" "tbl_df" "tbl" "data.frame"

The error occurs because the distinct() function is being applied incorrectly. The argument .keep_all = TRUE should be passed within the distinct() function to preserve other columns, and the syntax for filtering by bike_id needs to be corrected. Here's the correct approach:

Divvy_Trips_2015_Q1 <- Divvy_Trips_2015_Q1 %>%
distinct(bike_id, .keep_all = TRUE)
Ensure you are using the dplyr package. You can check if it's loaded using:

library(dplyr)
I hope this will resolve your issue, while I faced same issue for my for my spotify premium apk todo desbloqueado.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.