title: splitting column and extracting country, cities and organisation names
body: <p>I have a dataframe with address column as below. I would like to split this column such that the countries, cities and institutions are separated into different columns. The challenging part is that each of the cell has a different structure. The common thing in all these cells is that they end in city, country but in some situations such as row index 3, there are multiple entries.</p>
  <pre><code>    id      address
  ------------------------------------------------------------------------------------------------
  0   223     Department of GI and HPB Surgery, University Hospital Northern Norway, Breivika, Tromsø, Norway; Institute of Clinical Medicine, University of Tromsø, Tromsø, Norway
  1   223     Department of Surgery, University Hospital Maastricht, Maastricht, The Netherlands; NUTRIM School for Nutrition, Toxicology and Metabolism, Maastricht University, Maastricht, The Netherlands
  2   223     Department of Surgery, University Hospital Maastricht, Maastricht, The Netherlands; NUTRIM School for Nutrition, Toxicology and Metabolism, Maastricht University, Maastricht, The Netherlands
  3   223     Department of Surgery, Närebro University Hospital, Närebro; Department of Molecular Medicine and Surgery, Karolinska Institutet, Stockholm, Sweden'}, {'id': '9900', 'name': 'Närebro universitet, Institutionen för läkarutbildning
  4   223     Clinical Surgery, University of Edinburgh, Royal Infirmary of Edinburgh, Edinburgh, UK
  5   223     Division of Gastrointestinal Surgery, Nottingham Digestive Diseases Centre, National Institute for Health Research, Biomedical Research Unit, Nottingham University Hospitals, Queen's Medical Centre, Nottingham, UK
  6   223     Hospital of Lausanne (CHUV), Lausanne, Switzerland
  7   223     Department of GI and HPB Surgery, University Hospital Northern Norway, Breivika, Tromsø, Norway; Institute of Clinical Medicine, University of Tromsø, Tromsø, Norway
  8   223     Clinical Surgery, University of Edinburgh, Royal Infirmary of Edinburgh, Edinburgh, UK
  9   223     Department of GI and HPB Surgery, University Hospital Northern Norway, Breivika, Tromsø, Norway; Institute of Clinical Medicine, University of Tromsø, Tromsø, Norway
  </code></pre>
  <p>can anyone help here please?</p>
  <p><strong>Note</strong> the above dataframe is a subset of my dataframe and that's why the id column has same values for all the rows. The original dataframe has about 10k rows and that's why could not share it here.</p>