How to extract locations from strings of addresses?

Question

pietro 2019-1-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/439142-how-to-extract-locations-from-strings-of-addresses

编辑： Stephen23 2019-1-13

Hi all,

I have more than a thousand of strings containing addresses. How can I programmatically extract the locations, like cities (e.g. Rome, London, etc) and countries (e.g. Italy, UK, etc)?

Thanks

Pietro

8 个评论
显示 6更早的评论隐藏 6更早的评论

pietro 2019-1-10

编辑：pietro 2019-1-10

在 MATLAB Online 中打开

Thanks for you answers. The addresses are the affiliations reported in scientific articles, where there is no specific format. Here few examples:

Sustainable Industrial Systems, School of Chemical Engineering and Analytical Science, The University of Manchester, Manchester, United Kingdom; Dipartimento di Scienze Agrarie e Ambientali - Produzione, Territorio, Agroenergia, Università degli Studi di Milano, Milan, Italy'
Department of Agricultural and Environmental Sciences - Production, Landscape, Agroenergy, Università degli Studi di Milano, Via G. Celoria 2, Milano, Italy; Department of Earth and Environmental Sciences, University of Milano-Bicocca, Piazza della Scienza 1, Milano, Italy
Department of Land and Agriculture and Forestry Systems, University of Padua, Viale dell'Università 16, 35020 Legnaro (PD), Italy
Dipartimento di Agraria, University of Sassari, Sassari, Italy

The desidered output is:

1- Manchester, UK; Milan (or Milano), Italy

2- Milano, Italy; Milano, Italy

3- Legnaro, Italy

4- Sassari, Italy

My idea is to:

remove stopwords
search if any word can be found in a city database. In the past, I accomplished that by using yahoo query language, but it does not work anymore.

thanks

Akira Agata 2019-1-13

编辑：Akira Agata 2019-1-13

在 MATLAB Online 中打开

How abou the following approach?

Split each line with ';' character into 1 or 2 segments
Split each segment(s) with ',' mark into several fragments
Extract the last two fragments

The following is my try:

str = [...
  "Sustainable Industrial Systems, School of Chemical Engineering and Analytical Science, The University of Manchester, Manchester, United Kingdom; Dipartimento di Scienze Agrarie e Ambientali - Produzione, Territorio, Agroenergia, Università degli Studi di Milano, Milan, Italy";
  "Department of Agricultural and Environmental Sciences - Production, Landscape, Agroenergy, Università degli Studi di Milano, Via G. Celoria 2, Milano, Italy; Department of Earth and Environmental Sciences, University of Milano-Bicocca, Piazza della Scienza 1, Milano, Italy";
  "Department of Land and Agriculture and Forestry Systems, University of Padua, Viale dell'Università 16, 35020 Legnaro (PD), Italy";
  "Dipartimento di Agraria, University of Sassari, Sassari, Italy"];
for kk1 = 1:numel(str)
  strSplit = strsplit(str(kk1),';');
  strOut = repelem("",1,numel(strSplit));
  for kk2 = 1:numel(strSplit)
    strTmp = strsplit(strSplit(kk2),', ');
    strOut(kk2) = strjoin(strTmp(end-1:end),', ');
  end
  disp(strjoin(strOut,'; '))
end

The output is as follows:

Manchester, United Kingdom; Milan, Italy

Milano, Italy; Milano, Italy

35020 Legnaro (PD), Italy

Sassari, Italy

pietro 2019-1-13

Hi Akira,

thank you for the answer. Well, it is a good solution. I think I might adopt it.

Cheers,

Michele

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Stephen23 2019-1-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/439142-how-to-extract-locations-from-strings-of-addresses#answer_356225

编辑：Stephen23 2019-1-13

Using one simple regular expression:

>> C = {...
  'Sustainable Industrial Systems, School of Chemical Engineering and Analytical Science, The University of Manchester, Manchester, United Kingdom; Dipartimento di Scienze Agrarie e Ambientali - Produzione, Territorio, Agroenergia, Università degli Studi di Milano, Milan, Italy';
  'Department of Agricultural and Environmental Sciences - Production, Landscape, Agroenergy, Università degli Studi di Milano, Via G. Celoria 2, Milano, Italy; Department of Earth and Environmental Sciences, University of Milano-Bicocca, Piazza della Scienza 1, Milano, Italy';
  'Department of Land and Agriculture and Forestry Systems, University of Padua, Viale dell''Università 16, 35020 Legnaro (PD), Italy';
  'Dipartimento di Agraria, University of Sassari, Sassari, Italy'};
>> M = regexp(C,'[^,]+,[^,]+(?=;|$)','match');
>> M{:}
ans =
  ' Manchester, United Kingdom'
  ' Milan, Italy'
ans =
  ' Milano, Italy'
  ' Milano, Italy'
ans =
  ' 35020 Legnaro (PD), Italy'
ans =
  ' Sassari, Italy'