版本 Python 3.6
报错:
'ascii' codec can't encode characters in position 8-50: ordinal not in range(128)
究其原因就是中文符号的编码问题
解决:
import pandas as pd
import urllib.parse
path = 'https:xxx.com/(牛牛).xls'
# safe 为无需转码的字符
url = urllib.parse.quote(path,safe=":/=?#")
dates = pd.read_excel(url,keep_default_na=False).to_dict(orient='records')
print(dates)