Hi,

I have one dataset with 3000 surnames and want to get the county of origin of these surnames, match it to a bigger, Census data where each surname appears in more than 1 counties , e.g surname Murphy appears in the Census 1000 times, out of which 24 % of the time in county Cork, 18 % of time in Kerry, 16 % in Down, so on (there are 32 counties). So I want the surnames in my small dataset to get matched to the county of origin from the Census where that surname appears more than in other counties, Cork from the above example.


Do you know how I can do it ?
Many thanks,
Ciara