transform output similar to table to string

Question

I have:

df <- data.frame(x = c("a", "a", "b"))

This:

table(df$x)

produces this:

a b 
2 1

I would like to produce a string with the same information as table like so:

a:2 b:1

So given a vector (column of a dataframe I suppose). Is this possible?

Ronak Shah · Accepted Answer · 2020-11-05 15:33:46Z

2

You can use paste :

tmp <- table(df$x)
paste(names(tmp), tmp, sep = ':')
#[1] "a:2" "b:1"

Or as one string :

paste(names(tmp), tmp, sep = ':', collapse = ' ')
[1] "a:2 b:1"

answered Nov 5, 2020 at 15:33

Ronak Shah

391k20 gold badges173 silver badges237 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Karthik S · Accepted Answer · 2020-11-05 15:40:52Z

0

does this work:

library(dplyr)
df %>% group_by(x) %>% summarise(cnt = n()) %>% mutate(str = paste0(x,':',cnt)) %>% pull(str)
`summarise()` ungrouping output (override with `.groups` argument)
[1] "a:2" "b:1"

answered Nov 5, 2020 at 15:40

Karthik S

11.6k2 gold badges15 silver badges32 bronze badges

Collectives™ on Stack Overflow

transform output similar to table to string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related