import pandas as pd
import Charpter2.Weather_forecast as C2W
# 读取xlsx格式的文件,使用read_excel方法
# 注意!需要有openpyxl库
'''
本函数实现了在excel文件里面
寻找城市对应的行政区划编码功能
'''
def ID_Find(city):
# 如果报错是xlrd >=2.1.0xxxx
weather_district_data = pd.read_excel("weather_district_id.xlsx",engine="openpyxl")
index = 0 # 索引
for district in weather_district_data["district"]:
index = index + 1
if city == district: # 查找到城市
break
return weather_district_data["districtcode"][index-1]
if __name__ == '__main__':
city = input("请输入您想查找的城市天气:")
code = ID_Find(city)
C2W.Weather_forcast(city=city,district_code=code) #上一段代码所在包的调用