python mongoDB 爬虫 爬取和查询天气信息

import requests as r 
import time
import pymongo
url="https://cdn.heweather.com/china-city-list.csv"
res=r.get(url)
city_list=res.text.split('\r') #以换行符分割为数组
for i in range(2):
    city_list.remove(city_list[0]) #删除表头 
#print(city_list)
for item in city_list:
    city_info=item.split(',') #以逗号把城市具体信息分割成数组
    city_py=city_info[1] #获取城市对应的拼音
    url="https://free-api.heweather.net/s6/weather/now?location="+city_py+"&key=你的key地址"#接口地址
    res=r.get(url) #获取信息
    res.encoding='utf-8' #解码 
    data=res.json() #专程dic字典
    mongo=pymongo.MongoClient("localhost",27017) #连接Db
    book_weather=mongo['weather'] #建库
    sheet_weather=book_weather['sheet_weather'] #建表
    sheet_weather.insert_one(data) #插入数据
    time.sleep(1) #延迟1秒继续循环
    print(data)

import pymongo
mongo=pymongo.MongoClient('localhost',27017)
book_weather=mongo['weather']
sheet_weather=book_weather['sheet_weather']
dic={'HeWeather6.basic.cid':'CN101070211'} #根据城市ID查询 根据需求自己改
for item in sheet_weather.find(dic):
    print(item)

注:爬到是和风天气的数据