# How to find the frequency of each value in an R data frame?

R ProgrammingServer Side ProgrammingProgramming

#### Artificial Intelligence : The Future Of Programming

15 Lectures 54 mins

#### Beyond Basic Programming - Intermediate Python

Most Popular

36 Lectures 3 hours

#### C Programming from scratch- Master C Programming

Best Seller

60 Lectures 8 hours

To find the frequency of each value in an R data frame, we can use table function along with unlist function.

For Example, if we have a data frame called df and we want to find the frequency of each value in df then we can use the below command −

table(unlist(df))

## Example 1

Following snippet creates a sample data frame −

x1<-sample(0:9,20,replace=TRUE)
x2<-sample(0:9,20,replace=TRUE)
x3<-sample(0:9,20,replace=TRUE)
x4<-sample(0:9,20,replace=TRUE)
df1<-data.frame(x1,x2,x3,x4)
df1

The following dataframe is created

  x1 x2 x3 x4
1 0 2  8  0
2 6 6  4  2
3 8 2  5  8
4 0 3  8  5
5 5 1  2  5
6 8 6  2  9
7 9 3  4  2
8 1 7  3  4
9 4 0  3  6
10 3 9  4  6
11 9 7  9  2
12 4 1  8  7
13 8 6  9  7
14 0 3  5  7
15 6 7  2  6
16 4 1  5  4
17 6 4  0  4
18 9 3  6  3
19 1 6  5  1
20 8 6  0  5

To find the frequency of each value in df1 on the above created data frame, add the following code to the above snippet −

x1<-sample(0:9,20,replace=TRUE)
x2<-sample(0:9,20,replace=TRUE)
x3<-sample(0:9,20,replace=TRUE)
x4<-sample(0:9,20,replace=TRUE)
df1<-data.frame(x1,x2,x3,x4)
table(unlist(df1))

## Output

If you execute all the above given snippets as a single program, it generates the following Output −

0 1 2 3  4 5  6 7 8 9
7 6 8 8 10 8 12 6 8 7

## Example 2

Following snippet creates a sample data frame −

y1<-rpois(20,1)
y2<-rpois(20,1)
y3<-rpois(20,1)
df2<-data.frame(y1,y2,y3)
df2

The following dataframe is created

  y1 y2 y3
1 1 1  1
2 0 0  0
3 1 5  0
4 1 1  2
5 0 2  0
6 0 2  1
7 0 2  0
8 0 0  2
9 0 0  1
10 2 1  0
11 0 0  1
12 2 1  0
13 1 1  2
14 0 0  0
15 1 2  1
16 3 2  0
17 0 0  1
18 1 0  0
19 1 1  0
20 1 1  0

To find the frequency of each value in df2 on the above created data frame, add the
following code to the above snippet −

y1<-rpois(20,1)
y2<-rpois(20,1)
y3<-rpois(20,1)
df2<-data.frame(y1,y2,y3)
table(unlist(df2))

## Output

If you execute all the above given snippets as a single program, it generates the
following Output −

 0  1  2 3 5
27 21 10 1 1

## Example 3

Following snippet creates a sample data frame −

z1<-round(rnorm(20),0)
z2<-round(rnorm(20),0)
z3<-round(rnorm(20),0)
df3<-data.frame(z1,z2,z3)
df3

The following dataframe is created

  z1  z2 z3
1  1  1  0
2 -1 -2 -1
3  0  1  0
4  0  0  0
5 -1 -2  0
6 -1 -1 -1
7  0  1  0
8  0 -1  0
9 -1 -1  1
10  0  0  1
11 -2 -1  1
12  1 -1  0
13 -2  0  0
14 -2 -1  1
15  1  1  0
16  2  0  0
17  0  0  1
18  0  1  0
19  0  1  0
20  1  1 -2

To find the frequency of each value in df3 on the above created data frame, add the
following code to the above snippet −

z1<-round(rnorm(20),0)
z2<-round(rnorm(20),0)
z3<-round(rnorm(20),0)
df3<-data.frame(z1,z2,z3)
table(unlist(df3))

## Output

If you execute all the above given snippets as a single program, it generates the
following Output −

-2 -1  0  1 2
6 12 25 16 1
Updated on 08-Nov-2021 10:54:04