Displaying 20 results from an estimated 7000 matches similar to: "Calculate Averages for time data"
2009 Nov 15
1
Presentation of data in Graphical format
Hello
My data contains following columns:
1st column: Posts (GM, Secretary, AM, Office Boy)
2nd Column: Dept (Finance, HR, ...)
3rd column: Tasks (Open the door, Fix an appointment, Fill the register,
etc.....) depending on the post
4th column: Average Time required to do the task
So the sample data would look like
Posts Dept Task Average
2009 Nov 18
1
Need help for graphical representation
Hello
I am unable to find a graph for my data, My data contains following columns:
1st column: Posts (GM, Secretary, AM, Office Boy)
2nd Column: Dept (Finance, HR, ...)
3rd column: Tasks (Open the door, Fix an appointment, Fill the register,
etc.....) depending on the post
4th column: Average Time required to do the task
So the sample data would look like
Posts Dept
2009 May 14
2
Importing data into R and combining 2 files
Hello
I have to import 2 txt files into R. 1 file contains the data and the other
contains the header, column headings, datatypes and labels for the data.
I have 2 problems:
1) my data file has mixed type of data e.g. 1 2 3 4 5 3-5 02/04/06 3 4 5 and
so on, the data file is tab separated. when I import it, the data is getting
stored in one single variable say V1. I need to separate it into rows
2010 Mar 22
3
Mosaic Plots
Hello Everyone
I want to plot Moasic Plots, I have tried them using iplots package (using
imosaic). The problem is the names dont get alligned properly, is there a
way to a align the names and provide legend in Mosaic plots using R?
Also I would like to know any other packages using which I can plot Mosaic
Plots
Thank you in advance
Sunita
--
View this message in context:
2009 May 24
2
Assigning variable names from one object to another object
Hello
I have 2 datasets say Data1 and Data2 both are of different dimesions.
Data1:
120 rows and 6 columns (Varname, Vartype, Labels, Description, ....)
The column Varname has 120 rows which has variable names such id, age,
gender,.....so on
Data2:
12528 rows and 120 columns
The column names in this case are V1, V2, ......... V120 (which are default
names in R when we say head=F in read.csv)
2009 Dec 10
1
barplot and cumulative curve using ggplot2 layers
Hello
My dataset is as follows:
jobno recruits
1100 18
1200 1
1850 5
2100 190
2789 25
3000 1
. .
. .
the dataset has 130 rows
I want to plot barplot from left side and cumulative curve from right side
in one graph itself using layers in ggplot2.
I sorted the recruits 1st in decreasing order
2009 Sep 01
1
Re gression - cluster option in STATA
Hello
In STATA there is command which has regression with clustering option. Can
anyone tell me what is the command for the same in R
for example in STATA
its regress Height Weight, cluster(id)
Thanks in Advance
Regards
Sunita
--
View this message in context: http://www.nabble.com/Regression---cluster-option-in-STATA-tp25241948p25241948.html
Sent from the R help mailing list archive at
2010 Feb 09
1
Bar plot
Hello
(this might be a very simple question)
My data is as follows (table name is student)
Year StudentsPassed
1 2000 300
2 2001 360
3 2002 450
4 2003 450
5 2004 270
6 2005 280
7 2006 400
8 2007 270
I want to plot a barplot so for this
If I use barplot(students) it says "Error in barplot.default(students) :
'height' must be a vector or a
2010 Feb 16
3
converting character vector "hh:mm" to chron or strptime 24 clock time vectors
Hi All,
I am attempting to work with some data from loggers. I have read in a
.csv exported from MS Access that already has my dates and times (in 24
clock format), (with StringsAsFactors=FALSE).
> head(tdata)
LogData date time
1 77.16 2008/04/24 02:00
2 61.78 2008/04/24 04:00
3 75.44 2008/04/24 06:00
4 89.43 2008/04/24
2007 Nov 17
2
Getting Annual (Conditional) Averages
Hello,
I'm very new to R, and so my question is simple.
I have data record with 80 years of daily temperatures in one long
string. The dates are also recorded, in YYMMDD format. I'd like to
learn an elegant simple way to pull out the annual averages.
(Obviously, every 4th year has 366 days.)
I know I can set up a formal loop to create annual records and then
average. But R
2009 Nov 24
1
Convert Time Variable to Numeric
Hello Everyone
I am new to R
I would like to know how to deal with Time Variable. If I have a column of
containing Time data in the format of hh:mm:ss such as 00:56:45, 01:24:36,
01:41:25, and so on......
I could find averages for this column using the Chron package. But now I
need to plot a graph so I need to convert this Time variable to numeric.
My data is as follows:
Activity
2011 Oct 27
2
Simple time series question with zoo
New user here. My goal is pull daily averages from a long dataset.
I've been working with some code I got from this list from
https://stat.ethz.ch/pipermail/r-help/2009-March/191302.html
The code how I have been using it is as follows:
library(zoo)
library(chron)
DB<-read.table("/Users/me/Desktop/R/data.csv", sep=",", header=TRUE, as.is
=TRUE)
z<-zoo(LTER6$temp,
2009 Sep 09
2
Help with data containing date
Hello Everyone,I think this is a very simple problem, I have been struggling
with it for a few days now.
I have a 10-year daily data in the following format.
Date A B C D E
1978-10-22 18 20.64 0.0 0.176 -1.76
1978-10-23 15 17.06 0.4 0.147 2.52
1978-10-24 3 7.588 0.0 0.068 -6.86
1978-10-25 9 11.491 0.0 0.102
2009 Jul 16
1
Calculate Timeseries Interval
Hello,
I have been attempting to write a script that automatically calculates time
intervals from a list of hh.mm.ss.ms timestamps. Should be easy, but I keep
running into problems. Any help would be greatly appreciated!!
Problems:
1. If I parse the timestamp, it doesn't always return the digits after the
decimal
2. If I subtract .5 - .955 (as in 19:22:0.5 - 19:21:59.955), then I get a
2011 Jul 28
3
how to shift a chron timestamp by 6:30 hours
Dear help list,
I have a timestamp in as a chron object:
> (x <- chron(dates = c("12/02/11", "22/11/11"),
+ times = c("07:30:00", "04:00:00"),
+ format = c(dates = "d/m/y", times = "h:m:s")))
[1] (12/02/11 07:30:00) (22/11/11 04:00:00)
Now I want to shift the timestamp by 06:30 (hh:mm) backwards, to get
2004 May 12
1
convert.times in chron, error when 59 < seconds < 60 (PR#6878)
Full_Name: Dennis Wolf
Version: 1.9.0
OS: Mac OS 10.3.3
Submission from: (NULL) (160.91.76.23)
platform powerpc-apple-darwin6.8
arch powerpc
os darwin6.8
system powerpc, darwin6.8
status
major 1
minor 9.0
year 2004
month 04
day
2010 Jun 18
5
extract date time from a text file
I a have a text file where every line is like that:
"2007-12-03 13:50:17 Juan Perez"
("yy-mm-dd hh:mm:ss First Name Second Name")
I would like to make a data frame with two column one for date and the
other one for name.
When I use read.delim it was transformed in a data frame with 4 colums.
Bye,
Sebasti?n.
2009 Jul 16
6
Best way to replace :SS with :00
Not sure if there is an R way to do this or a regular express way, but here is what I am trying to do.
I've got lots of data where the format is HH:MM:SS, but I need to format it like HH:MM:00, i.e. round the second down to zero.
What is the best way to do this?
Thanks again.
Jason
2010 Oct 25
4
zoo.read intraday data
Hello all,
I'm trying to use zoo.read but can't figure out
how to deal with the time format. (example below)
would be nice if someone could help.
best regards,
Immanuel
---------------------------
L <- "Date,Time,Open,High,Low,Close,Up,Down
05.02.2001,00:30,421.20,421.20,421.20,421.20,11,0
05.02.2001,01:30,421.20,421.40,421.20,421.40,7,0
2005 May 21
2
print format for difftime
Has anyone written a function that will print a difftime in the form:
hh:mm:ss
or
yy-mm-dd hh:mm:ss
depending on the actual size.
(sloppy notation for months/minutes, but surely you get the point).
Bendix
----------------------
Bendix Carstensen
Senior Statistician
Steno Diabetes Center
Niels Steensens Vej 2
DK-2820 Gentofte
Denmark
tel: +45 44 43 87 38
mob: +45 30 75 87 38
fax: +45 44 43 07