How can you calculate the frequencies of elements across multiple columns?

Asked Nov 09 '22 at 20:55

Active Nov 09 '22 at 21:24

Viewed 31 times

I was wondering about the most efficient way to calculate the frequencies of repeated values across multiple columns. In the code example below, I want to calculate the total number of times each unique value (1, 2, or 3) appears across the 3 columns (x, y, z). Thanks for your help!

x <- c(1,2,3)
y <- c(2,3,1)
z <- c(3,2,2)

df <- data.frame(x,y,z)

I'm new to R. So I tried using table() but it's not giving me what I'm looking for (the total number of times each unique value appears across the 3 columns).

asked Nov 09 '22 at 20:55

kthomas

1

`table(unlist(df))` ? – akrun Nov 09 '22 at 20:56
1

Awesome thanks @akrun ! Missed the unlist() – kthomas Nov 09 '22 at 20:59
Sir kindly see this follow up [question](https://stackoverflow.com/questions/74381726/store-frequency-from-unlist-in-a-dataframe) – Ed_Gravy Nov 09 '22 at 21:44

How can you calculate the frequencies of elements across multiple columns?

0 Answers0