CSV Links Added to Python

import os
import pandas as pd
import re
from bs4 import BeautifulSoup
from bs4 import element as bs4_element
from google.colab import drive
import csv
drive.mount("/content/gdrive")

os.chdir("/content/gdrive/My Drive/Colab Notebooks/Fix WordPress Links")


html_doc = """
<!-- wp:paragraph -->
<p>This is a existing link <a class="test" href="https://yahoo.com/">Yahoo</a> Text</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>This is another Google Text</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>This is another lowercase bing Text</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>This is another multi word Active Campaign Text</p>
<!-- /wp:paragraph -->
"""

soup = BeautifulSoup(html_doc, 'html.parser')

# read the CSV file with anchor text and hyperlinks
with open('file.csv', 'r') as csv_file:
  reader = csv.reader(csv_file)
  hyperlinks = dict(reader)

# from bs4 import element as bs4_element
be_navStr = bs4_element.NavigableString

hList = [
    (anchor_text.strip(), hyperlink.strip()) for
    anchor_text, hyperlink in hyperlinks.items()
    if anchor_text.strip() and hyperlink.strip() # no blanks
]


for txt, link in hList:
    navStrs = [
        d for d in soup.descendants if type(d) == be_navStr
        and f' {} '.format(txt.lower()) in f' {} '.format(d.get_text().strip().lower()) and (' '+txt.lower()+' ') in (' '+d.get_text().strip().lower()+' ')
    ]
    for ns in navStrs:
        tLen, remStr = len(txt), f' {ns.get_text().strip()} '
        if remStr[1:-1].lower() == txt.lower():
            # to skip if it's already a hyperlink
            if ns.parent.name == 'a':
                # ns.parent['href'] = link # if you want to replace/update link
                continue

        while f' {txt.lower()} ' in remStr.lower():
            sInd = remStr.lower().find(f' {txt.lower()} ') + 1

            hlTag = soup.new_tag('a', href=link)
            hlTag.append(remStr[sInd:sInd + tLen])

            newCont = [remStr[:sInd].lstrip(), hlTag, ' ']
            for addn in newCont: ns.insert_before(addn)