[R] Summing rows based on criteria

I am attempting to clean up some land use building data and need to join some buildings together making sure not to double count GIS slivers. The first data.frame is the original, the 2nd adds all the acres for each identical bldgid. I now want to a) throw out all but one of the the cases where

Re: [R] Summing identical IDs

David, You are correct. I think the frist two assumptions can be thrown out and only the latter two (c,d) can be considered. So how would i combine Acres for matching Bldgids based on assumptions c,d? David Winsemius wrote: > > > On Oct 29, 2009, at 5:23 PM, PDXRug

Re: [R] Summing identical IDs

900 5 156.50 5 1955 6200 7 293.00 6 1999 500 8 300.09 7 1990 1300 10 112.50 8 2000 1000 Thanks, i gave it a bunch of shots but nothing worth posting. PDXRugger wrote: > > Hello All, >I would like to select records with identical IDs then

[R] Summing identical IDs

Hello All, I would like to select records with identical IDs then sum an attribute then and return them to the data frame as a single record. Please consider Acres<-c(100,101,100,130,156,.5,293,300,.09) Bldgid<-c(1,2,3,4,5,5,6,7,7) DF=cbind(Acres,Bldgid) DF<-as.data.frame(DF) So that:

[R] Re ading and Creating Shape Files

Hello R Community, I have imported a dataset which contain X Y coordinates and would like to recreate a shape file after some data analysis. What i have done is to import some taxlot data and join them based on some criteria. I want to check to see how well the joining went by reviewing the r

[R] Problems with rJava and tm packages

I am looking to do some text analysis using R and have run into some issues with some of the packages. Im not sure if its my goofy Vista OS or what but using R 2.8.1 i s relatively successful loading the text but the rJava package was messed up somehow: library(tm) > library(rJava) Error in if

[R] Selecting initial numerals

II just want to create a new object with the first two numerals of the data. Not sure why this isnt working, consider the following: EmpEst$naics=c(238321, 624410, 484121 ,238911, 81, 531110, 621399, 541613, 524210 ,236115 ,811121 ,236115 ,236115 ,621610 ,814110 ,812320) EmpEst$naics2<-form

[R] text mining

The following code is derived from a paper titled "Text Mining Infrastructure in R" (http://www.jstatsoft.org/v25/i05/paper). The example below seems to load some default documents for analysis, some sort of latin document. I cannot for the life of me figure out to load my own document let alone

Re: [R] re ading and analyzing a word document

also be useful to simply get a run down similar to a summary expressing the most common words. Ideas? cls59 wrote: > > > PDXRugger wrote: >> >> Howdy Y'all, >> >> So i am looking to read a word document in the following formats(.doc) or >> any

[R] re ading and analyzing a word document

file=("LUSDR/letter.doc") Howdy Y'all, So i am looking to read a word document in the following formats(.doc) or any type of accessible word processor software (e.g. text .txt, notepad, etc). Had the ability to search certain words, for instance "banana", "peacock","Weapons" "Mass" "Destructio

[R] Creating a simple line graph

Hey everyone, Sorry for yet another simple question but hopefully it makes whoever comes up with the answer feel good about helping others. I would like to simply plot the following two sets of data in a line graph. The one set is an observed set of points and the latter is the predicted. I

[R] creating selection vector with 2 attributes

Please consider the following: Puma=c(702, 702, 701, 702, 701, 702, 701, 702 ,702 ,702 ,701 ,702, 702, 701 ,701, 702, 701 ,702, 702, 702,701, 702 ,702 ,702 ,701) PumaNums=c(100 , 200 , 300 , 400 , 500 , 600 , 701 , 702 , 800 , 900 ,1000 ,1101, 1102, 1200 ,1301 ,1302 ,1303, 1304, 1305, 1306, 1307

[R] Re ferencing columns and pulling selected data

Please consider the following inputs: PrsnSerialno<-c(735,1147,2019,4131,4131,4217,4629,4822,4822,5979,5979,6128,6128,7004,7004, 7004,7004,7004,7438,7438,9402,9402,9402,10115,10115,11605,12693,12693,12693) PrsnAge<-c(59,48,42,24,24,89,60,43,47,57,56,76,76,66,70,14,7,3,62,62,30,10,7,20,21,50,53,44

[R] Truncating based on attribute range and serial no

COnsider the following: Age<-c(48, 57, 56, 76, 76, 66, 70, 14, 7, 3, 62, 62, 30, 10, 7, 53, 44, 29, 46, 47, 15, 13, 84, 77, 26) SerialNo<-c(001147, 005979, 005979, 006128, 006128, 007004, 007004, 007004, 007004, 007004, 007438, 007438,009402,009402, 009402, 012693, 012693, 012693, 014063,0140

[R] re moving intial numerals

I would like to recreate "data" so that only the last 5 digits of the below data are inlcuded as data so 200502019 would become 02019. Any ideas. data=c(200500735, 200502019, 200504131, 200504217, 200504629, 200504822, 200510115, 200511605, 200514477, 200

Re: [R] truncating values into separate categories

"NA" > will NOT be treated as missing. > > > Bill Venables > http://www.cmis.csiro.au/bill.venables/ > > > -Original Message- > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] > On Behalf Of PDXRugger > Sent: Friday,

[R] truncating values into separate categories

Hi all, Simple question which i thought i had the answer but it isnt so simple for some reason. I am sure someone can easily help. I would like to categorize the values in NP into 1 of the five values in "Per", with the last category("4") representing values >=4(hence 4:max(NP)). The problem

Re: [R] Trouble with If statements

Alright guys i figured it out, no need to reply. Sorry for any bother... PDXRugger wrote: > > Hey everyone, > Consider the below. I would like to look up each of the items in > "data" and store the result in "BinStore". In this example it isnt > sto

[R] Trouble with If statements

Hey everyone, Consider the below. I would like to look up each of the items in "data" and store the result in "BinStore". In this example it isnt storing any value but the last. In my actual code i am getting another error altogether, i get a 1:In if (VacAcresVals.CandTaz <= 4) (BinNumbe

[R] Re placing null values (#NULL!)

I am stumped. I have a data set with multiple columns and about 65,000 case. Some of the cases have a "#NULL!" value so for dataframe "Props_": access_emp pct_vacant TAVAIL park PARKACRES totlandare 4538 52.15 #NULL! 01 22.9974,129.70400 4539 52.

[R] Problems intalling on Suse 10.3 x86_64 OS

Alright, i am unsure of the posting rules for these types of questions but i will be as help ful as possible. My windows based system cant handle a model i am running so i am trying to install R on our Linux based machine but i have encountered the following and i dont know linux much but my intu

[R] subscript out of bounds

Consider -> if (BinNumber==1) Loc_Prob=Bin1Main.data[findInterval(Dev_Size,Bin1Main.data[,1])+1,2] . .. ... if (BinNumber==10) Loc_Prob=Bin10Main.data[findInterval(Dev_Size,Bin10Main.data[,1])+1,2] BinNumber is just referencing 1 of 10 sets of data so: where BinNumber = 1 and Dev_S

[R] Re moving unwanted double values in list

I have a procedure that goes sorts out some numbers based on specidifed criteria and for some reason the list contains double values in some of the rows such as: TAZs <- [[84]] [1] 638 [[85]] [1] 643 [[86]] [1] 644 732 [[87]] [1] 651 801 i would like to check list TAZs for double values and

[R] loading and manipulating 10 data frames-simplified

I have to load 10 different data frames and then manipulate those 10 data frames but would like to do this in a more simplified code than what i am doing. I have tried a couple of approaches but cannot get it to work correctly. So the initial (bulky) code is: #Bin 1 #--- #Loads bin data

[R] Environment change?

So i have a simple question that doesnt require sample code, not sure if that violates posting rules or not. Is this: [1] "111" "112" "113" "114" "115" "116" "118" "119" "120" "123" "125" "126" [13] "127" "128" "132" "137" "138" "139" "140" "143" "149" "154" "156" "157" [25] "158" "164" "165"

[R] Re moving Numeric,0 from dataframe

I realize i am breaking the posting rules by not posting sample code but i tried building some sample test code for this problem based on my working code and it wasnt producing what i wanted so hopefully a brief explanation and my result will allow you guys enough information to offer some advice.

[R] Creating a vector

Good day all, I am having seom trouble building a simple vector. Below my sample code shows what ime trying to do and i have pointed out where the issue is. What happens not is that a single "TAZDetermine_FEET" is selected by i need multiple values, as many as there are "cands". I am think

[R] Creating a vector based on lookup function

I am still searching for a solution to what i think is a simple problem i am having with building a vector in a for loop. I have built a more understandable example so hopefully that will help..help you, help me, if you know what i mean. dev=400 #test location model TAZs to reference cands=c(1

[R] creating a new vecotr in a for loop

I have consulted the intro and nabble but have not found an answer to what should be a simple question, here goes: I am doing a crosscheck of a data frame and pulling out a single value based on an inputted value ie based on x i will select y, or if x =2 then my code returns 7. xy 1 4 2

Re: [R] Conditionally Removing data from a vector

I greatly apoligize, clear in my own mind, just didnt explain well enough. DEVS should equal 6 values the last being 620, like the data frame: CANDS DEVS > [1,] 100 120 > [2,] 101 220 > [3,] 102 320 > [4,] 103 420 > [5,] 104 520 > [6,] 105 620 And yes, my first quest

[R] Conditionally Removing data from a vector

I am having trouble removing entries from a vector based on the value of the vector and another object value. It works in my pseudo test run: DEV=400 #Y CANDS=c(100:105) #Z DEVS=c(120,220,320,420,520) if(DEV>DEVS) (CANDS=CANDS[which(DEVTAZDetermine_FEET)

[R] For Loop - loading 10 sets of data and calculating

I am trying to simplify my code by adding a for loop that will load and compute a sequence of code 10 time. They way i run it now is that the same 8 lines of code are basically reproduced 10 times. I would like to replace the numeric value in the code (e.g. Bin1, Bin2Bin10) each time the loo

[R] conditional loop

I am looking up a number based upon a randomly selected number and then proceed to the rest of my code if the corresponding value is greater than or equal to yet another value. so if Dev_Size = 14 and my randomly selected number is 102 and i am looking up 102 in the following table 100 21

[R] Calling object outside function

What i thought was a simple process isnt working for me. After i create an multiple objects in a function (see below), how to i use those objects later in the program. I tried calling the function again and then the object i wanted and it worked the first time but now it doesnt( i think i define

[R] Error in table lookup

I am trying to lookup a value in 1 of 10 loaded two column-data sets (Bins) by displaying the value of the second column based on the value of the first. For instance in Bin1_Acres Bin1_parprobBin1_TAZ [1,] 0.0004420.978 356 [2,] 0.0004530.954

Re: [R] Simple look up

PS: yourdataframe[yourdataframe$TAZ==103,2] > > > > > > PDXRugger wrote: >> >> So i am hoping this solution is simple, which i beleive it is. I would >> like to look up a value in one column of a data set and display the >> corresponding value in the 2nd

[R] Simple look up

So i am hoping this solution is simple, which i beleive it is. I would like to look up a value in one column of a data set and display the corresponding value in the 2nd column. For example TAZVACANT ACRES 100 45 101 62 102 23 103 64 104 101 105 280 So if