from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.support import expected_conditions as EC
from selenium.webdriver.support.wait import WebDriverWait
browser = webdriver.Edge()
try:
browser.get("http://www.baidu.com")
input = browser.find_element_by_id("kw")
input.send_keys("Python")
input.send_keys(Keys.ENTER)
wait = WebDriverWait(browser, 10)
wait.until(EC.presence_of_element_located((By.ID, "content_left")))
print(browser.current_url)
print(browser.get_cookies())
print(browser.page_source)
finally:
browser.close()
def search(keywords):
url = "http://cn.bing.com"
browser = webdriver.Edge()
browser.get(url)
time.sleep(2)
browser.find_element_by_name('q').send_keys(keywords)
browser.find_element_by_id('sb_form_go').click()
time.sleep(2)
return browser.page_source
def search_with_edge(url, user, content):
edge = webdriver.Edge(executable_path=r"C:\Program Files (x86)\Microsoft\Edge Dev\Application\msedge.exe")
edge.get(url)
edge.find_element_by_id("user").send_keys(user)
edge.find_element_by_id("pwd").send_keys("123456")
edge.find_element_by_id("submit").click()
edge.find_element_by_id("kw").send_keys(content)
edge.find_element_by_id("su").click()
return edge.find_element_by_id("content_left").text
search_with_edge("https://www.baidu.com/", "test", "a")
def login_steelhome(url, username, password):
"""
模拟登录钢贸网
:param url: 登录地址
:param username: 用户名
:param password: 密码
:return: 登录后的cookie
"""
browser = webdriver.Chrome()
browser.get(url)
browser.find_element_by_id('username').send_keys(username)
browser.find_element_by_id('password').send_keys(password)
browser.find_element_by_class_name('sub_btn').click()
cookie = browser.get_cookies()
browser.close()
return cookie
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
import time
# 创建浏览器对象
driver = webdriver.Edge(executable_path="msedgedriver.exe")
# 窗口最大化
driver.maximize_window()
# 打开网页
driver.get("https://www.baidu.com")
# 打印当前页面title
print(driver.title)
# 找到搜索框
elem = driver.find_element_by_name("wd")
# 在输入框中输入关键词并提交
elem.send_keys("python")
elem.send_keys(Keys.RETURN)
# 等待页面加载
import pandas as pd
def excel_sort(input_path, output_path):
df = pd.read_excel(input_path)
df.sort_values(by=['流水号','登记日期'], inplace=True)
df.to_excel(output_path, index=False)
input_path = 'data/2019-4-1.xlsx'
output_path = 'data/2019-4-1-output.xlsx'
excel_sort(input_path, output_path)
from selenium import webdriver
def search(query):
driver = webdriver.Edge()
driver.get("https://www.google.com.tw/")
search = driver.find_element_by_name("q")
search.send_keys(query)
search.submit()
return driver.page_source
search("九合一大選")
import pandas as pd
def clean_col(df, col_name):
col = df[col_name]
col_unique = sorted(df[col_name].unique())
for item in col_unique:
item_df = df[col == item]
if item_df.shape[0] == 1:
continue
else:
for i in item_df.index:
if i != item_df.index[0]:
df.at[i, col_name] = ''
return df
df = pd.read_excel('xxx.xlsx', sheet_name='Sheet1')
col_name = 'xxx'
clean_col(df, col_name)
df.to_excel('xxx.xlsx', sheet_name='Sheet1', index=False)
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
browser = webdriver.Chrome()
browser.get('https://www.baidu.com')
search_input = browser.find_element_by_id('kw')
search_input.send_keys('test')
search_input.send_keys(Keys.RETURN)
browser.page_source
data = []
with open('data.txt') as f:
for line in f:
data.append(line.strip())
# print(data)
# ['a', 'b', 'c', 'c', 'd', 'e', 'e', 'e', 'f', 'f', 'g']
last_value = ''
for i in range(len(data)):
if data[i] == last_value:
print(data[i], end = ' ')
else:
print('')
print(data[i], end = ' ')
last_value = data[i]
import pyautogui
import time
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
def searchWeb(content):
browser = webdriver.Edge()
browser.get("http://www.google.com")
assert "Google" in browser.title
elem = browser.find_element_by_name("q")
elem.send_keys(content)
elem.send_keys(Keys.RETURN)
time.sleep(1)
print(browser.page_source)
browser.close()
searchWeb("hello")
def searchWeb(content):
browser = webdriver.Edge()
browser.get("http://www.google.com")
assert "Google" in browser.title
elem = browser.find_element_by_name("q")
elem.send_keys(content)
elem.send_keys(Keys.RETURN)
time.sleep(1)
print(browser.page_source)
browser.close()
searchWeb("hello")
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
# def search_baidu(search_content):
# browser = webdriver.Chrome()
# browser.get('https://www.baidu.com')
# search_bar = browser.find_element_by_id('kw')
# search_bar.send_keys(search_content)
# search_bar.send_keys(Keys.RETURN)
# browser.close()
def search_baidu(search_content):
'''打开指定网址，寻找搜索栏，在搜索栏内填写需要搜索的内容，提交后跳转到新网址'''
browser = webdriver.Chrome()
browser.get('https://
