I'm trying to filter a column with URLs links only in a dataframe. I want to filter it selecting some key words within these URLs. For instance, I'd like to keep only those containing "journaldebangui" in the column "Link" I have tried this code with no success:
data_file = pd.read_excel('C:..scrapingData.xlsx', sheet_name="Articles Scraping")
data_file_2 = data_file[data_file["Link"].str.contains("radiondekeluka")]
My new dataframe doesn't contain any observation. What am I missing? Thanks!
