日常问题解决汇总_urlerror:

日常操作时遇到各种报错或新想法，所遇问题以及搜索到的解决方案参考来源大汇总（持续更新）

Python数据科学库

1. URLError: <urlopen error [Errno 61] Connection refused>

# 原代码
import seaborn as sns
planets = sns.load_dataset('planets')
1
2
3

解决：从github下载数据集，用pandas调用

• mwaskom/seaborn-data - GitHub

import pandas as pd
planets = pd.read_csv('./seaborn-data-master/planets.csv')
1
2

2. Keyerror: ‘Date’

• Keyerror ‘Date’ when using pandas datareader - Stackoverflow

I received the ‘Keyerror ‘Date’ when using pandas datareader’ error and found two errors in my script that fixed the issue:

1. The name of the entity was incorrect, for example using ‘APPL’ instead of ‘AAPL’.
2. There was no data for the date parameters I was using.

# 解决代码
# Use 'BTC-USD' stock/security value
import pandas as pd
import pandas_datareader.data as w
1
2
3