how i can break 1 colum in 2 eg
33.54+72.97 is in 1 colum and i want to break it in 2 colums eg 33.54 and 72.97
It looks like you want to use the {dplyr} function, separate()
my_data %>%
separate(my_column, into = c("first_col", "second_col"),
sep = " + " )
its not working please help
x=c("33.54+72.97","33.56+72.91")
x
separate("x", into = c("LAT", "LONG"),
sep = " + " )
did you get an error ?
it would be rational to quote the error you receive... but in this case I can predict what it would be.
it could be that you havent loaded the assumed tidyverse library , which includes the tidyr library of which separate is a function.
even then, tidyr::separate does not process raw character strings, it processes dataframes with character columns.
Here is a complete example
library(tidyverse)
(x <- c("33.54+72.97","33.56+72.91"))
(my_x_df <- enframe(x))
separate(my_x_df,col=value,
into = c("LAT", "LONG"),
sep = "\\+" )
This topic was automatically closed 21 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.