Displaying 4 results from an estimated 4 matches for "roomsinus".
Did you mean:
roomsinuse
2011 Jun 24
2
SQL Changing Data Type
...19 : 79 Mean : 4.195
3rd Qu.:2011-05-07 20 : 76 3rd Qu.: 7.000
Max. :2011-05-31 7 : 75 Max. :20.000
(Other):377
> #merge raw data and all possible combinations
> df.final <- sqldf('select Date, Hour, x as RoomsInUse from
> "df.aggregate"
+ left join "df.possible.combos" using (Hour, Date)')
> summary(df.final)
Date Hour RoomsInUse
15069.0: 16 16 : 82 Min. : 1.000
15114.0: 16 17 : 82 1st Qu.: 1.000
15063.0: 15 18 : 82 M...
2010 Nov 02
1
class changed after execution with sqldf
...16 Median :11.50
Mean :2010-08-16 Mean :11.50
3rd Qu.:2010-09-08 3rd Qu.:17.25
Max. :2010-09-30 Max. :23.00
> class(df.possible.combos$Date)
[1] "Date"
> #merge raw data and all possible combinations
> df.final <- sqldf('select Date, Hour, x as RoomsInUse from
> "df.possible.combos"
+ left join "df.aggregate" using (Hour, Date)')
> summary(df.final)
Date Hour RoomsInUse
14791.0: 24 Min. : 0.00 Min. : 0.00
14792.0: 24 1st Qu.: 5.75 1st Qu.: 1.00
14796.0: 24 Median :...
2010 Nov 01
1
sqldf hanging on macintosh - works on windows
...SQLite
Loading required package: RSQLite.extfuns
Loading required package: gsubfn
Loading required package: proto
Loading required package: chron
I then read some data, etc.
I execute the following:
#merge raw data and all possible combinations
df.final <- sqldf('select Date, Hour, x as RoomsInUse from
"df.possible.combos"
left join "df.aggregate" using (Hour, Date)')
I receive the messages:
Loading required package: tcltk
Loading Tcl/Tk interface ...
+
Then I get into some kind of loop. Message at bottom ribbon says:
executing:
try(gsub('\\s+','...
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 = 0.5,
cex.axis=0.5,data=df.final,as.table=TRUE,
layout=c(2,3))
--
View this message in context: http://r.789695.n4...