How to combine two sets of data with differences in merge-index strings?

[Montana]

Hey folks,

So my main question is basically how can I norm the team names in the two sets easily, without having to analyze all the differences "by hand" and hardcode "replace"-operations on one of the sets?

Dataset1 is downloadable here: https://data.fivethirtyeight.com/#soccer-spi. Dataset2 is not available freely, but it looks like this:

Manchester United   Leicester   2018-08-10 22:00:00 0.2812      0.3275      0.3913      1.5137  1.73813