Hi Chris82,
Try this:
res=c(which(a == max(a), arr.ind = T),max(a))
names(res)=c('row','col','value')
write.csv(res,"C://yourfile.csv",row.names=TRUE)
HTH,
Jorge
On Wed, Sep 17, 2008 at 1:47 PM, Chris82 <rubenbauar@gmx.de> wrote:
>
> Hello R users,
>
> I want to readout the row and column postion from a certain matrix value
> into a csv file.
> I have only found this syntax
>
> "which(a == b, arr.ind = T)"
>
> so I get
>
> a = matrix
>
> [,1] [,2] [,3] [,4] [,5] [,6] [,7] [,8]
> [1,] 1 1 2 2 2 1 1 2
> [2,] 1 2 3 3 3 4 4 3
> [3,] 3 3 3 5 5 6 5 4
> [4,] 4 4 4 3 3 4 4 3
> [5,] 3 4 5 3 3 3 2 2
> [6,] 3 3 3 3 3 3 2 2
> [7,] 2 2 2 2 2 4 2 1
> [8,] 1 1 0 0 0 0 0 0
>
> > print(max(a))
> [1] 6
> > which(a == max(a), arr.ind = T)
> row col
> [1,] 3 6
>
> but I need row and col seperate for the csv file.
>
> row <- c("code for row")
> col <- c("code for col")
> value <- c("6")
>
> #dataframe
>
> test <- data.frame(row, col, value)
>
> write.csv................
>
> Thanks.
>
> Greets
>
> --
> View this message in context:
>
http://www.nabble.com/Readout-row-and-column-of-a-matrix-value-tp19537540p19537540.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
>
[[alternative HTML version deleted]]