Hi,
Actually, i use the function merge like this:
(Data1 <- Data1[1:7,1:3])
Policy.Number AXA.Entity Country
1 1060000077 BNL BNL
2 4001023 CH BNL
3 1060000006 UK BNL
4 4001025 CH BNL
5 6.00E+13 USA BNL
6 6100001 UK BNL
7 4001028 USA BNL
> Data2 <- read.csv2("c:/GWPMax1.csv",sep=",")
> (Data2 <- Data2[1:7,1:2])
Policy.Number GWP_Max
1 4001023 500.00
2 4001024 10593.54
3 4001025 700.00
4 4001026 0.00
5 4001027 3621.25
6 4001028 600.00
7 4001029 7588.27
> (m <- merge(Data1,Data2, by.x = "Policy.Number",by.y = "Policy.Number"))
Policy.Number AXA.Entity Country GWP_Max
1 4001023 CH BNL 500.00
2 4001025 CH BNL 700.00
3 4001028 USA BNL 600.00
i need the number of records not matching between the two original data bases.
Can you help me please?
thank you a lot!!
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
