potter

网址：https://www.lagou.com/在Mysql里面建立一个要爬取数据的表：数据库建表语句：create database if not exists spider;use spider;CREATE TABLE `lagou` ( `id` int(11) NOT NULL AUTO_INCREMENT, `t_job` varchar(255) DEFAULT N...

爬取一周内天气到数据库需要先在数据库中新建一个表：create table weather ( id int primary key auto_increment, date1 varchar(100), desc1 varchar(100), temp1 varchar(100), direction1 varchar(100), level1 v...

网址：http://quotes.toscrape.com/page/1/在数据库中新建一个表：create table quotes ( quote varchar(100), author varchar(100), tags varchar(100));主程序代码：#!usr/bin/python3#! -*- coding: utf-8 ...

网址：http://www.weather.com.cn/weather/101010100.shtmlfrom urllib.request import urlopenfrom bs4 import BeautifulSoupimport csvurl = "http://www.weather.com.cn/weather/101010100.shtml"response =...

网址：http://www.weather.com.cn/weather/101010100.shtml代码：from urllib.request import urlopenfrom bs4 import BeautifulSoupimport jsonurl = "http://www.weather.com.cn/weather/101010100.shtml"respo...