util.py 1.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. import urllib.request
  2. import os
  3. from time import sleep
  4. from selenium import webdriver
  5. from selenium.webdriver.support.wait import WebDriverWait
  6. from selenium.webdriver.support import expected_conditions as EC
  7. from selenium.webdriver.common.by import By
  8. import json
  9. import config
  10. import pandas as pd
  11. def download(url, filename):
  12. try:
  13. data = urllib.request.urlopen(url).read()
  14. with open(filename, 'wb') as f:
  15. f.write(data)
  16. except:
  17. print("download_error")
  18. def store_file(filename, data):
  19. with open(filename, 'wb') as f:
  20. f.write(data)
  21. def create_dir(path):
  22. if not os.path.exists(path):
  23. # try:
  24. os.mkdir(path)
  25. # except:
  26. def read_csv(path_csv):
  27. if not os.path.exists(path_csv):
  28. return
  29. data = pd.read_csv(path_csv, encoding='gb18030')
  30. array = data.values[0::, 0::]
  31. return array
  32. # 登录时记录cookies,以后好用
  33. def login(browser):
  34. # 加cookies
  35. with open('data.json', 'r') as f:
  36. data = json.load(f)
  37. for c in data:
  38. # print(str(c))
  39. if 'expiry' in c:
  40. str_ex = str(c["expiry"])
  41. if str_ex.find(".") > -1:
  42. list_ex = str_ex.split(".")
  43. c["expiry"] = int(list_ex[0])
  44. # print(str(c))
  45. browser.add_cookie(c)
  46. if __name__ == "__main__":
  47. read_csv("C:\\Users\\Administrator\\Downloads\\实时访客.csv")