import pandas as pd
import re


df = pd.read_csv('deneme.csv')


## use regular expressions for the extraction.
def extract_url(df, device_type):
    filtered_df = df[df['Device_Type'] == device_type]
    urls = filtered_df['Stats_Access_Link'].apply(lambda x: re.search(r'https?://([^/]+)<', x).group(1))
    return urls

device_type = 'TRU151'
pure_urls = extract_url(df, device_type)
print(pure_urls)