Displaying 20 results from an estimated 200 matches similar to: "Is this a documentation bug? Spss dates import"
2006 Oct 20
1
Questions about date/time and truncating
I'm getting a weird behavior using R 2.5.0 for MacOS X -- I have a csv file
with a "properly formatted" date/time field, e.g. After reading in the csv
to "hourly_met_data", with a "date" field
hourly_met_data$date <- as.POSIXct(hourly_met_data$date)
works exactly as it is supposed to (e.g. Min/max of that field are
calculated correctly). However, when I
2007 Aug 04
2
Problems using "lm" in combination with "predict"
Hello everybody,
I'm trying to predict a linear regression model but it does not work.
My Model: y = Worktime + Vacation + Illnes + Bankholidays
My modelmatrix is of dimension 28x4
Then I want to make use of the function predict because there confidence.intervals are include.
My idea was:
mod <- lm(y~Worktime+Vacation+Illnes+Bankholidays)
newdate=data.frame(x=c(324,123,0.9,0.1))
2006 Nov 04
0
weird problem with content type
Hey all,
My site is working ok except for a page that displays as text instead of html.
I tried to use this:
puts "Content-Type: text/html"
then it display the page as html normally but I still get that ugly
part on top of my page:
Content-Type: text/html
Set-Cookie: _session_id=6356b18a24d56a0da01bfab791fa911d; path=/
Status: 200 OK
Cache-Control: no-cache
here is the url:
2023 Nov 03
1
Sum data according to date in sequence
Is this what you are after?
library(tidyverse)
library(lubridate)
input <- structure(list(StationName = c("PALO ALTO CA / CAMBRIDGE #1",
"PALO ALTO CA / CAMBRIDGE #1", "PALO ALTO CA / CAMBRIDGE #1",
"PALO ALTO CA / CAMBRIDGE #1", "PALO ALTO CA / CAMBRIDGE #1",
"PALO ALTO CA / CAMBRIDGE #1", "PALO ALTO CA / CAMBRIDGE
2004 May 26
2
Subtracting number of days from a date
Hi group,
suppose I have a date, say May 15 2004, and I want to now what date it is 23 days before that date. The way to calculate the new date should (...) take account of leap years :)
In pseudocode:
olddate <- "May 15 2004"
newdate <- olddate-23
I looked around in POSIXct etc..., maybe I overlooked?
Thanks,
Maarten
2009 Mar 08
2
plot confidence limits of a regression line - problem
hi,
I don't know what I am doing wrong,
but with that code;
x1 <- c(1.60, 0.27, 0.17, 1.63, 1.37, 2.00, 0.90, 1.07, 0.89, 0.43,
0.37, 0.59,
0.47, 1.83, 1.79, 0.90, 0.72, 1.83, 0.23, 1.97, 2.03, 2.19, 2.03, 0.86)
x2 <- c(1.30, 0.24, 0.20, 0.50, 1.33, 1.87, 1.30, 0.75, 1.07, 0.43,
0.37, 0.87,
1.40, 1.37, 1.63, 0.80, 0.57, 1.60, 0.39, 2.03, 1.90, 2.07, 1.93, 0.93)
model <-
2013 Jan 18
2
A smart way to use "$" in data frame
Hello all,
I have a data frame dataa:
newdate newstate newid newbalance newaccounts
1 31DEC2001 AR 1 1170 61
2 31DEC2001 VA 2 4565 54
3 31DEC2001 WA 3 2726 35
4 31DEC2001 AR 3 2700 35
The following gives me the balance of state AR:
2006 Jul 06
6
Help with overriding / overwriting date values in ActiveRecord to accept Euro Style Date from a Textbox
Hi guys,
I''m trying to make an AR model which accepts a string data (from a
text input) in euro date format
eg
<input .... value = "23/01/2006"> ( 23 Jan 2006)
Reading the example from RDoc... i tried to
overwrite/overload/override the = function to write in the date..
Cant get it to work because .. i dont knoe what format should it
accept.. i''ve tried
2006 May 21
1
POSIX, time zone and Windows
Dear Listers,
Apologize to pile up on the 'tz' issue in POSIX objects. I have a
'simple' thing on which I must make up my mind but cannot do it from the
existing R-help threads. I am currently working on dog telemetry in
China, and download time information from GPS collars. I would like to
set up the corresponding POSIXxx variables in R to a given time zone. Eg
Pekin
2011 Apr 18
1
using "aggregate" when variable names contain spaces
Hello!
my data set has many variables. Unfortuantely, many of those variables
contain spaces in their names.
I need advice on: how to refer to variable names in the formula for
"aggregate". See example below:
### Generating example data set:
mydate = rep(seq(as.Date("2008-12-01"), length = 3, by = "month"),4)
value1=c(1,10,100,2,20,200,3,30,300,4,40,400)
2009 Oct 06
2
Extracting year from a date object
Hi all,
this one left me a bit puzzled, as I don't seem to find a function to
perform this easily. I must have overlooked the obvious, so sorry in
advance.
I have a list of dates in numerical format (i.e. 34576), defined as
the number of days that passed since january 1st 1900. So I apply the
function :
> MyDate <-as.Date(34576,origin="1900-01-01")
> MyDate
[1]
2011 Jul 14
2
cbind in aggregate formula - based on an existing object (vector)
Hello!
I am aggregating using a formula in aggregate - of the type:
aggregate(cbind(var1,var2,var3)~factor1+factor2,sum,data=mydata)
However, I actually have an object (vector of my variables to be aggregated):
myvars<-c("var1","var2","var3")
I'd like my aggregate formula (its "cbind" part) to be able to use my
"myvars" object. Is it
2011 Mar 01
2
Does POSIXlt extract date components properly?
I would like to use POSIX classes to store dates and extract components of
dates. Following the example in Spector ("Data Manipulation in R"), I
create a date
> mydate = as. POSIXlt('2005-4-19 7:01:00')
I then successfully extract the day with the command
> mydate$day
[1] 19
But when I try to extract the month
> mydate$mon
[1] 3
it returns the wrong month. And
2011 Oct 27
1
plotting large time series
hello,
I got a problem with plotting large time series, since I want to store
the results in a .PDF file (I want to store several pages of plots). The
PDF files get too large to be handled (> 10MB, one was even 200MB big).
So I wonder, if there would be a possibilty to either
- reduce the file size of the PDF
- change the way the plot is generated to reduce the plot size?
I use:
2007 Feb 09
0
as.Date() behaviour when incomplete input string
Dear all,
I would like to know the month on a string formatted as "2004-01", using as.Date
(not just stripping the string !)
?as.Date says that in case of an incomplete input string, the answer is
system-specific.
The following has been tested on R 2.4.1, on Ubuntu Linux and WinXP.
> mydate <- "2004-01"
> as.Date(mydate)
Error in fromchar(x) : character string is
2011 Apr 04
2
merging 2 frames while keeping all the entries from the "reference" frame
Hello!
I have my data frame "mydata" (below) and data frame "reference" -
that contains all the dates I would like to be present in the final
data frame.
I am trying to merge them so that the the result data frame contains
all 8 dates in both subgroups (i.e., Group1 should have 8 rows and
Group2 too). But when I merge it it's not coming out this way. Any
hint would be
2013 Apr 02
2
Create a vector without using an external 'if statement'
Dear R-users,
suppose I have three dataframes like these
df1:
mydate min_temp
31032013 12
01042013 8
02042013 -999
df2:
mydate min_temp
31032013 10
01042013 11
02042013 14
df3:
mydate min_temp
31032013 4
01042013 3
02042013 5
where -999 means that the temperature data is not available (at the moment I cannot change it to NA because I am not the db administrator);
suppose also that oggi is
2011 May 19
1
Creating a "shifted" month (one that starts not on the first of each month but on another date)
Hello!
I have a data frame with dates. I need to create a new "month" that
starts on the 20th of each month - because I'll need to aggregate my
data later by that "shifted" month.
I wrote the code below and it works. However, I was wondering if there
is some ready-made function in some package - that makes it
easier/more elegant?
Thanks a lot!
# Example data:
2009 Aug 28
2
new data.frame summed by date
Hi,
I wonder if someone can suggest how to create a new data.frame Y
from X where X$PL_Pos is summed by each unique X$MyDate. Y should end
up with two (or more) columns Y$MyDate and Y$PL_Sum with its value
being the cumsum of all the values in X for that date. - a 'daily
cumsum'.
Thanks,
Mark
TStoDate = function (TSDate) {
X = strptime(TSDate + 19e6L, "%Y%m%d")
2009 Jan 21
1
finding row and column indices of date in multiple columns of a data frame
Hi,
I have a data.frame SAMPLES with columns:
Site Site# Season Day1 Day2 Day3
Day1, Day2, Day3 are class "Date", the other columns are numeric or
factor.
I have a date "mydate" that may or may not be listed in my data.frame
and I need to find that out.
If "mydate" is there, I want to get the number of the data.frame row
where it occurs.