Quantcast

rounding up to nearest integer

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

rounding up to nearest integer

mohan L
Dear All,

I have a data frame "data"  and the below is the str of "data" :

$ Feb   : int  1 1195 0 11 28 152 24 2 1 1470 ...
 $ Mar   : int  0 1212 0 17 27 184 15 1 1 1311 ...
 $ Apr   : int  2 1244 1 15 23 135 11 0 1 991 ...
 $ May   : int  2 1158 2 10 23 111 16 1 1 1237 ...
 $ Jun   : int  0 845 1 9 16 86 16 2 1 1129 ...
 $ Jul   : int  0 832 0 7 16 68 9 1 0 994 ...
 $ Aug   : int  0 1107 1 4 25 144 7 0 3 1260 ...
 $ Sep   : int  2 1278 1 8 53 212 14 0 3 1375 ...
 $ Oct   : int  3 1329 0 8 39 201 13 0 0 1340 ...
 $ Nov   : int  1 1179 0 5 7 135 2 0 0 1153 ...
 $ Dec   : int  0 1271 0 7 34 168 5 1 2 1792 ...
 $ Jan.10: int  0 1405 1 10 55 245 26 2 4 2806 ...
 $ Feb.10: int  0 1330 1 9 29 360 27 3 6 3492 ...
 $ Mar.10: int  0 1727 0 8 7 341 8 2 4 4578 ...
 $ Apr.10: int  0 1530 1 8 12 144 7 2 2 5453 ...

I am doing some this like this :

> x <- (data[,-(1:2)] - data[,2]) * prop.table(data[,2]) + data[,2]
> x
           Feb          Mar          Apr          May          Jun
Jul
1     1.000000    0.9999597    1.0000403    1.0000403    0.9999597
0.9999597
2  1292.610851 1293.5003225 1295.1746211 1290.6749436 1274.2982103
1273.6180264

Now the str of "x" is :

> str(x)
'data.frame':    32 obs. of  15 variables:
 $ Feb   : num  1 1293 0 5 18 ...
 $ Mar   : num  1 1294 0 5 18 ...
 $ Apr   : num  1 1295 0 5 18 ...
 $ May   : num  1 1291 0 5 18 ...
 $ Jun   : num  1 1274 0 5 18 ...
 $ Jul   : num  1 1274 0 5 18 ...
 $ Aug   : num  1 1288 0 5 18 ...
 $ Sep   : num  1 1297 0 5 18 ...
 $ Oct   : num  1 1300 0 5 18 ...
 $ Nov   : num  1 1292 0 5 18 ...
 $ Dec   : num  1 1297 0 5 18 ...
 $ Jan.10: num  1 1303.6 0 5 18 ...
 $ Feb.10: num  1 1300 0 5 18 ...
 $ Mar.10: num  1 1320 0 5 18 ...
 $ Apr.10: num  1 1310 0 5 18 ...

I need to round up the data frame some thing like this :

      Feb          Mar          Apr          May          Jun          Jul
1     1              1                1               1             1
        1
2  1293         1294           1295          1291       1274       1274

there may be a way to round up the nearest integer. any help will be greatly
appropriated.

Thanks & Rg
Mohan L

        [[alternative HTML version deleted]]

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: rounding up to nearest integer

Nikhil Kaza-2
?round



On May 24, 2010, at 9:26 PM, Mohan L wrote:

> Dear All,
>
> I have a data frame "data"  and the below is the str of "data" :
>
> $ Feb   : int  1 1195 0 11 28 152 24 2 1 1470 ...
> $ Mar   : int  0 1212 0 17 27 184 15 1 1 1311 ...
> $ Apr   : int  2 1244 1 15 23 135 11 0 1 991 ...
> $ May   : int  2 1158 2 10 23 111 16 1 1 1237 ...
> $ Jun   : int  0 845 1 9 16 86 16 2 1 1129 ...
> $ Jul   : int  0 832 0 7 16 68 9 1 0 994 ...
> $ Aug   : int  0 1107 1 4 25 144 7 0 3 1260 ...
> $ Sep   : int  2 1278 1 8 53 212 14 0 3 1375 ...
> $ Oct   : int  3 1329 0 8 39 201 13 0 0 1340 ...
> $ Nov   : int  1 1179 0 5 7 135 2 0 0 1153 ...
> $ Dec   : int  0 1271 0 7 34 168 5 1 2 1792 ...
> $ Jan.10: int  0 1405 1 10 55 245 26 2 4 2806 ...
> $ Feb.10: int  0 1330 1 9 29 360 27 3 6 3492 ...
> $ Mar.10: int  0 1727 0 8 7 341 8 2 4 4578 ...
> $ Apr.10: int  0 1530 1 8 12 144 7 2 2 5453 ...
>
> I am doing some this like this :
>
>> x <- (data[,-(1:2)] - data[,2]) * prop.table(data[,2]) + data[,2]
>> x
>           Feb          Mar          Apr          May          Jun
> Jul
> 1     1.000000    0.9999597    1.0000403    1.0000403    0.9999597
> 0.9999597
> 2  1292.610851 1293.5003225 1295.1746211 1290.6749436 1274.2982103
> 1273.6180264
>
> Now the str of "x" is :
>
>> str(x)
> 'data.frame':    32 obs. of  15 variables:
> $ Feb   : num  1 1293 0 5 18 ...
> $ Mar   : num  1 1294 0 5 18 ...
> $ Apr   : num  1 1295 0 5 18 ...
> $ May   : num  1 1291 0 5 18 ...
> $ Jun   : num  1 1274 0 5 18 ...
> $ Jul   : num  1 1274 0 5 18 ...
> $ Aug   : num  1 1288 0 5 18 ...
> $ Sep   : num  1 1297 0 5 18 ...
> $ Oct   : num  1 1300 0 5 18 ...
> $ Nov   : num  1 1292 0 5 18 ...
> $ Dec   : num  1 1297 0 5 18 ...
> $ Jan.10: num  1 1303.6 0 5 18 ...
> $ Feb.10: num  1 1300 0 5 18 ...
> $ Mar.10: num  1 1320 0 5 18 ...
> $ Apr.10: num  1 1310 0 5 18 ...
>
> I need to round up the data frame some thing like this :
>
>      Feb          Mar          Apr          May          
> Jun          Jul
> 1     1              1                1               1             1
>        1
> 2  1293         1294           1295          1291       1274        
> 1274
>
> there may be a way to round up the nearest integer. any help will be  
> greatly
> appropriated.
>
> Thanks & Rg
> Mohan L
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> [hidden email] 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.

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: rounding up to nearest integer

Nordlund, Dan (DSHS/RDA)
In reply to this post by mohan L
> -----Original Message-----
> From: [hidden email] [mailto:r-help-bounces@r-
> project.org] On Behalf Of Mohan L
> Sent: Monday, May 24, 2010 6:26 PM
> To: [hidden email]
> Subject: [R] rounding up to nearest integer
>
> Dear All,
>
> I have a data frame "data"  and the below is the str of "data" :
>
> $ Feb   : int  1 1195 0 11 28 152 24 2 1 1470 ...
>  $ Mar   : int  0 1212 0 17 27 184 15 1 1 1311 ...
>  $ Apr   : int  2 1244 1 15 23 135 11 0 1 991 ...
>  $ May   : int  2 1158 2 10 23 111 16 1 1 1237 ...
>  $ Jun   : int  0 845 1 9 16 86 16 2 1 1129 ...
>  $ Jul   : int  0 832 0 7 16 68 9 1 0 994 ...
>  $ Aug   : int  0 1107 1 4 25 144 7 0 3 1260 ...
>  $ Sep   : int  2 1278 1 8 53 212 14 0 3 1375 ...
>  $ Oct   : int  3 1329 0 8 39 201 13 0 0 1340 ...
>  $ Nov   : int  1 1179 0 5 7 135 2 0 0 1153 ...
>  $ Dec   : int  0 1271 0 7 34 168 5 1 2 1792 ...
>  $ Jan.10: int  0 1405 1 10 55 245 26 2 4 2806 ...
>  $ Feb.10: int  0 1330 1 9 29 360 27 3 6 3492 ...
>  $ Mar.10: int  0 1727 0 8 7 341 8 2 4 4578 ...
>  $ Apr.10: int  0 1530 1 8 12 144 7 2 2 5453 ...
>
> I am doing some this like this :
>
> > x <- (data[,-(1:2)] - data[,2]) * prop.table(data[,2]) + data[,2]
> > x
>            Feb          Mar          Apr          May          Jun
> Jul
> 1     1.000000    0.9999597    1.0000403    1.0000403    0.9999597
> 0.9999597
> 2  1292.610851 1293.5003225 1295.1746211 1290.6749436 1274.2982103
> 1273.6180264
>
> Now the str of "x" is :
>
> > str(x)
> 'data.frame':    32 obs. of  15 variables:
>  $ Feb   : num  1 1293 0 5 18 ...
>  $ Mar   : num  1 1294 0 5 18 ...
>  $ Apr   : num  1 1295 0 5 18 ...
>  $ May   : num  1 1291 0 5 18 ...
>  $ Jun   : num  1 1274 0 5 18 ...
>  $ Jul   : num  1 1274 0 5 18 ...
>  $ Aug   : num  1 1288 0 5 18 ...
>  $ Sep   : num  1 1297 0 5 18 ...
>  $ Oct   : num  1 1300 0 5 18 ...
>  $ Nov   : num  1 1292 0 5 18 ...
>  $ Dec   : num  1 1297 0 5 18 ...
>  $ Jan.10: num  1 1303.6 0 5 18 ...
>  $ Feb.10: num  1 1300 0 5 18 ...
>  $ Mar.10: num  1 1320 0 5 18 ...
>  $ Apr.10: num  1 1310 0 5 18 ...
>
> I need to round up the data frame some thing like this :
>
>       Feb          Mar          Apr          May          Jun
> Jul
> 1     1              1                1               1             1
>         1
> 2  1293         1294           1295          1291       1274       1274
>
> there may be a way to round up the nearest integer. any help will be
> greatly
> appropriated.
>
> Thanks & Rg
> Mohan L
>

If you truly want to round up, look at

?ceiling

Hope this is helpful,

Dan

Daniel J. Nordlund
Washington State Department of Social and Health Services
Planning, Performance, and Accountability
Research and Data Analysis Division
Olympia, WA 98504-5204


______________________________________________
[hidden email] 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.
Loading...