Re: [R] How to make matrix missing data 0

Thank you William Your method does work I highly appreciate that. :D Also thank you for replying, David. You are absolutely correct. I re-edited my posting to make question clear according to the guidelines in case other person meet the similar problem as I have. Thank you, Jessica

[R] How to make matrix missing data 0

Dear All, I am trying to analysis traffic data with one timestamp column and speed column. This data set contains six years data; for each year, I want to make a matrix in (day of the year) * (hour) 0 1 2 . . . 23 1 2 . . 365 However random day's record is missing(e.g. there are

Re: [R] Error: cannot allocate vector of size

Thank you for replying. when I've tried to run the R syntax in a 64 bit computer,the problem is solved. Thank you for helping out. I totally agree your advice. I would like to answer all your questions in case other people meet the same problem. The data contains one timestamp column with time zo

Re: [R] Error: cannot allocate vector of size

Thank you Jholtman. Now count is 46001902. I was trying to retrieve one-year data, but I still receive the following message: "Error: cannot allocate vector of size 64.0 Mb" -- View this message in context: http://r.789695.n4.nabble.com/Error-cannot-allocate-vector-of-size-tp3629384p3631354.html

Re: [R] Error: cannot allocate vector of size

Thank you Jeff. You are absolutely right. I just edited the R and computer info in: R is 32 bit; computer is his computer is Windows XP, 32bit Intel(R) Core(TM) e8...@3.ghz, 2.99GHz, 2.95GB of RAM. The data I am trying to retrieve is through postgre from a university server. I checked the postgre

[R] Error: cannot allocate vector of size

Dear R Users, I was using R to import five years traffic data, but the error always come up as shown below. The data frame contains 12 columns and unknown number of records. Would you have any ideas that how I should deal with this situation?　 Many thanks for any hints. >wim<-sqlQuery(channel,qry

[R] R-GUI shutdown

Dear R Users, I was using R to import several years traffic data, but every time after data successfully imported (no error or warning) when I tried to save this workplace or tackle these data, R GUI would automatically shut down. Would you have any ideas that how I should deal with this situation