In [5]:

    

from urllib.request import urlopen
from bs4 import BeautifulSoup 
from datetime import datetime, date, time
import csv
import webbrowser
import pandas as pd

def open_browser():
    url = 'https://www.maxanet.com/cgi-bin/mnbidlog.cgi?rosen316'
    webbrowser.open(url)
    
open_browser()

def getdate():
    time = datetime.now()
    dt = time.strftime("%A, %d %B %Y %I:%M%p")
    
    print(dt)
    
html = urlopen("https://www.maxanet.com/cgi-bin/mnbidlog.cgi?rosen316")
soup = BeautifulSoup(html, "lxml")


file = open("bidhistory.csv", 'w') 
    
dtable = soup.find('table',id ='DataTable').findAll('tr')

biddatasaved = " "

for record in dtable:
    biddata = " "
    for data in record.findAll('td'):
        biddata = biddata + "," + data.text 
    biddatasaved = biddatasaved + "\n" + biddata[2:]
file.write(biddatasaved)
file.close()


    

In [6]:

    

bdh = pd.read_csv('bidhistory.csv', header=[1],skiprows=1)


    

In [3]:

    

bdh.head()


    

    
Out[3]:






  

    

      

      
178
      
4204
      
1300.00
      
12/07/2016 1:58 PM
    
  
  

  

In [ ]: