Python 编码问题：‘ascii‘ codec can‘t encode characters in position 8-50: ordinal not in range(128) 实操解决办法

版本 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)