similar to: translating SQL statements into data.table operations

Good morning, I'm running into trouble rbind-ing numeric matrices with differing numbers of rows. In particular, there seem to be issues whenever a one-row numeric matrix is involved. Assume A is a numeric matrix with 1 row and Y columns and B is a numeric matrix with X rows and Y columns. Let C be the result of rbinding A and B. Then C is a numeric matrix with X + 1 rows and Y columns, only

Hello, I'm having trouble discovering what's going wrong with my use of natural joins via sqldf. Following the instructions under 4i at http://code.google.com/p/sqldf/, which discusses creating indices to speed joins, I have been only unreliably able to get natural joins to work. For example, > Tid <- c('AES 01-01-02 10:58:00', 'AES 01-01-02 11:53:00', 'AES

Hi All, I have a data set of daily measurements of river flow. I would like to create a "ts" object from this data. Here's a sample data set: date <- as.Date(c(1:300), format="%Y") year=as.numeric(format(date, format = "%Y")) month=as.numeric(format(date, format = "%m")) julianday=as.numeric(format(date, format = "%j"))

Hello, I am having a problem making use of some data outputted from an instrument in a somewhat weird format. The instrument outputs two columns - one called JulianDay.Hour and one called Minutes.Seconds. I would like to convert these columns into a single column with a time. So I was using substr() and paste to extract that info. This works fine for the JulianDay.Hour column as there are always

I am very new to R and programming and thank you in advance for your patience and help with a complete novice! I am working with a large multivariate data set that has 10 explanatory environmental variables (e.g. temp, depth) and over 60 response variables (each is a separate species). My data frame is set up like the simplified version below: JulianDay Temperature Salinity Depth Copepod

I am working on a simple pilot project comparing the capability of SQL, SAS and R to perform a rolling mean per the following instructions. I have completed the SQL and SAS analysis, so now it's R's turn. Calculate mean values of x (x=count) for each date in the dataset where mean = the average count of days [t-9] through day [t-3] for each date/illness combination. Dataset aggpilot

Necesito algo de programación básica para resolver un problema, un inconveniente es que intente "if", cuándo se lo aplico digamos a x <- 5 no hay drama, pero si es a leche$litros me dice que solo se toma el primer elemento. Como pueden ver estoy re perdido. Mi problema: los datos están en un data.frame como el siguiente animal inicio fin control idlactancias

R HELP, I am trying to use an R script to connect to a mysql database. I am having a problem using a variable in the where clause that contains a "space" in its value. If I include the variable inside the quotes of the query - i think it is searching for the name of the variable in the database and not the value of the variable. If I put it outside the quotes, then it complains

I have a dataset w/ 184K obs & 16 variables. In SAS I proc sort nodupkey it in seconds by 11 variables. I tried to do the same thing in R using both the unique & then the !duplicated functions but it just hangs there & I get no output. Does anyone know how to solve this? This is how I tried to do it in R: detail3 <-

Hi All, I was wondering if there was a function in R that would output the total run time for various scripts. For now I have the following workaround: begTime <- Sys.time() ... the rest of the R script... runTime <- Sys.time()-begTime Is there another function that I don't know about that would return this information in a more elegant manner? Thanks! [[alternative HTML

Hi r-devel, svSocket is working well. Short demo here of using it with data.table : http://www.youtube.com/watch?v=rvT8XThGA8o If you maximise and press the HD button it should be readable. There isn't any audio. However, svSocket is currently text based IPC using dump. Is there a solution which will do binary and work in the same way ? Its nice that I can make R become a server any

Am running Samba 2.2.7 on Red Hat 8.0 with Windows 2K clients patched to SP4 Creating off line folders works fine but if any file is modified off line and then sync'd back when the laptop is reconnected to the network it comes back with an unable to connect - access denied message. But I can quite happily copy the files over manually. I have attached the log file (log level = 3) for the

The build system rolled up R-3.3.3.tar.gz (codename "Another Canoe") this morning. The list below details the changes in this release. You can get the source code from http://cran.r-project.org/src/base/R-3/R-3.3.3.tar.gz or wait for it to be mirrored at a CRAN site nearer to you. Binaries for various platforms will appear in due course. For the R Core Team, Peter Dalgaard

The build system rolled up R-3.3.3.tar.gz (codename "Another Canoe") this morning. The list below details the changes in this release. You can get the source code from http://cran.r-project.org/src/base/R-3/R-3.3.3.tar.gz or wait for it to be mirrored at a CRAN site nearer to you. Binaries for various platforms will appear in due course. For the R Core Team, Peter Dalgaard

Is R an appropriate tool for data manipulation and data reshaping and data organizing? I think so but someone who recently joined our group thinks not. The new recruit believes that python or another language is a far better tool for developing data manipulation scripts that can be then used by several members of our research group. Her assessment is that R is useful only when it comes to data

is turned on. Can anybody kind to confirm with me? Our network is using a mix of Win2k server, Win2k Pro, Win98, Win95 and WinMe machines, where the Win2k server is the domain controller and terminal service applications server and the Samba is a member fileserver of the domain. All workstations logon and mount the samba file services. We'd like to check if the problem could be solved by