将excel的两列数据快速转换为python的字典

例子：

要把以上的图表转换成：
{‘山东省’: ‘华东’, ‘江苏省’: ‘华东’, ‘安徽省’: ‘华东’, ‘浙江省’: ‘华东’, ‘福建省’: ‘华东’, ‘上海市’: ‘华东’, ‘广东省’: ‘华东’, ‘广西壮族自治区’: ‘华东’, ‘海南省’: ‘华东’, ‘湖北省’: ‘华东’, ‘湖南省’: ‘华中’, ‘河南省’: ‘华中’, ‘江西省’: ‘华中’, ‘北京市’: ‘华北’, ‘天津市’: ‘华北’, ‘河北省’: ‘华北’, ‘山西省’: ‘华北’, ‘内蒙古自治区’: ‘华北’, ‘宁夏回族自治区’: ‘西北’, ‘新疆维吾尔自治区’: ‘西北’, ‘青海省’: ‘西北’, ‘陕西省’: ‘西北’, ‘甘肃省’: ‘西北’, ‘四川省’: ‘西南’, ‘云南省’: ‘西南’, ‘贵州省’: ‘西南’, ‘西藏自治区’: ‘西南’, ‘重庆市’: ‘西南’, ‘辽宁省’: ‘东北’, ‘吉林省’: ‘东北’, ‘黑龙江省’: ‘东北’, ‘台湾’: ‘港澳台’, ‘香港’: ‘港澳台’, ‘澳门’: ‘港澳台’}

如何做：

import pandas as pd
filename = r'华东华中华北东北华南西北西南地区及省份对应表.xlsx'
base = pd.read_excel(filename)
dic = {key:val for key,val in zip(list(base['省份']),list(base['区域']))}

方法二

dic = base.set_index(['省份'])['区域'].to_dict()