Hello, I have two data sets, where one column is exactly the same and another holds different values. There are two simple data sets: First data set: Second data set: OBS Name Income OBS Name Income 1 John 1201 1 John 5566 2 David 1602 2 David 5981 3 Karen 1553 3 Karen 8930 As You can see, the names are duplicating, however the income column is different. The question would be - how can I make a single data set where: 1) The names do not duplicate anymore. 2) The data in 'income' column would be calculated as an average value from first and second data sets. 3) If possible, are there more than one solution for this situation? Please suggest the most efficient ways to do this, because I'll need to apply suggested solution for many big data sets. The output should be: New data set Name Income John 3383,5 which is average of two previous data sets - ((1201+5566)/2) David 3791,5 Karen 5241,5 Thank You.
... View more