with open('lp.csv', "w", encoding="utf-8") as lp:
    csv_writer= csv.writer(lp)

    csv_writer.writerow(['Title', 'Excerpt', 'Slug', 'Author', 'Category'])

    for urls in csv_reader:
        links = urls[6]
        pages = requests.get(links)
        soup = BeautifulSoup(pages.text, 'html.parser')