Creating names from URLs
Yes. Try to automate converting a URL to a name, instead of hardcoding the mapping. With only two URLs, your approach is doable, but as soon as you have to handle lots of different URLs, it will quickly become very painful.
Also, avoid first copying a column and then replacing every item in it. Rather, construct the column with the right contents directly. Here is an example:
df['Name'] = [url.split('.')[-2].upper() for url in df['URL']]

This will fail for proper URLs like https://www.pandas.org/index.html. If you want to handle that automatically, you'll have to properly parse them, for example using urllib.parse.