python
qq_42717902
这个作者很懒,什么都没留下…
展开
-
python 传入sql
一些国家贸易信息的csv传入SQLconn = pyodbc.connect(r'DRIVER={SQL Server Native Client 10.0};SERVER=192.168.2.188;DATABASE=india1;UID=sa;PWD=123456')cursor = conn.cursor()#创建数据库for type1 in ["export"]: f...原创 2018-09-11 13:10:00 · 263 阅读 · 0 评论 -
中国新闻网
# -*- coding: utf-8 -*-import osimport reimport threadingimport time,datetimefrom lxml import etreeimport pandas as pdimport pyodbcimport requestsfrom pybloom_live import BloomFilterfrom fa...原创 2018-09-13 08:29:29 · 266 阅读 · 0 评论 -
ip池
182.99.253.180:61234 39.137.77.67:8080 118.212.137.135:31288 221.182.133.161:375 59.44.16.6:8000 117.127.0.197:8080 39.135.35.19:80 47.89.18.87:80 221.182.133.175:9999 218.65.67.15:61234 121...原创 2018-09-13 08:28:03 · 66576 阅读 · 1 评论 -
51job
# import urllib.requestimport reimport xlwt#用来创建excel文档并写入数据import requestsimport csvfrom lxml import etreefrom fake_useragent import UserAgentCOUNT = 3def parse(COUNT, header, url): while...原创 2018-09-13 08:27:48 · 426 阅读 · 0 评论 -
智联
import re,requestsfrom lxml import etree#import pymysql,sysimport csvimport time,randomfrom fake_useragent import UserAgentCOUNT = 3def parse(COUNT, header, url): while COUNT: try:...转载 2018-09-13 08:27:27 · 401 阅读 · 0 评论 -
亚马逊书籍
import osimport reimport threadingimport time,datetimeimport csvfrom lxml import etreeimport pandas as pdimport pyodbcimport requestsfrom pybloom_live import BloomFilterfrom fake_useragent i...原创 2018-09-11 13:22:26 · 380 阅读 · 0 评论 -
百度舆情
import requestsimport jsonimport codecsimport timeimport randomimport csvfrom fake_useragent import UserAgentimport pandas as pdfrom selenium import webdriverfrom lxml import etreefrom bs4 i...原创 2018-09-11 13:23:05 · 1142 阅读 · 0 评论 -
下载表格
# -*- coding: utf-8 -*-import csvimport timeimport threadingfrom bs4 import BeautifulSoup as bsimport pandas as pdimport requests#国家字典country_dict={'AFGHANISTAN TIS': '1', 'ALBANIA': '3', '...原创 2018-09-12 08:23:33 · 1504 阅读 · 0 评论