converting character to double

[Babatunde_Olamilekan]

#formatting trip_duration from chr to dbl
cy_trips1 <- cy_trips %>%
mutate(
trip_duration = as.numeric(tripduration)
)
hey guys, i am trying to convert trips_duration to double datatype
but i keep getting
Warning message:
Problem while computing trip_duration = as.numeric(tripduration).
i NAs introduced by coercion .

i read online someone said its because my csv file was loaded with comma separator "," so here i'm
pls how do i load my csv file and remove the comma "," separator

[FJCC]

Something like this should work.

library(dplyr)
cy_trips1 <- cy_trips %>% mutate(tripduration = sub(",","", tripduration),
                    tripduration=as.numeric(tripduration))

[Babatunde_Olamilekan]

thank you it did work