split character data into numbers and letters

by

Since none of the previous answers use tidyr::separate here it goes:

library(tidyr)

df <- data.frame(mycol = c("APPLE348744", "BANANA77845", "OATS2647892", "EGG98586456"))

df %>%
  separate(mycol, 
           into = c("text", "num"), 
           sep = "(?<=[A-Za-z])(?=[0-9])"
           )

More Related Contents:

  1. How can the facet function in ggplot be used to create a histogram in order to visualize distributions for all variables in a dataset?
  2. How can I find compound words, removing spaces between them and replace them in my corpus?
  3. Count number of rows within each group
  4. Faster ways to calculate frequencies and cast from long to wide
  5. How can I remove all duplicates so that NONE are left in a data frame?
  6. strptime, as.POSIXct and as.Date return unexpected NA
  7. How to delete a row by reference in data.table?
  8. Measuring function execution time in R
  9. R – Concatenate two dataframes?
  10. Error in plot.new() : figure margins too large in R
  11. Generate a repeating sequence based on vector
  12. Sort columns of a dataframe by column name
  13. anova test fails on lme fits created with pasted formula
  14. How can we make xkcd style graphs?
  15. lib unspecified & Error in loadNamespace
  16. How to call a function using the character string of the function name in R?
  17. How can I fix corrupted dates in R?
  18. Inserting a table under the legend in a ggplot2 histogram
  19. Installing rgl on Ubuntu and Mac: X11 not found
  20. Import data into R with an unknown number of columns?
  21. Uniroot solution in R
  22. Re-ordering factor levels in data frame [duplicate]
  23. How to change the first row to be the header in R?
  24. Insert a logo in upper right corner of R markdown pdf document
  25. Get the event which is fired in Shiny?
  26. How to replace NA (missing values) in a data frame with neighbouring values
  27. Convert accented characters into ascii character
  28. What does the error “arguments imply differing number of rows: x, y” mean?
  29. Removing multiple columns from R data.table with parameter for columns to remove
  30. Change the position of the strip label in ggplot from the top to the bottom?

Leave a Comment