首先拆分，然后执行普通的多列分解。例如：

cols = ['Title', 'City', 'Country']
df.assign(**{c: df[c].str.split('; ') for c in cols}).explode(cols)

Name           Title      City  Country    Source
0  Haliey Wells  Data Scientist     Paris   France  Linkedin
0  Haliey Wells    Data Analyst      Suva     FIJI  Linkedin
0  Haliey Wells   Mathematician     Paris   France  Linkedin
1     Bron Levy  Data Scientist  HELSINKI  Finland    Kaggle
1     Bron Levy    Data Analyst    Berlin  Germany    Kaggle
2   Grace Kalie    Data Analyst    Athens   Greece    Kaggle
2   Grace Kalie   Mathematician  Budapest  Hungary    Kaggle
3    Evan James     ML Engineer     Tokyo    Japan    Google
3    Evan James       Developer      Lima     Peru    Google

下面是另一种使用apply而不是字典理解和解包的方法：

df.set_index(['Name', 'Source'])\
  .apply(lambda x: x.str.split(';'))\
  .explode(column=df.columns[1:-1].tolist()).reset_index()

输出：

Name    Source            Title        City    Country
0  Haliey Wells   Linkedin   Data Scientist       Paris     France
1  Haliey Wells   Linkedin     Data Analyst        Suva       FIJI
2  Haliey Wells   Linkedin   Mathematician       Paris     France 
3     Bron Levy     Kaggle   Data Scientist    HELSINKI    Finland
4     Bron Levy     Kaggle    Data Analyst      Berlin    Germany 
5   Grace Kalie     Kaggle     Data Analyst      Athens     Greece
6   Grace Kalie     Kaggle   Mathematician    Budapest    Hungary 
7    Evan James     Google      ML Engineer       Tokyo      Japan
8    Evan James     Google       Developer        Lima       Peru