I am new on stack over flow and I have a time series data having 37 columns (longitude) and 18 rows (latitude) with 9587 observations. The row names are repeating after ever 18 observations.
70.875 71.125 71.375 71.625 71.875 72.125
33.1251 0 0 0 0 0 0
33.3751 0 0 0 0 0 0
33.6251 0 0 0 0 0 0
33.8751 0 0 0 0 0 0
34.1251 0 0 0 0 0 0
34.3751 0 0 0 0 0 0
I have to extract each box value separately as like,
latitude1*longitude1 (365 observations)
latitude1*longitude2 (365 observations)
latitude1*longitude3 (365 observations)
In last
latitude18*longitude37 (365 observations)
How I can execute this operation in Rstudio. How I can execute this operation in Rstudio. Thanks in advance for any kind of help.