posted @ 2019-05-25 09:03
05 2019 档案
摘要:import requestsimport reimport pandas as pdimport pymysqlpymysql.install_as_MySQLdb()from sqlalchemy import create_engineimport timeimport logginghead
阅读全文
posted @ 2019-05-14 11:02
摘要:1.合并数据或表 df_user = pd.concat(list, axis=0, ignore_index=True)#list为数据 2.筛选 1) a=df[(df.可发库存 >= 15)]#可发库存为列名,df为数据 2) a = tcdd.loc[tcdd['订单状态'] == '已取消
阅读全文
posted @ 2019-05-13 15:42
摘要:import requestsimport reimport jsonimport pandas as pdheaders={'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, lik
阅读全文
posted @ 2019-05-13 14:24
摘要:import pandas as pd import pymysql pymysql.install_as_MySQLdb() from sqlalchemy import create_engine import time def replace_into(table_name, table_data): """ 通过relace into 方式修改数据 :param...
阅读全文
posted @ 2019-05-13 14:23
摘要:from selenium import webdriver import re import time from lxml import etree from selenium.webdriver.chrome.options import Options import pymysql import requests with open('taobao',encoding='utf-8') a...
阅读全文
posted @ 2019-05-13 14:21