CODEWITHSUNDEEP
rdataframe
Turbo
Turbo

Reputation: 2560

Add column to R dataframe that is length of string in another column

This should be EASY but I can't figure it out and search didn't help. I'd like to add a column to a dataframe that is just the length of the strings in another column.

So say I have a data frame of names like such:

   Name    Last
1  John     Doe
2 Edgar     Poe
3  Walt Whitman
4  Jane  Austen

I'd like to append a new column with the string length of, say, the last name, so it would look like:

   Name    Last  Length
1  John     Doe  3
2 Edgar     Poe  3
3  Walt Whitman  7
4  Jane  Austen  6

Thanks

Upvotes: 6

Views: 8436

Answers (2)

Chrisfufu
Chrisfufu

Reputation: 1

If you want to filter by the length, based on column, then do the following:

library(dplyr) 

df<- df %>% 
  filter(nchar(Last) <= 3)

Upvotes: 0

akrun
akrun

Reputation: 887088

We can use str_count from stringr

library(stringr)
df1$Length <- str_count(df1$Last)
df1$Length
[1] 3 3 7 6

Upvotes: 4

Related Questions