- 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 find the mean of columns of an R data frame or a matrix?
If all the columns in an R data frame are numeric then it makes sense to find the mean for each of the columns. This calculation will help us to view how different the values of means are for each of the columns but to make sure that they are significantly different, we will need to run a hypothesis test. To find the column means of a data frame or a matrix we can use colMeans function.
Example
Consider the below data frame −
set.seed(9) x1<-rnorm(20,0.2) x2<-rnorm(20,0.5) x3<-rnorm(20,0.8) x4<-rnorm(20,1.5) x5<-rpois(20,2) x6<-rpois(20,5) df<-data.frame(x1,x2,x3,x4,x5,x6) df
Output
x1 x2 x3 x4 x5 x6 1 -0.56679604 2.2569929 -0.008456344 1.7812222 2 4 2 -0.61645834 0.6822521 -1.219381694 0.2972914 4 5 3 0.05846481 0.2331113 0.061275928 1.9651637 1 3 4 -0.07760503 1.4264216 1.182886561 1.8520164 4 5 5 0.63630690 -0.1933319 2.530863668 0.9101438 2 3 6 -0.98687252 3.1819901 0.596918049 0.6464000 4 10 7 1.39198691 0.7225245 -0.196397348 1.2532679 4 7 8 0.18180966 -0.2066724 -0.506536295 3.0393386 3 5 9 -0.04808460 0.9172132 -0.197831604 2.0460777 0 4 10 -0.16293689 0.8695568 0.234971274 3.0649619 1 3 11 1.47757055 -0.4137643 2.552057836 1.7496702 2 4 12 -0.26889715 0.1830853 0.252228648 -0.4624186 1 4 13 0.27105410 1.5490592 -0.058525708 0.6909398 3 3 14 -0.06603845 0.6681118 0.849294533 1.0013149 2 5 15 2.04525720 0.5314402 0.599955518 1.8051218 1 7 16 -0.63944966 -0.5103305 -0.303954449 1.2107928 0 4 17 0.12255194 0.8827515 1.040588038 2.9577142 0 2 18 -2.41770553 -0.3196965 1.181113616 2.3737555 5 5 19 1.08788403 0.8617111 3.030458950 0.5470440 3 6 20 -0.50749145 0.5933714 1.999202392 1.4683245 1 6
colMeans(df) x1 x2 x3 x4 x5 x6 0.04572752 0.69578987 0.68103658 1.50990712 2.15000000 4.75000000
Example
Finding the mean of columns of a matrix if the matrix is a square matrix −
Matrix<-matrix(1:100,nrow=10) Matrix
Output
[,1] [,2] [,3] [,4] [,5] [,6] [,7] [,8] [,9] [,10] [1,] 1 11 21 31 41 51 61 71 81 91 [2,] 2 12 22 32 42 52 62 72 82 92 [3,] 3 13 23 33 43 53 63 73 83 93 [4,] 4 14 24 34 44 54 64 74 84 94 [5,] 5 15 25 35 45 55 65 75 85 95 [6,] 6 16 26 36 46 56 66 76 86 96 [7,] 7 17 27 37 47 57 67 77 87 97 [8,] 8 18 28 38 48 58 68 78 88 98 [9,] 9 19 29 39 49 59 69 79 89 99 [10,] 10 20 30 40 50 60 70 80 90 100 colMeans(Matrix) [1] 5.5 15.5 25.5 35.5 45.5 55.5 65.5 75.5 85.5 95.5
Example
Finding the mean of columns of a matrix if the matrix is not a square matrix −
Matrix_new<-matrix(1:100,ncol=20) Matrix_new
Output
[,1] [,2] [,3] [,4] [,5] [,6] [,7] [,8] [,9] [,10] [,11] [,12] [,13] [,14] [1,] 1 6 11 16 21 26 31 36 41 46 51 56 61 66 [2,] 2 7 12 17 22 27 32 37 42 47 52 57 62 67 [3,] 3 8 13 18 23 28 33 38 43 48 53 58 63 68 [4,] 4 9 14 19 24 29 34 39 44 49 54 59 64 69 [5,] 5 10 15 20 25 30 35 40 45 50 55 60 65 70 [,15] [,16] [,17] [,18] [,19] [,20] [1,] 71 76 81 86 91 96 [2,] 72 77 82 87 92 97 [3,] 73 78 83 88 93 98 [4,] 74 79 84 89 94 99 [5,] 75 80 85 90 95 100 colMeans(Matrix_new) [1] 3 8 13 18 23 28 33 38 43 48 53 58 63 68 73 78 83 88 93 98
Advertisements