search for: roomsinuse

Displaying 4 results from an estimated 4 matches for "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 Me...
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 :1...
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....