haotu : an open lab notebook

2016/07/14

aggregate by removing NA

Filed under: Manipulate Data in R, R, R Stats, Uncategorized — Tags: — S @ 08:43
na.collapse<-function(x)
{
 x.<-unique(x[!is.na(x)])
   if(length(x.)==0)
 {
   return(NA)
   } else {
     if(length(x.)==1){
     return(x.)
   } else {
     return(paste(x.,collapse="|"))
   }
  }
}
na.collapse(x)

2016/07/11

replace empty cells in google sheets

Filed under: Google, Sheets, Uncategorized — S @ 10:35
=if(isblank(A1),"myreplace",A1)

2016/07/06

center gis point of a polygon shape file

Filed under: arcmap, R spatial — Tags: , — S @ 08:20

http://support.esri.com/technical-article/000009381

In the map document, open the attribute table for the polygon feature class by right-clicking the layer name.
In the attribute table, navigate to Table Options > Add Field and add two new fields of type Double. Name one ‘Longitude’ and the other ‘Latitude’.
Right-click the Longitude field and select Calculate Geometry.
In the Calculate Geometry dialog box, select ‘X Coordinate of Centroid’ from the Property drop-down menu. Click OK.
Right-click the Latitude field and select Calculate Geometry.
In the Calculate Geometry dialog box, select ‘Y Coordinate of Centroid’ from the Property drop-down menu. Click OK.

Create a free website or blog at WordPress.com.