Displaying 20 results from an estimated 4000 matches similar to: "How to use as.Date (or something else) with "31-Jul-2010 23:59:00""
2011 Jul 17
3
How to convert number (matlab) to date
Hello
I am new to R and I need to convert some dates (numeric format by matlab) to actual dates in R.
For instance,
Matlab -> 730456 -> >> datestr(730456)
ans =
02-Dec-1999
R -
> library(zoo)
> as.Date(730456)
[1] "3969-12-03"
I don't not mind the output format but it needs to be right.
Many thanks
Ed
2013 Jun 26
3
XYZ data
I have x, y, z data. The x, y fields dont change but Z does. How do I add a
very small number onto the end of each x, y data point.
For example:
Original (X) Original (Y) Original (Z)
15 20 30
15 20 40
New (X) New (Y)
2011 Dec 21
1
Gps fraction of degrees function
Dear all, I have the following written example
> coords <- "51°30'48.58\"N"
>
> as.integer(strsplit(coords, "°")[[1]][1])
[1] 51
> as.integer(strsplit(strsplit(coords, "°")[[1]][2], "'")[[1]][1])
[1] 30
> as.numeric(strsplit(strsplit(strsplit(coords, "°")[[1]][2], "'")[[1]][2],
2011 Dec 27
2
importing NPDB
Does anyone have information about using the National Practitioner Data Bank (NPDB) in R? It's public use data available from the U.S. Department of Health and Human Services that can be downloaded as a .dat or .por file. I can't even figure out how to open the file in R.
[[alternative HTML version deleted]]
2011 Feb 10
3
Finding length of unique numbers in a vector
Hello there, would you please look into my codes? Here I have following:
> set.seed(100)
> samp <- sample(c(1,-1,0), 20, replace=T); samp
[1] 1 1 -1 1 -1 -1 0 -1 -1 1 -1 0 1 -1 0 0 1 -1 -1 0
Here I want to calculate the length of each unique number for above vector.
How can I do that?
Thanks in advance
[[alternative HTML version deleted]]
2012 Apr 19
1
SmoothTrend in OpenAir
I'm trying to plot smooth trend using smoothTrend in OpenAir but I'm having
problems.
I used the following code.
---------------------------------------------------------------------------------
#Set my working dir to the dir with my files
setwd("c:/R")
#Load the openair library
library(openair)
#Load the data
mydata <- read.table("MCNP-pH.csv", header=TRUE,
2013 Feb 20
3
NLS results different from Excel -- Tricky fortunes nomination
Folks:
I thought the following excerpt from Bruce McCullough's post would be
a good candidate for the R fortunes package -- except that it's about
Excel, not R! So I nominate it... but leave it to others to say
whether it's really "qualified" to be nominated.
----
"The idea that the Excel solver "has a good reputation for being fast
and accurate" does not
2011 Mar 23
2
mean of runoff for several years
Hello everyone
I have a dataframe with 4 colums (year, month, day, runoff) for 1993-2009.
Now I like to calculate the average runoff for each day. Finally I like to
plot the median runoff for all this years.
I tried with some loops, but it didn't work. Do you have any Tips for my
problem?
Any help is greatly appreciated! Thank you very much.
Dominique
--
View this message in context:
2010 Oct 15
1
Dealing with Non-Standard Hours
A data set I obtained has the hours running from 01 through 24
rather than the conventional 00 through 23. My favorite, strptime,
balks at hour 24.
I thought it would be easy to correct but it must be too late on
Friday for my brain and caffeine isn't helping.
TIA for a hint,
Clint
--
Clint Bowman INTERNET: clint at ecy.wa.gov
Air Quality Modeler INTERNET: clint at math.utah.edu
2011 May 10
2
need to delete by time, not date
I have a matrix where one column has a date and another column has a time. I
need to delete all times before 6am. I had combined the Date and Time column
into DateTime.
Mat1:
Weight Date Time
7.6 04/28/11 09:03
8.4 04/29/11 03:11
8.6 04/29/11 05:32
8.6 04/29/11 09:53
1.4 05/01/11 19:52
I tried just picking up the time:
as.POSIXct(Mat1$Time, format = "%H:%M")
but
2011 Nov 01
4
round up a number to 10^4
Hi all,
I have a list of numbers, e.g., X = c(60593.23, 71631.17, 75320.1), and want
to round them so the output is Y = c(60000, 80000, 80000). I tried
Y<-round(X,-4), but it gives me Y = c(60000, 70000, 80000). Do anybody know
how to round up a number to 10^4?
Thank you in advance.
Wendy
--
View this message in context:
2011 Jun 01
2
Problems Dating....
I'm trying to convert a column in a data frame with dates from a
"Factor" type to a "Date Object" but I am encountering and error. (I am
having trouble plotting an x,y scatter and I suspect it's something with
my data format). I have a table with two columns and 8,000 rows.
> dsort=read.delim("C:\\Documents and Settings\\E066582\\My
2011 May 05
2
Compiling a FORTRAN program under Windows 7
Hi,
I am trying to compile a FORTRAN program to call from R under Windows 7 but
I am having problem in the compiling step. To demonstrate this is the
program testit.f:
------------------------------------------
subroutine TESTIT(x,n,m)
dimension x(n)
do 10 i=1,n
10 x(i)=x(i)**m
end
--------------------------------------------
When I compile it with gfortran I get
2013 Mar 05
1
Reading Wyoming radiosonde data files with RadioSonde package
Hi,
I need to do some analysis on historic daily radiosonde data I download
from the Wyoming Univ. web page (
http://weather.uwyo.edu/upperair/sounding.html).
I am trying to use the RadioSonde package (V 1.3), but the format of the
files from Wyoming don't match what RadioSonde is expecting.
Has anyone used the Radiosonde package on the Wyoming data?
Here is a sample of the Wyoming file
2011 Jul 19
2
timeDate with month designated by three letters.
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]
2004 Jun 16
3
Aggregating on Water Year Rather Than Calendar Year
The US water year extends from 01 October yyyy-1 through 30 September yyyy
and is referenced by the year starting on the included 01 January yyyy.
I'd like to be able to find the annual means for the water year. To do so
I've taken the input date-time, which is in the usual format
"1991-10-07 10:35:00"
changed it by:
w$d<-as.POSIXct(w$date.time)
Now I can add an
2013 Feb 06
2
R for Windows 32-bit mode versus 64-bit mode
Hi All:
We are developing (actually updating) a piece of code that runs in R. Due to some limitations of some the libraries we use, at the present time we would be limited to the 32-bit version of R on Windows. Does anyone have a feel (or even real knowledge) if most people these days run R on Windows in 32-bit or 64-bit mode? This would affect some development decisions.
Thanks
-Roy M.
2011 Jun 24
2
SQL Changing Data Type
Passing in two dates to a sql statement (sqldf). Is returning a factor. Tried
setting back to a Date via as.Date, but get an error the error: character
string is not in a standard unambiguous format. Any thoughts appreciated.
Code/Results listed below:
> summary(df.possible.combos)
Date Hour
Min. :2011-03-01 Min. : 0.00
1st Qu.:2011-03-23 1st Qu.: 5.75
2011 Nov 09
6
Web based R-help not a list
Hello,
Is there a web version of this R-Help user group (such as
the ones under Google Groups) such that
1. I can do a search on any topic over thousands of posts on R easily
and effectively
2. My mailbox do not overflow with emails so that I do not need to
edit it every day
3. I can arrange to receive only the responses to my posts
automatically
4.
2010 Dec 10
1
importing date vector with read.table
Hi,
I understand this should be an easy task but I am still struggling a bit to
read a .txt file with a date vector. My code is as below:
data<-read.table(file.choose(),header=TRUE,sep="\t",dec=",",colClasses=c("Date","numeric","numeric","numeric"))
But I am getting an error:
Error in charToDate(x) :
character string is not in a