[ale] Anyone familiar with R?
George Allen
glallen01 at gmail.com
Tue Apr 5 09:23:26 EDT 2011
I'm trying to learn R, as well as analyze some data out of Cisco
Unified Contact Center (call center setup) for a helpdesk. UCCX has an
app that will generate reports via crystal reports into excel, but
it's cumbersome and doesn't exactly generate what I want.
So...
Have a data set like:
> head(z)
r$SESSION.ID START_DATETIME QUEUE.TIME TALK.TIME HOLD.TIME WORK.TIME
1 1-5000003350-0 2011-03-01 07:00:03 297 134 0 4
2 1-5000003351-0 2011-03-01 07:02:23 234 404 0 30
3 1-5000003353-0 2011-03-01 07:05:33 120 214 0 30
4 1-5000003356-0 2011-03-01 07:09:32 137 229 0 30
5 1-5000003358-0 2011-03-01 07:12:49 69 577 0 30
6 1-5000003360-0 2011-03-01 07:21:38 29 288 0 30
and I want to do something like:
subset(z, z$START_DATETIME >= as.POSIXlt('2010-03-01') |
z$START_DATETIME <= as.POSIXlt('2010-03-07'), "START_DATETIME")
to pull one week's worth of data, but instead it dumps the whole dataframe.
Ultimately, I want to do this:
hist(z[z$START_DATETIME >= as.POSIXct('2010-03-01') | z$START_DATETIME
<= as.POSIXct('2010-03-07'), "START_DATETIME"], 'hours', freq=TRUE)
and have it dump only that first week, currently it does the whole set...
More information about the Ale
mailing list