import re
import pandas as pd

df = pd.read_csv("url.csv")
col_list = df["Stats_Access_Link"].tolist()

url_list = []
for s in col_list:
    s = s.strip("<url></url>")
    s = re.sub('h[^//]+//', '', s)
    url_list.append(s)

df["URL_Link"] = pd.DataFrame(url_list)