r wordcounter of a column

[oefoek]

Hi,

I am new with r studio, I will appriciate every help;-).
I have tabel in r studio with different columns. I need to count the words of the column "reviews" and put this output in a new column. How should I do this?

[siddharthprabhu]

Here's one method using the dplyr and stringr packages.

library(dplyr, warn.conflicts = FALSE)
library(stringr)

data <- tibble(reviews = c("the dog is on the mat", 
                           "the cat is on top of the wall"))

data <- mutate(data, word_count = lengths(str_split(reviews, boundary("word"))))

print(data)
#> # A tibble: 2 x 2
#>   reviews                       word_count
#>   <chr>                              <int>
#> 1 the dog is on the mat                  6
#> 2 the cat is on top of the wall          8

^{Created on 2020-05-07 by the reprex package (v0.3.0)}

[oefoek]

thank you for your time !!!!

[siddharthprabhu]

No problem. If your issue has been solved, please consider marking my post as a solution.

FAQ: How do I mark a solution?

If your question has been answered, don't forget to mark the solution! How do I mark a solution? Find the reply you want to mark as the solution and look for the row of small gray icons at the bottom of that reply. Click the one that looks like a box with a checkmark in it: [image] Hovering over the mark solution button shows the label, "Select if this reply solves the problem". If you don't see the mark solution button, try clicking the three dots button ( ••• ) to expand the full set of options. When a solution is chosen, the icon turns green and the hover label changes to: "Unselect if this reply no longer solves the problem". Success! [solution_reply_author] …