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()