similar to: Excel files

How can I deal with missing values in the excel file? I used read.csv to imports data, how ever there are missing values in the csv file. When I use names(), it turns out a error message: " names attribute must be the same length as the vector" What can i do with the missing values? Thanks --------------------------------- [[alternative HTML version deleted]]

In R, How to read Excel file and access the data item? Thank you. --------------------------------- [[alternative HTML version deleted]]

if I want to specify y-coordinates for the heights of horizontal lines to go across a plot. x <- c(1,2,3,6,4,8,4,7) y <- c(3,2,7,4,5,4,5,6) h <- c(3,5,7) plot(x,y) abline(y=h) However I got error message: Warning message: parameter "y" couldn't be set in high-level plot() function (I tried abline(h=y) , it;s not what I want also) Do u know why?

ABCD are four matrix. A * Inverse((Transpose(A)*Tranpose(B)*B*A+C)) * Transpose(A) * Transpose(B) * D how to write in R in an efficient way? --------------------------------- [[alternative HTML version deleted]]

Hello everybody, it looks like the presense of some (do know know which) S4 methods for a given S4 class degrades the performance of xtfrm (used in 'order' in new R-devel) by a factor of millions. This is for classes that ARE derived from numeric directly and thus should be quite trivial to convert to numeric. Consider the following example: setClass("TimeDateBase",

Hello, Sorry if anyone gets this message twice, as my mailserver may not be working. Thanks for your response. Your idea makes a lot of sense to me, but I've been unable to get seconds to work. I ended up with this format finally: "2007-10-31_16:20:22" Problem is I am unable to get it recognized as a date using timeDate(): R>

For a model I am working on, I have samples organized by year and week of the year. For this model, the data (year and week) comes from the basic sample data, but I require a value representing the amount of time since the sample was taken (actually, for the purpose of the model, it is sufficient to use the number of weeks from the middle of the sample week to the present). What I have found so

Hello, I'm trying to build a for loop, where I estimate a series of models with different sets of (time series) data. However my for loop doesn't recognize the "i" ##################### code################ window.1=anomalies.CAK[(positions(anomalies.CAK)>=timeDate("1/1/1971") & positions(anomalies.CAK)<=timeDate("6/30/1991") )] ....

Anybody know how to invoke control panel applets? What I really want to do is make Wine use my default Date format that I used in Windows, but it's reverted to the goddawful American usage (with two digit years, no less). wine timedate.cpl (or wine C:/windows/system/timedate.cpl) fails with an error 193 and nothing in the log -- derek

Given S4 methods [ and [<-, how do I write the Rd-file usage clause for the latter one? What I have now is: \S4method{[}{TimeSeries,TimeDate,missing}(x, i, j, ..., drop) \S4method{[<-}{TimeSeries,TimeDate,missing,ANY}(x, i, j, ..., value) which results in the following output: ## S4 method for signature 'TimeSeries, TimeDate, missing': x[i, j, ..., drop]

Dear R Experts: I am trying to convert a date and time character field to timeDate where the month is presented as three letters, such as "JUN" for June, etc. This is an example of the full character field: "04-MAY-11 1428" What is the proper format syntax? I've tried timeDate("04-MAY-11 1428",format="%d-%m-%y %H%M") but only get GMT [1]

Hello: I am trying to use fCalendar for date arithmetic and the RMySQL package for accessing a MySQL database. The fCalendar math operations seem to work fine UNTIL I load the RMySQL package. Here is a demonstration: ean at fibonacci:~/Desktop/amCharts/rsa-metrics$ R R version 2.7.1 (2008-06-23) Copyright (C) 2008 The R Foundation for Statistical Computing ISBN 3-900051-07-0 R is free

I'm reading in ~3 years worth of data that includes hourly timestamps. Presumably to avoid DST confusion, all the data is in PST time zone -- no discontinuities in the spring or fall. The data comes in a csv file, which I'm reading with myvariable <- read.csv("my_data_file.csv",header=FALSE,

what package should I include to use timeDate? I want to convert a double (num of millis) into date object.

Dear help-list, I have a problem with timeSequence {timeDate}. When I use it like > timeSequence(from = "2008-01-01", to = "2010-12-13", by = "1 month") GMT [1] [2008-01-01] [2008-02-01] [2008-03-01] [2008-04-01] [2008-05-01] [2008-06-01] [2008-07-01] [2008-08-01] [2008-09-01] [2008-10-01] [2008-11-01] [12] [2008-12-01] [2009-01-01] [2009-02-01] [2009-03-01]

Dear all, I am writing to ask for help to find R code to do the same thing as the following Splus code: dates <- c("02/27/1992", "02/27/1992", "01/14/1992", "02/28/1992", "02/01/1992") timeDate(as.character(dates),in.format="%m/%d/%Y","%a") [1] Thu Thu Tue Fri Sat Could anyone give me some R codes to get the

Hi,all I only got the time data such as: tms<-c("19:30:23","18:39:10".....) I want to manipulate this time series data. For example, plus one second(or minute) or minus one second This data only has the time(h:m:s), without the date. I know that there are chron package, ISOPix class and the timeDate class, but all these class need the input of date. How can we

Hi, I am trying to install a bunch of packages via command line and can use some help in getting it right. My env is a freshly setup OpenSuse 11.4 on an amd desktop. I have not yet installed gcc (Will I need gcc to install packages? I have installed make, assuming R might need it.). I have tried it both under R2.12 and R2.13. I have a list of packages to install such as fImport, fGarch, zoo,

Hello, I am trying to use HMisc describe on a data frame. I have specified certain variables as dates using, for example: df1$aidsdate <- dates(aidsdate,format="day.mon.year", origin=c(month = 1, day = 1, year = 1960)) When I use describe on the dataframe I get this error: Error in Ops.dates(weights, x) : * not defined for chron objects Has anyone had this problem? I had

The prob package has been archived because it depends upon some other packages which have issues. However, such projects as Introduction to Probability and Statistics in R depend upon it for learning. There are a few other resources that also use it. Does anyone know of any workarounds? Someone at stack exchange mentioned using R 2.9. However, that broke my RStudio (WSOD) and the dependent