I have column seller_details in a data frame. An example of the data in the seller_details column is:

1. 8ysl9a1301 Active 3 hours ago chat now view shop Ratings10products996 response rate28% response
2. showcasemywardore Active 3 hours ago chat now view shop Ratings773products5k response rate70% response
3. zanzea.os Active 37 minutes ago chat now view shop Ratings290.5kproducts6.6k response rate93% response
4. airspacemy.os Active 14 minutes ago chat now view shop Ratings1.2kproducts2k response rate70% response
5. zanzea.os Active 37 minutes ago chat now view shop Ratings290.5kproducts6.6k response rate93% response

I want to extract the percentage of response rate only.

Expected output:

1. 28
2. 70
3. 93
4. 70
5. 93

Thank you

Data

structure(list(seller_details = c("8ysl9a1301 Active 3 hours ago chat now view shop Ratings10products996 response rate28% response", 
"showcasemywardore Active 3 hours ago chat now view shop Ratings773products5k response rate70% response", 
"zanzea.os Active 37 minutes ago chat now view shop Ratings290.5kproducts6.6k response rate93% response", 
"airspacemy.os Active 14 minutes ago chat now view shop Ratings1.2kproducts2k response rate70% response", 
"zanzea.os Active 37 minutes ago chat now view shop Ratings290.5kproducts6.6k response rate93% response"
)), class = "data.frame", row.names = c(NA, -5L))

CodePudding user response：

Does this work:

library(dplyr)
library(stringr)
df %>% mutate(percent = str_extract(col, '(?<=rate)\\d{2,3}'))
                                                                                                     col percent
1        8ysl9a1301 Active 3 hours ago chat now view shop Ratings10products996 response rate28% response      28
2 showcasemywardore Active 3 hours ago chat now view shop Ratings773products5k response rate70% response      70
3 zanzea.os Active 37 minutes ago chat now view shop Ratings290.5kproducts6.6k response rate93% response      93
4 airspacemy.os Active 14 minutes ago chat now view shop Ratings1.2kproducts2k response rate70% response      70
5 zanzea.os Active 37 minutes ago chat now view shop Ratings290.5kproducts6.6k response rate93% response      93

Data used:

df
                                                                                                     col
1        8ysl9a1301 Active 3 hours ago chat now view shop Ratings10products996 response rate28% response
2 showcasemywardore Active 3 hours ago chat now view shop Ratings773products5k response rate70% response
3 zanzea.os Active 37 minutes ago chat now view shop Ratings290.5kproducts6.6k response rate93% response
4 airspacemy.os Active 14 minutes ago chat now view shop Ratings1.2kproducts2k response rate70% response
5 zanzea.os Active 37 minutes ago chat now view shop Ratings290.5kproducts6.6k response rate93% response