Hello everyone,
Merging two dataframes should be easy. However when I try to merge, R
doesn't recognize identical values, even if I am doing it by values that
have no decimals.
willclayong:
vs30 LON LAT Net X wills.cat wills.vs30 clahan.cat clahanvs30
PolyID.wills PolyID.clahan tif.cat STA ELEVATION tif.vs30
1 338.539 -3849590 4319319 <NA> 2 D 301 D
377 1958 1942 1 150 NA 519
2 712.822 -3849590 4319319 <NA> 3 D 301 D
377 1958 1942 1 479 NA 519
3 477.652 -3836584 4288164 <NA> 10 C 464 C
489 1194 9353 3 148 NA 547
4 513.703 -3836575 4287739 <NA> 11 C 464 C
489 1194 9353 3 485 NA 547
5 477.652 -3835886 4289120 <NA> 12 C 464 C
489 1194 9353 7 147 NA 388
wald:
> wald_ol_sta[1:10,]
X Wald.vs30 STA vs30 LON LAT
1 1 434.417 1502 274.500 -3077929 3759564
2 2 378.049 NEE2 363.000 -3086165 3718184
3 3 196.848 EMS 336.000 -3143337 3500449
4 4 557.625 1498 659.600 -3103738 3871531
5 5 263.878 1497 274.500 -3102944 3878068
6 6 374.898 1499 274.500 -3109753 3858460
7 7 150.000 230 274.500 -3154048 3482703
8 8 248.342 1205 207.469 -3153294 3497116
9 9 422.256 1495 338.600 -3097854 3990339
10 10 322.540 1496 274.500 -3115300 3863905
willsclayongwald<-merge(wald_ol_sta, willsclayong, by=c("LON", "LAT", "STA",
"vs30"))
returns nothing... if I modify the previous script by adding "all=TRUE", I
get this:
lsclayongwald[1:10,]
LON LAT STA vs30 X.x Wald.vs30 Net X.y wills.cat
wills.vs30 clahan.cat clahanvs30 PolyID.wills PolyID.clahan tif.cat
ELEVATION tif.vs30
1 -3854850 4321856 478 513.703 1155 586.685 <NA> NA
<NA> NA <NA> NA NA NA
NA NA NA
2 -3849590 4319319 150 338.539 NA NA <NA> 2 D
301 D 377 1958 1942 1 NA
519
3 -3849590 4319319 479 712.822 NA NA <NA> 3 D
301 D 377 1958 1942 1 NA
519
4 -3849590 4319319 150 338.539 1152 336.794 <NA> NA
<NA> NA <NA> NA NA NA
NA NA NA
rows 2 and 4 should have merged. Why didn't they?
thanks!
Mehdi Khan
[[alternative HTML version deleted]]
______________________________________________
R-help@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.
