Coey Minear <cminear <at> securecomputing.com> writes:
>
> I have been trying to use R to gather some information from parsed log
> files (as part of examining some performance issues). I parsed the
> log files and put the data into an SQLite database, and then used
> RSQLite to load the data into R. The fields of interest are
> controller, action and total_time: controller and action have string
> values; total_time has a decimal value.
>
> I first did the following box plot to find the problem controllers.
> boxplot(total_time ~ controller, all_data)
>
> Having identified one controller of interest (let's say
> "BadController"), I then wanted to then focus on the actions
> associated with that controller. So I did this:
> boxplot(total_time ~ action, subset(all_data, controller ==
> "BadController"))
>
> This gave me a plot I was expecting: just the actions which are
> associated with "BadController". However, I'd done this work on a
> FreeBSD system, and then I wanted to print it, and the easiest means
> seemed to re-plot using R on Windows. So I wrote the data to a file,
> moved it to Windows and loaded it up there.
>
> On FreeBSD:
> write.table(all_data, "datafile.R")
>
> On Windows:
> all_data <- read.table("datafile.R")
>
I'm guessing that you want
bad <- subset(all_data,controller=="BadController")
bad$action <- factor(bad$action)
boxplot(total_time ~ action)
Subsetting doesn't drop factor levels that don't
occur, which is an unfortunate design decision ...
Ben Bolker
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
