import pandas as pd
import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt
%matplotlib inline
df=pd.read_excel('BeijingPM20100101_20151231.xlsx')
df.head()
PM_Dongsi | PM_Dongsihuan | PM_Nongzhanguan | PM_US Post | PM25 | TEMP | |
---|---|---|---|---|---|---|
0 | 117 | 166 | 140.0 | 150.0 | 143.25 | 1.0 |
1 | 131 | 165 | 152.0 | 163.0 | 152.75 | 5.0 |
2 | 141 | 173 | 128.0 | 172.0 | 153.50 | 8.0 |
3 | 169 | 182 | 3.0 | 181.0 | 133.75 | 11.0 |
4 | 169 | 169 | 3.0 | 187.0 | 132.00 | 12.0 |
from pylab import mpl
mpl.rcParams['font.sans-serif'] = ['Microsoft YaHei']
mpl.rcParams['axes.unicode_minus'] = False
x=df['TEMP']
y=df['PM25']
plt.xlabel("溫度") #X軸名稱
plt.ylabel("PM2.5") #Y軸名稱
plt.title("北京PM2.5與溫度比較") #標題
plt.scatter(x,y)
<matplotlib.collections.PathCollection at 0xd908438>
df=pd.read_excel('ShenyangPM20100101_20151231.xlsx')
x=df['TEMP']
y=df['PM25']
plt.xlabel("溫度") #X軸名稱
plt.ylabel("PM2.5") #Y軸名稱
plt.title("瀋陽PM2.5與溫度比較") #標題
plt.scatter(x,y)
<matplotlib.collections.PathCollection at 0xdc74358>
df=pd.read_excel('Abrasan.xlsx')
df.head()
TEMP | PM25 | |
---|---|---|
0 | -0.46 | 94.41 |
1 | 0.14 | 78.81 |
2 | 1.33 | 79.12 |
3 | 2.37 | 71.92 |
4 | 2.58 | 65.18 |
x=df['TEMP']
y=df['PM25']
plt.xlabel("溫度") #X軸名稱
plt.ylabel("PM2.5") #Y軸名稱
plt.title("大不里士PM2.5與溫度比較") #標題
plt.scatter(x,y)
<matplotlib.collections.PathCollection at 0xdcd93c8>