Hi Elisa, I am not sure about the output you wanted. dat1<- read.csv("rightest.csv",sep=",",header=TRUE,check.names=FALSE) dat2<- as.dist(dat1[,-1],upper=F,diag=F) vec1<- as.vector(dat2) label1=c("0-25","25-50","50-75") Count1<- as.data.frame(table(cut(vec1,breaks=seq(0,75,25),labels=label1))) #Overall count Count1 # Var1 Freq #1 0-25 5465 #2 25-50 1992 #3 50-75 169
Name1<-unlist(lapply(0:123,function(i) rep(i+1,i))) length(Name1) #[1] 7626 dat3<-data.frame(Name1,vec1) res<-t(aggregate(.~Name1,data=dat3,function(x) table(cut(x,breaks=seq(0,75,25),labels=label1)))) colnames(res)<- res[1,] res1<- res[-1,] row.names(res1)<-gsub("vec1.","",row.names(res1)) res1 # 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 #0-25 1 0 2 0 2 3 2 1 1 1 3 1 1 3 2 3 6 3 5 2 4 8 13 21 21 23 20 #25-50 0 2 1 4 3 3 5 7 8 8 8 11 12 11 13 12 11 15 14 18 17 12 10 3 2 3 6 #50-75 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 2 0 0 2 0 1 ----------------------------------------------------------------------------------------------------- A.K. ________________________________ Fr istogram Dear Arun, i have a distance matrix as attached in excel file with this email. You can read the data via R and after reading the data i want you to extract the lower part of distance matrix by as.dist(x, upper=F, diag=F). You will see that there are 124 stations in my study. After that, i want to divide the data into three intervals 0-25, 25-75, 75-100. Then i want to count the number of stations falling in each interval, which will be called "Frequency". After that i want to draw the following table Range stations Frequency 0-25 names of station Number of stations 25-50 50-75 Finally, i want to draw histogram. i know i asked same kind of question before, but those commands are not working on distance matrix. thankyou very very much in advance elisa ______________________________________________ R-help@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.