def quchong_youku(filename): try: driver = webdriver.Firefox() df = pd.read_excel(filename) df["Status"] = "跟进中" for ix, row in df.iterrows(): df.ix[ix, "Status"] = "跟进中" if check_404(row["Href"], driver) else "已删除" status = encode_wrap("排查:{}/{}".format(ix + 1, len(df))) print status time.sleep(1) df.to_excel(filename.replace(".xlsx", "") + "(checked).xlsx", index=False) driver.quit() print "success" except Exception, e: print "Error:", e
def quchong_youku(filename): try: driver = webdriver.Firefox() df = pd.read_excel(filename) df['Status'] = '跟进中' for ix, row in df.iterrows(): df.ix[ix, 'Status'] = '跟进中' if check_404(row['Href'], driver) else '已删除' status =encode_wrap( '排查:{}/{}'.format(ix+1, len(df))) print status time.sleep(1) df.to_excel(filename.replace('.xlsx','')+'(checked).xlsx', index=False) driver.quit() print 'success' except Exception,e: print 'Error:', e
def test(): url = "http://www.tudou.com/programs/view/Mtl90fPo8e8/" is404 = check_404(url) print is404
def test(): url = 'http://www.tudou.com/programs/view/Mtl90fPo8e8/' is404 = check_404(url) print is404