CarrKnight
CarrKnight

Reputation: 2918

Melt grid data in TidyR

I have a very simple data-set that is organized as a grid/raster/table:

1,2,3
4,5,6
7,8,9

I'd like to read it in tidyR (and cognates) into:

x,y,value
1,1,1
1,2,2
1,3,3
.....

It seems like a straightforward problem but I can't figure out how to attack it.

Upvotes: 1

Views: 70

Answers (1)

Robert Hijmans
Robert Hijmans

Reputation: 47071

Here is one approach:

library(raster)
r <- raster(matrix(1:9, nrow=3, byrow=T))
cbind(rowColFromCell(r, 1:ncell(r)), values(r))

Upvotes: 1

Related Questions