Creating Index Variable in R

Question

I have the following table:

#Rainfall(PCP-minimum)        #Rainfall(PCP-maximum)        #Rainfall_index(DRI) 

0               -              4.9                           0
5                -             9.9                           1
10              -             14.9                           2

So the general formula is:

5*n              -            5*n+4.9                       n

I would like to code such table using R to get the variable DRI

So if PCP is between 0-4.9 then DRI= 0 and if PCP between 5-9.9 then DRI = 1 and so on so the general rule that If PCP between 5n- 5n+4.9 then DRI = n

Thanks in Advance

No it is a different question I have a variable that is an interval I want to create an index variable DRI for each category so the first category takes 0 the second takes 1 and so on up to n — Marwah M Soliman, Jul 29 '13 at 02:39
Could you explain with more details the part you talk about the normal distribution? — Andre Silva, Jul 29 '13 at 02:49
Ok assume that I have a Normal distribution data that can be put in the table above the MAx and Min values now I want to create an index DRI that gives 0 for the first category and 1 for the second category and so on my question is how to put the above data in such format and how to get the index variable? — Marwah M Soliman, Jul 29 '13 at 02:54
So if PCP is between 0-4.9 then DRI= 0 and if PCP between 5-9.9 then DRI = 1 and so on so the general rule that If PCP between 5n- 5n+4.9 then DRI = n — Marwah M Soliman, Jul 29 '13 at 03:05

thelatemail · Accepted Answer · 2013-07-29T03:33:54.683

2

Do you just want to code the table up? Would something like this suffice?:

PCP <- c(0, 4.9, 5, 9.9, 10, 14.9, 15)
seq2max <- seq(0,max(PCP)+5,5)

result <- data.frame(min=seq2max,max=seq2max+4.9,DRI=seq_along(seq2max)-1)

  min  max DRI
1   0  4.9   0
2   5  9.9   1
3  10 14.9   2
4  15 19.9   3
5  20 24.9   4

result$DRI
# [1] 0 1 2 3 4

edited Jul 29 '13 at 03:33

answered Jul 29 '13 at 02:42

thelatemail

91,185
12
128
188

This is not the answer to my question – Marwah M Soliman Jul 29 '13 at 02:49
@MarwahMSoliman - I don't really know what you want, but does the edit above work for you? – thelatemail Jul 29 '13 at 03:02
GOOD JOB :D !! that really helps – Marwah M Soliman Jul 29 '13 at 03:10
Thank you @thelatemail but why people are voting low for my question ??? – Marwah M Soliman Jul 29 '13 at 03:17
@MarwahMSoliman - because it was not clear what you were asking. Typically on Stackoverflow you need to have a clear, reproducible example specifying your input data. Along with this, you typically need to provide an example of how you want your output data to look. I was guessing as to what you wanted, instead of knowing! – thelatemail Jul 29 '13 at 03:20
@thelatemail- I want to call DRI in the R and get its values in such case the DRI is not a variable – Marwah M Soliman Jul 29 '13 at 03:22
@MarwahMSoliman - see my edit - `DRI` is now part of a `data.frame` inside of your working space (or `global environment`) in this case. – thelatemail Jul 29 '13 at 03:34
@thelatemail- thank you but how Can I extend the table up to 88.9 i.e more than 5 categories ?? – Marwah M Soliman Jul 29 '13 at 03:40

Creating Index Variable in R

1 Answers1