similar to: SQL Changing Data Type

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