- Trending Categories
- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to count the number of times a value occurs in a column of an R data frame?
To count the number of times a value occurs in a column of an R data frame, we can use table function for that particular column.
For example, if we have a data frame called df that contains a column say Response then finding the number of times a value occurs in Response can be found by using the command given below −
table(df$Response)
Example 1
Following snippet creates a sample data frame −
x<-rpois(20,1) df1<-data.frame(x) df1
Output
The following dataframe is created −
x 1 1 2 2 3 1 4 5 5 0 6 0 7 0 8 0 9 0 10 2 11 3 12 1 13 0 14 2 15 1 16 0 17 4 18 0 19 2 20 1
To create a table for data in x, add the following code to the above snippet −
x<-rpois(20,1) df1<-data.frame(x) table(df1$x)
Output
If you execute all the above given codes as a single program, it generates the following output −
0 1 2 3 4 5 8 5 4 1 1 1
Example 2
Following snippet creates a sample data frame −
y<-round(rnorm(20,5,2),0) df2<-data.frame(y) df2
Output
The following dataframe is created −
y 1 8 2 3 3 6 4 6 5 5 6 6 7 5 8 8 9 6 10 6 11 5 12 5 13 10 14 3 15 8 16 5 17 6 18 6 19 4 20 8
To create a table for data in y, add the following code to the above snippet −
y<-round(rnorm(20,5,2),0) df2<-data.frame(y) table(df2$y)
Output
If you execute all the above given codes as a single program, it generates the following output −
3 4 5 6 8 10 2 1 5 7 4 1
Example 3
Following snippet creates a sample data frame −
z<-round(rnorm(20,25,1),0) df3<-data.frame(z) df3
Output
The following dataframe is created −
z 1 24 2 25 3 24 4 26 5 24 6 25 7 25 8 27 9 26 10 26 11 23 12 25 13 24 14 24 15 27 16 26 17 25 18 26 19 25 20 26
To create table for data in z, add the following code to the above snippet −
z<-round(rnorm(20,25,1),0) df3<-data.frame(z) table(df3$z)
Output
If you execute all the above given codes as a single program, it generates the following output −
23 24 25 26 27 1 5 6 6 2