Displaying 20 results from an estimated 600 matches similar to: "SQL Changing Data Type"
2010 Nov 01
1
sqldf hanging on macintosh - works on windows
Have a long script that runs fine on windows (32 bit). When I try to run in
on two different macs (64 bit), however, it hangs with identical behavior.
I start with:
library(sqldf)
This results in messages:
Loading required package: DBI
Loading required package: RSQLite
Loading required package: RSQLite.extfuns
Loading required package: gsubfn
Loading required package: proto
Loading required
2010 Nov 02
1
class changed after execution with sqldf
When I run sqldf to merge two datasets, it's changing the Date (class date)
to a numeric value (class factor). Not sure why. Appreciate any insight.
Console output for two datasets and the merged dataset (via sqldf) listed
below.
> summary(df.aggregate)
Date Hour x
Min. :2010-07-01 0 : 64 Min. : 0.00
1st Qu.:2010-07-25 1 :
2011 Dec 08
1
bwplot title size
Using the statement below to draw a plot. The title size doesn't seem to
change regardless of what value I put in for cex.main. How do I reduce the
size of the title?
#print distributions by Month
bwplot(RoomsInUse ~ Hour | Month, scales=list(x=list(rot=90)),
horizontal=FALSE,las=2,main=title,sub=tag,xlab="Hour of Day",
ylab="Rooms Running",cex.sub = 0.5, cex.main =
2006 Dec 14
5
Nicely formatted tables
If I use latex(summary(X)) where X is a data frame with four
variables I get something like
Rainfall Education Popden Nonwhite
Min. :10.00 Min. : 9.00 Min. :1441 Min. : 0.80
1st Qu.:32.75 1st Qu.:10.40 1st Qu.:3104 1st Qu.: 4.95
Median :38.00 Median :11.05 Median :3567 Median :10.40
Mean :37.37 Mean :10.97 Mean :3866
2011 Aug 18
1
Loop trouble with Excel Serial Numbers!
Hi All!
I'm trying to convert serial numbers in Excel to dates in R. For each
single "thedate" entry, I get a correct answer. But if I try using the for
loop, I get bizarre numbers in "mynewdata".
thedate<-as.matrix(40548:40759,ncol=1)
exdate<-function(){
mynewdate<-NULL
for(i in 1:nrow(thedate)){
2006 Apr 25
5
millisecond precision over internet
Hi,
I''m new to programming and ruby and ROR, but I''m hoping to learn ruby to
create custom scientific software.
Mainly it involves measuring people''s reaction time to a series of
words.
I''m positive that this is possible using plain ruby on a computer (cause
this is BASIC territory right?). But I want to create a ROR app that can
do the same thing. My
2004 Nov 11
2
RODBC & POSIX & Daylight Saving blues
Dear All,
The recent improvement in RODBC to recognize datetimes in tables has
exposed my ongoing confusion.
All my data are obtained from a satellite system (Argos) which tags events
in the GMT time zone. Daylight saving is ignored. To my way of thinking
this means that
1. twelve-o-clock means halfway through the day regardless of season, and
2. the difftime of any two dates where
2001 Feb 28
1
print()
Hi, I've two questions. Please help me. Thanks!
--- Question (1) ---
When I type: print("School Name")
the output is: [1] "School Name"
How to get rid of the '[1]' and the double quotes ""
and make the output like this: School Name
--- Question (2) ---
I got the following output by typing "summary(data)".
dstuser dstmethod
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 Jul 26
2
How to use as.Date (or something else) with "31-Jul-2010 23:59:00"
Hello
I have a huge file (not an R-file) in which the first column is a string
with date, hour, minutes and seconds (For instance, "31-Jul-2010 23:59:00").
I tried as.Date but the error msg was "Error in charToDate(x) :
character string is not in a standard unambiguous format".
I have checked the help for the function as well as date but to no avail.
How can that sort
2012 Jun 13
1
How to calculate the statistcs for extracted region?
I have a binary file(a) with size of (360 720 )for the globe.I wrote the code
given below to read and extract an area (south america)from that file. when
I use summary for the whole file I got:
summary(a, na.rm=FALSE)
Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
0.00 1.00 3.00 4.15 7.00 20.00 200083 .
But when I used summary for the region(b) which I extracted, I got
2013 Apr 11
2
Read the data from a text file and reshape the data
I have a data set for different time intervals. The data has three comment
lines before data for each time interval. For each time interval there are
500 data points. I want to change the dataset such that I have the following
format:
t1 t2 t3 ................
0.00208 0.00417 0.00625 .................
a1 a2 a3 ...................
2008 Dec 22
2
Treatment of Date ODBC objects in R (RODBC)
Dear all,
Retrieving an Oracle "Date" data type by means of RODBC (version
1.2-4) I get different classes in R depending on which operating
system I am in:
On MacOSX I get "Date" class
On Windows I get " "POSIXt" "POSIXct" class
The problem is material, as converting the "POSIXt" "POSIXct" object
with as.Date() returns one
2006 Jan 30
1
weights argument in the lmer function in lme4
I suspect the weights argument is not having any effect.
Package: Matrix
Version: 0.995-2
Date: 2006-01-19
Beginning with this:
Browse[1]> resp.lmer <- lmer(SensSSC ~ Block + Season + (1 | Plot) + (1 | Ma) + (1 | Pa) +
+ (1 | MaPa), weights = SensSSC.N, data = xx)
I group the output into a table with my ran.eff function and get this:
2011 Oct 14
2
non-parametric permutation and signed paired-difference distributions
Hi all
Consider the classic data below from Darwin on the heights of 15 pairs
of zea mays (corn) plants
either cross-fertilized or self-fertilized, where the goal is to see if
it makes a difference.
> head(ZeaMays)
pair pot cross self diff
1 1 1 23.500 17.375 6.125
2 2 1 12.000 20.375 -8.375
3 3 1 21.000 20.000 1.000
4 4 2 22.000 20.000 2.000
5 5 2 19.125
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
2012 Jun 07
1
factor coercion with read.csv or read.table
How do I fix this error ? I tried coercion to a vector but that didn't work.
msci <-read.csv("..MSCIexUS.csv", header=TRUE)
head(msci)
Date index
1 Dec 31, 1969 100
2 Jan 30, 1970 97.655
3 Feb 27, 1970 96.154
4 Mar 31, 1970 95.857
5 Apr 30, 1970 85.564
6 May 29, 1970 79.005
> str(msci)
'data.frame': 510 obs. of 2 variables:
$ Date : Factor w/ 510
2017 Jun 22
2
For loop
Hello R users,
The code below is for loop in R that I want to do to following
calculation at each time i and i-1 in 2:75 dataset
(Litterfall_Ahmed97).
ac = ((LeafBiog at date i
-LeafBiog at date i-1, dataset = leafbiom97) + (littperiod at date i,
dataset= Litterfall_Ahmed97))/(sum (GPP from date i-1 to date i,
dataset=GPP_Ahmed13)/2) .
#code for loop
GPP_Ahmed13$Date <-
2013 Jul 24
5
Alert Email
anyone knows if is possible to create an email alert to notify me when a mount point is connecting and disconnecting?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.xiph.org/pipermail/icecast/attachments/20130724/b45e9502/attachment.htm
2013 Jul 24
2
Alert Email
It looks like those are bash scripts so try something like
be sure your mail binary path is correct it may be somewhere else other
then /bin
echo "/bin/mail -s connecting someone at somewhere.com" >
/home/icecast/bin/source-start
chmod 775 /home/icecast/bin/source-start
you may have a chown permissions issue too if the user that runs icecast
can't see the