Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.4k views
in Technique[技术] by (71.8m points)

sum specific values in a specific column in R using sum()

I have a table of values 1, 2, 3, 4 randomly distributed across 35 rows and 15 columns. How can use the sum() function to just add the "4"s across the entire table, and also on a separate operation add all "4"s from a specific column.

Thanks,

This is the matrix:

m1imported <-matrix(sample(x = 1:4, size = 35*15, replace = TRUE), nrow = 35, ncol = 15)

us<c("CALIFORNIA","FLORIDA","ARIZONA","MICHIGAN","WASHINGTON","GEORGIA","TEXAS","OHIO","ALABAMA","COLORADO","NEW JERSEY","VIRGINIA","MONTANA","OREGON","NEW YORK")

colnames(m1imported) = us

num<-c(1:35)
rownames (m1imported) = num
question from:https://stackoverflow.com/questions/65913637/sum-specific-values-in-a-specific-column-in-r-using-sum

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

To count 4's across entire matrix :

sum(m1imported == 4)

To count 4's across each column.

colSums(m1imported == 4)

To sum 4's across entire matrix :

sum(m1imported==4)*4

To sum 4's across each column.

colSums(m1imported==4)*4

vector of females:

females <- c(m1imported[1:20,])

vector of males:

males <- c(m1imported[-1:-(nrow(m1imported)-15),])

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...