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] > xFeb 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]]
?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]] > > ______________________________________________ > R-help at 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.
> -----Original Message----- > From: r-help-bounces at r-project.org [mailto:r-help-bounces at r- > project.org] On Behalf Of Mohan L > Sent: Monday, May 24, 2010 6:26 PM > To: r-help at r-project.org > 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
Maybe Matching Threads
- Identifying records with the correct number of repeated measures
- [LLVMdev] Bit-code file input to ld (was: ...From module/bitcode to Mach-O dylib file directly)
- samba 4.7.6-Ubuntu + ipv6 not work bind9-DLZ
- [Bug 1274] Bugs intended to be fixed for 4.6/4.6p1
- [Bug 778] sftp client globs entire path, directories enclosed in square brackets are unusable