Hello togehter, i have a data.frame, with value like this:
A B
1 10-1 aaa
2 10-1 bbb
3 10-1 abc
4 10-2 vvv
5 10-3 ggg
I want now a evaluation, which character is how often in my data.frame. Like
this one:
A B
1 10-1 3
2 10-2 1
3 10-3 1
How can i do this?
Thank you.
Mat
--
View this message in context:
http://r.789695.n4.nabble.com/Count-cell-Count-by-her-frequency-tp4652650.html
Sent from the R help mailing list archive at Nabble.com.
Hello, Try the following. dat <- read.table(text = " A B 1 10-1 aaa 2 10-1 bbb 3 10-1 abc 4 10-2 vvv 5 10-3 ggg ", header = TRUE) tbl <- table(dat$A) data.frame(tbl) Hope this helps, Rui Barradas Em 10-12-2012 08:50, Mat escreveu:> Hello togehter, i have a data.frame, with value like this: > > A B > 1 10-1 aaa > 2 10-1 bbb > 3 10-1 abc > 4 10-2 vvv > 5 10-3 ggg > > I want now a evaluation, which character is how often in my data.frame. Like > this one: > A B > 1 10-1 3 > 2 10-2 1 > 3 10-3 1 > > How can i do this? > > Thank you. > > Mat > > > > -- > View this message in context: http://r.789695.n4.nabble.com/Count-cell-Count-by-her-frequency-tp4652650.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.
You request is not completely clear. I am assuming you want to count the number of different characters in B for each category in A:> A <- c("10-1", "10-1", "10-1", "10-2", "10-3") > B <- c("aaa", "bbb", "abc", "vvv", "ggg") > dta <- data.frame(A, B) > dtaA B 1 10-1 aaa 2 10-1 bbb 3 10-1 abc 4 10-2 vvv 5 10-3 ggg> a1 <- tapply(dta$B, dta$A, paste0, collapse="") > a2 <- strsplit(a1, "") > a3 <- lapply(a2, unique) > a4 <- sapply(a3, length) > dtanew <- data.frame(A=names(a4), B=a4, row.names=1:length(a4)) > dtanewA B 1 10-1 3 2 10-2 1 3 10-3 1 ---------------------------------------------- David L Carlson Associate Professor of Anthropology Texas A&M University College Station, TX 77843-4352> -----Original Message----- > From: r-help-bounces at r-project.org [mailto:r-help-bounces at r- > project.org] On Behalf Of Mat > Sent: Monday, December 10, 2012 2:50 AM > To: r-help at r-project.org > Subject: [R] Count cell Count by her frequency > > Hello togehter, i have a data.frame, with value like this: > > A B > 1 10-1 aaa > 2 10-1 bbb > 3 10-1 abc > 4 10-2 vvv > 5 10-3 ggg > > I want now a evaluation, which character is how often in my data.frame. > Like > this one: > A B > 1 10-1 3 > 2 10-2 1 > 3 10-3 1 > > How can i do this? > > Thank you. > > Mat > > > > -- > View this message in context: http://r.789695.n4.nabble.com/Count-cell- > Count-by-her-frequency-tp4652650.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting- > guide.html > and provide commented, minimal, self-contained, reproducible code.
Thank you all, a few ideas worked perfectly for me. I take "with(dat1,aggregate(B,by=list(A=A),length))" for my task. Have a nice day. Mat -- View this message in context: http://r.789695.n4.nabble.com/Count-cell-Count-by-her-frequency-tp4652650p4652678.html Sent from the R help mailing list archive at Nabble.com.