How would I analyse data like this?
Laurent - Good for you for figuring out scan(). For hist(), append one more number to "breaks" that's guaranteed to be above all the data values. (In the return value from hist(), "breaks" has n+1 entries when the histogram has n bars, and it's a good guess that input=output.) For example: hist(data[[5]], br=c(50*(seq(11)-1), 1000, 1+max(data[[5]]))) For counting, try the function table(). eg: table(data[[3]], data[[6]]) table(data[[3]], data[[7]], data[[6]]) - tom blackwell - u michigan medical school - ann arbor -
On Wed, 19 Mar 2003 laurent.duperval at microcell.ca wrote:
Hello,
I'm a new R user and I'm having a little trouble getting started. I'm hoping
someone can help me out.
I have data that looks like this:
phone|state|code|amount|left|channel|time|mtd
15555551234|3|983|1000|266|IN|2003-03-16 23:57:21-05|C
15555552345|3|983|3000|0|IN|2003-03-16 23:58:16-05|C
15555552346|3|983|1000|40|IN|2003-03-16 23:58:24-05|C
Which I've read using scan().
data <- scan(file = "data.dat", what = list("",0,0,0,0,"","",""), sep = "|", skip = 1)
Now, I want to do things like this:
- A histogram for the 5th column for every 50 units. I can generate the
histogram but most of my values are between 0-500. A few are above that.
I'd like to bundle them all in a generic 500+ category. I can't figure out
how. This is what I'm doing
hist(data[[5]], br=c(0,50,100,150,200,250,300,350,400,450,500,1000))
Error in hist.default(data[[5]], br = c(0, 50, 100, 150, 200, 250, 300, :
some `x' not counted; maybe `breaks' do not span range of `x'
- How do I count the number of times channel "IN" occurs with code = 983? How about if
I want to combine IN and code=983 or 982 or 981?
- Finally (for today at least) how do I count the number of times code=983 and
date=2003-03-16 (without the time) occur. I'm hoping this will also help
me build histograms for days of the week and for hours of the day.
Thanks,
L
--
Laurent Duperval <laurent.duperval at microcell.ca>
ZYMURGY'S FIRST LAW OF EVOLVING SYSTEM DYNAMICS
Once you open a can of worms, the only way to recan them is to use
a larger can.
______________________________________________ R-help at stat.math.ethz.ch mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help