similar to: Can't read xlsx file into R. Seem, Seem to have XLConnect loaded.

Buenos días, con el código de abajo obtengo un agregate que empieza por abajo con la categoría C7 y termina arriba por la C1. Me gustaría que fuera al revés, que la C1 estuviera abajo y ascendiera hasta tener la C7 arriba. Gracias, Manuel year<-c(rep(1990, times=7),rep(2018, times=7),rep(2040, times=7),rep(2060, times=7),rep(2080, times=7),rep(2100, times=7))

I have been using aggregate function to determine the annual minimum in a daily time series. However, I was also hoping to determine the date of occurrence without having to loop through each year to identify the date of each minimum returned from aggregate(). Is there a more convenient way of doing so? Thanks in advance, Dave library(zoo) n <- 1000 dly <- zoo( x = rnorm(n), order.by

Hi all, following is my R -code and shows the error given below > n <- 100 > k<-2 > x1 <-c(1, 3);x2 <- c(2,5) > X <- matrix(c(0,0), nrow = 2, ncol = n) > for(i in 1:k) + X[i, ] <- mh1.epidemic(n,x1[i],x2[i]) Error in X[i, ] <- mh1.epidemic(n,x1[i],x2[i]):   number of items to replace is not a multiple of replacement length   > psi <-t(apply(X, c(1,2),

Buenas tardes usuarios de R. Estoy tratando de leer un archivo excel con read.xls usando la siguiente sentencia: read.xls("resultados.xlsm", colNames = TRUE, sheet = 1, type = "data.frame", from = 1, rowNames = NA, colClasses = "character", checkNames = TRUE, dateTime = "numeric", naStrings = NA, stringsAsFactors = F) Pero me da el siguiente error: Error

I have several hundred Excel 2007 data files in a folder. I would like to read every file in a single given folder using a loop. I have searched the FAQ, the forum archives here, other or older R boards and the R Import / Export documentation, and have asked some very knowledgeable R users without learning of a solution. I hope someone here can help. I understand that the most common

Dear all, I cannot reading a .xlsm file using read.xls. I executed: read.xls("resultados.xlsm", colNames = TRUE, sheet = 1, type = "data.frame", from = 1, rowNames = NA, colClasses = "character", checkNames = TRUE, dateTime = "numeric", naStrings = NA, stringsAsFactors = F) Error: Call("ReadXls", file, colNames, sheet, type, from, rowNames, :

I am trying to pass the result from a javascript function along with the result from a text_field with form_remote_tag. This is what I have so far, but no go: <% form_remote_tag(:url => {:controller => ''requests'', :action => ''create''}, :with => "''data=''+request()", :update => ''request_sent'' )

Dear R-Users, Dr. Wood replied to a similar topic before where confidence intervals were for a ratio of two treatments ( https://stat.ethz.ch/pipermail/r-help/2011-June/282190.html). But my question is more complicated than that one. In my case, log(E(y)) = s(x) where y is a smooth function of x. What I want is the confidence interval of a ratio of log[(E(y2))/E(y1)] given two fixed x values of

Good morning everyone, I have attached an Excel file that contains a macro from which I call and use R's auto.arima function to generate forecasts. The program runs perfectly and it gets me the results; however, those results are pretty unusual. I also tried using the auto.arima function directly in the R console and still get weird results. The results are shown in columns AB, AC and AD

Hello, I am having issues making my box boot with Xen. I am working with linux-2.6.16.28-xen on a gentoo box. The server is Dell PowerEdge 1850 with Perc 4e/Si, FW 521X. When dom0 reaches the point of scanning the SCSI controllers, it hangs in a loop aic7xxx_dev_reset_returns 0x2002. My regular (non-xen) kernels come up fine with detecting my adaptec scsi controller. Had anyone had the same

I have a 12 channel PRI with SNOM 190's and asterisk CVS from January. Most calls are fine, all incoming calls are fine, but I am getting echo on a significant number of outgoing calls. The person on the other side hears a perfect call, but the SIPphone side gets to hear themselves. It happens 100% of the time to some numbers (outgoing only), and only sporadically to others. Has anyone

Hi to all. I have a problem to connect to an Excel database using RODBC. Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following: library(RODBC) > channel <- odbcConnectExcel("results.xlsx") Error in odbcConnectExcel("results.xlsx") : odbcConnectExcel is only usable with 32-bit Windows # ok this is clear why it doesn't work > channel

I am planning on using Runt to calculate recurring events. I calculate a Runt object in the view and use it to see if it includes a certain date, which is populates from the database, and display the info for that date if it is included. I have recurring events for every week, which was pretty easy to set up. I can just say: r = Runt::DIWeek.new(4) For a recurring event every Thursday, and

I have been using SMS_fu but it seems too good to be true for production. I''m wondering, is there any sort of limit on email to sms depending on the carrier that you can send in a given amount of time? I remember reading somewhere that there is a limit to the number of free email to sms that you can send through AT&T in a given month. Does anyone know anything aobut this? I guess I

Hi Greetings to all Is my first post in this forum sorry for my english Many compliment to all developers for great work in Wine Profili2 is the most famous Windows software for designe airfoil profile for RC airplane models. Some times ago I have installed it in ubuntu 10.10 by Wine(1.3.5) with success This software use an mdb file First I have installed Profili download in this web site

Hi! I'm manipulating XLSX data using RODBC, however a limitation which appears to be driver based is that you can't clear or drop sheets from the XLSX files, as per the following example: > library(RODBC) > xlsx<-odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);DBQ=c:\\documents and settings\\desktop\\testxlsx.xlsx; ReadOnly=False") >

Hey Seniors, Really new to R, please has anyone imported a dataset from MS office excel 2007 into R yet? It seem to be giving me hard times which I did not expect as it use to go well with the previous versions. Thanks in advance. arnoldo --------------------------------- [[alternative HTML version deleted]]

THis is the modified script that came with tinc 1.0pre2, and it now uses ifconfig in stead of ip-route. I changed the syntax to be correct (may already have been fixedin a newer version), it now checks whether or not there is a '/dev/tapX' or a '/dev/netlink/tapX' and it checks if there is a module or not. I also added the force_connect and the reload options. Force_connect send

I have the code for computing a weekly event: (start_date..end_date).select{|d| d.wday == wday} but I am wondering if anyone has any ideas for using this to figure out a recurring event for every other week. Is it possible to somehow specify every other within the .select method? Any other implementation ideas? --~--~---------~--~----~------------~-------~--~----~ You received this message

Im wondering how to go about passing a ruby array to a javascript function. I was able to do this the other way around and pass a javascript array to an action using JSON and convert it back to a ruby array: Object.toJSON(<%= array_or_string_for_javascript(@array) %> then in the action I was able to do: ruby_array = JSON.parse(params[:array]) But this time I want to pass an array to a