Sorry, that was a poorly worded question. You're right in that the gaps are in fact NAs and I would be proposing to remove these entirely. So it's really a case of filling up a 720 x 360 grid (by row) based on the data in the 18556 rows x 19 columns data frame.
I've tried doing: data_mat <- matrix(data, nrow=360, ncol=720, byrow=TRUE) Warning message: In matrix(river, nrow = 360, ncol = 720, byrow = TRUE) : data length [19] is not a sub-multiple or multiple of the number of rows [360] But this results in a mess! head(data_mat) [,1] [,2] [,3] [,4] [,5] [1,] Numeric,18556 Numeric,18556 Numeric,18556 Numeric,18556 Numeric,18556 [2,] Numeric,18556 Numeric,18556 Numeric,18556 Numeric,18556 Numeric,18556 [3,] Numeric,18556 Numeric,18556 Numeric,18556 Numeric,18556 Numeric,18556 [4,] Numeric,18556 Numeric,18556 Numeric,18556 Numeric,18556 Numeric,18556 [5,] Numeric,18556 Numeric,18556 Numeric,18556 Numeric,18556 Numeric,18556 [6,] Numeric,18556 Numeric,18556 Numeric,18556 Numeric,18556 Numeric,18556 If it's of any use, the original data are structured as follows: str(data) 'data.frame': 18556 obs. of 19 variables: $ V1 : num 0 0 0 0 0 0 0 0 0 0 ... $ V2 : num 0 0 0 0 0 0 0 0 0 0 ... $ V3 : num 0 0 0 0 0 0 0 0 0 0 ... $ V4 : num 0 0 0 0 0 0 0 0 0 0 ... $ V5 : num 0 0 0 0 0 0 0 0 0 0 ... $ V6 : num 0 0 0 0 0 0 0 0 0 0 ... $ V7 : num 0 0 0 0 0 0 0 0 0 0 ... $ V8 : num 0 0 0 0 0 0 0 0 0 0 ... $ V9 : num 0 0 0 0 0 0 0 0 0 0 ... $ V10: num 0 0 0 0 0 0 0 0 0 0 ... $ V11: num 0 0 0 0 0 0 0 0 0 0 ... $ V12: num 0 0 0 0 0 0 0 0 0 0 ... $ V13: num 0 0 0 0 0 0 0 0 0 0 ... $ V14: num 0 0 0 0 0 0 0 0 0 0 ... $ V15: num 0 0 0 0 0 0 0 0 0 0 ... $ V16: num 0 0 0 0 0 0 0 0 0 0 ... $ V17: num 0 0 0 0 0 0 0 0 0 0 ... $ V18: num 0 0 0 0 0 0 0 0 0 0 ... $ V19: num 0 0 0 0 0 0 0 0 0 0 ... Don't worry about all the zeros - there are plenty of greater values later on! Any help would be gratefully received. Thanks, Steve ---------------------------------------- > From: dwinsem...@comcast.net > To: smurray...@hotmail.com > Subject: Re: [R] Filling a grid based on existing data > Date: Wed, 24 Mar 2010 20:50:40 -0400 > > > On Mar 24, 2010, at 2:34 PM, Steve Murray wrote: > >> >> Dear all, >> >> I currently have a data frame of dimensions 18556 rows by 19 >> columns. I want to convert this into a grid of dimensions 720 rows >> by 360 columns. The problem in this case is that not all rows in the >> initial data frame are complete (there are gaps). >> >> Therefore I am perhaps looking for a way of filling a 720 x 360 grid >> by reading in all values in each row until one is encountered which >> does not have 19 columns. In these cases, the row in the new grid >> should be filled (as the gaps occur every 720 values), and filling >> should re-start on the next row of the new grid. I hope this is >> reasonably clear! > > Perhaps it could become clearer. Dataframes in R do not have "gaps". > They may have NA's but all the columns and rows have _something_. > And ... with what were you proposing to Fill these "gaps". > > -- > David > >> >> Many thanks for any help, >> >> Steve >> >> >> _________________________________________________________________ >> Got a cool Hotmail story? Tell us now >> >> ______________________________________________ >> 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. > _________________________________________________________________ Do you have a story that started on Hotmail? Tell us now ______________________________________________ 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.
