openssl模块一直安装不了，不知道是不是环境变量出了问题

Question

import pandas as pd
import os

os.chdir('./')

data=pd.read_excel('房价与工资.xlsx')

x=list(data['城市'])
y1=list(data['房屋均价'])
y2=list(data['人均工资'])

import matplotlib.pyplot as plt

plt.rcParams['font.sans-serif']=['SimHei']
plt.rcParams['axes.unicode_minus'] = False

plt.plot(x,y1,x,y2,marker = '.')
plt.show()

Answer 1

提示是 openpyxl 没安装。
先安装 试试

pip install openpyxl 

Answer 2

WARNING: pip is configured with locations that require TLS/SSL, however the ssl module in Python is not available. Requirement already satisfied: openpyxl in c:\users\18319\anaconda3\lib\site-packages (3.0.7) Requirement already satisfied: et-xmlfile in c:\users\18319\anaconda3\lib\site-packages (from openpyxl) (1.0.1)

Answer 3

安装后这个结果

Answer 4

你安装的openpyxl 的python 和你贴图的python 貌似不是同一个