ai_link.py

from requests import get
from bs4 import BeautifulSoup
import unicodecsv as csv
import pandas as pd
import numpy as np
import folium
from googlegeocoder import GoogleGeocoder
import unicodecsv as csv

# make soup format
url = 'https://blog.benchsci.com/startups-using-artificial-intelligence-in-drug-discovery'
response = get(url)
soup = BeautifulSoup(response.text, 'html.parser')

# scrap and save in csv file
csv_file = open('start_up_141.csv', 'ab')
writer = csv.writer(csv_file, dialect='excel', delimiter=',', encoding='utf-8')
writer.writerow(['compnay','website'])

containter = soup.find_all('h3')
# last 2 does not conain any link so -2
for link in containter[:-2]:
    company = link.text
    website = link.a["href"]
    writer.writerow([company, website])
csv_file.close()

d