御前崎の気温データの処理（2020年）¶
最高気温、最低気温、降水量の2019年との比較¶
前年12月1日～2月11日まで（2020年、2019年）¶
2020年の冬は確かに2019年に比べると気温が高い日が多く（12，1月）また降水量は1月に多めでした。2月のはじめは2020年の方が気温は低めでした。 これは2019年の1月から3月のものとも比較してみてください。http://www.ne.jp/asahi/yoshikn02/namo/zemi/omaezaki2019.html
In [2]:
%matplotlib inline
import pandas as pd
df = pd.read_excel("c:\\Users\\yoshi\\imypy\\omaezaki2020.xls", sheet_name="Sheet1",header=1, encoding="SHIFT_JIS")
df.plot.line(x="年月日",y=["最高気温","19最高気温"])
df.plot.line(x="年月日",y=["最低気温","19最低気温"])
df.plot.line(x="年月日",y=["平均気温","19平均気温"])
df.plot.bar(x="年月日",y=["降水量","19降水量"])
df
C:\Users\yoshi\Anaconda3\lib\site-packages\pandas\plotting\_core.py:1716: UserWarning: Pandas doesn't allow columns to be created via a new attribute name - see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access series.name = label
Out[2]:
| 年月日 | 最高気温 | 平均気温 | 最低気温 | 気温差 | 降水量 | 19年月日 | 19最高気温 | 19平均気温 | 19最低気温 | 19気温差 | 19降水量 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2019/12/1 | 17.2 | 13.4 | 10.7 | 6.5 | 0.0 | 2018/12/1 | 18.1 | 13.5 | 9.9 | 8.2 | 0.0 |
| 1 | 2019/12/2 | 20.1 | 16.3 | 12.6 | 7.5 | 39.5 | 2018/12/2 | 16.8 | 15.0 | 12.6 | 4.2 | 0.0 |
| 2 | 2019/12/3 | 14.3 | 10.8 | 8.0 | 6.3 | 0.0 | 2018/12/3 | 19.7 | 16.3 | 13.8 | 5.9 | 3.0 |
| 3 | 2019/12/4 | 13.7 | 9.5 | 6.3 | 7.4 | 0.0 | 2018/12/4 | 22.4 | 19.3 | 15.8 | 6.6 | 29.5 |
| 4 | 2019/12/5 | 13.0 | 9.3 | 6.8 | 6.2 | 0.0 | 2018/12/5 | 21.4 | 18.9 | 17.0 | 4.4 | 0.5 |
| 5 | 2019/12/6 | 10.8 | 8.8 | 7.2 | 3.6 | 0.0 | 2018/12/6 | 17.8 | 16.3 | 15.0 | 2.8 | 2.5 |
| 6 | 2019/12/7 | 10.8 | 8.9 | 6.6 | 4.2 | 0.0 | 2018/12/7 | 17.2 | 14.0 | 9.7 | 7.5 | 0.0 |
| 7 | 2019/12/8 | 14.3 | 10.3 | 4.1 | 10.2 | 0.0 | 2018/12/8 | 12.1 | 8.8 | 6.2 | 5.9 | 0.0 |
| 8 | 2019/12/9 | 14.8 | 12.6 | 10.1 | 4.7 | 4.0 | 2018/12/9 | 11.6 | 7.1 | 4.7 | 6.9 | 0.0 |
| 9 | 2019/12/10 | 16.5 | 13.6 | 11.1 | 5.4 | 4.5 | 2018/12/10 | 11.6 | 9.3 | 4.9 | 6.7 | 0.0 |
| 10 | 2019/12/11 | 17.2 | 14.9 | 12.3 | 4.9 | 0.0 | 2018/12/11 | 13.0 | 10.8 | 8.8 | 4.2 | 1.0 |
| 11 | 2019/12/12 | 16.2 | 12.5 | 7.0 | 9.2 | 0.0 | 2018/12/12 | 16.5 | 11.9 | 7.0 | 9.5 | 27.5 |
| 12 | 2019/12/13 | 13.1 | 10.1 | 5.3 | 7.8 | 0.0 | 2018/12/13 | 12.7 | 8.5 | 5.0 | 7.7 | 0.0 |
| 13 | 2019/12/14 | 15.3 | 11.3 | 6.7 | 8.6 | 0.0 | 2018/12/14 | 12.5 | 7.8 | 5.1 | 7.4 | 0.0 |
| 14 | 2019/12/15 | 15.1 | 11.5 | 6.5 | 8.6 | 0.0 | 2018/12/15 | 10.8 | 8.0 | 4.3 | 6.5 | 0.0 |
| 15 | 2019/12/16 | 14.6 | 12.4 | 9.7 | 4.9 | 1.0 | 2018/12/16 | 14.1 | 10.6 | 8.1 | 6.0 | 0.0 |
| 16 | 2019/12/17 | 17.0 | 14.9 | 11.7 | 5.3 | 25.5 | 2018/12/17 | 15.3 | 11.2 | 8.5 | 6.8 | 22.5 |
| 17 | 2019/12/18 | 19.5 | 15.5 | 9.8 | 9.7 | 0.0 | 2018/12/18 | 12.1 | 8.7 | 6.4 | 5.7 | 0.0 |
| 18 | 2019/12/19 | 16.6 | 13.8 | 10.1 | 6.5 | 0.0 | 2018/12/19 | 12.3 | 9.5 | 6.0 | 6.3 | 0.0 |
| 19 | 2019/12/20 | 14.4 | 11.7 | 8.2 | 6.2 | 0.0 | 2018/12/20 | 15.0 | 11.9 | 9.1 | 5.9 | 0.0 |
| 20 | 2019/12/21 | 15.3 | 10.7 | 6.7 | 8.6 | 0.0 | 2018/12/21 | 15.1 | 12.2 | 7.6 | 7.5 | 0.0 |
| 21 | 2019/12/22 | 13.2 | 10.5 | 7.3 | 5.9 | 18.5 | 2018/12/22 | 15.4 | 13.3 | 11.5 | 3.9 | 26.0 |
| 22 | 2019/12/23 | 13.8 | 10.2 | 7.3 | 6.5 | 10.5 | 2018/12/23 | 15.3 | 13.5 | 11.7 | 3.6 | 2.5 |
| 23 | 2019/12/24 | 15.6 | 11.5 | 8.5 | 7.1 | 0.0 | 2018/12/24 | 13.1 | 10.1 | 5.5 | 7.6 | 0.0 |
| 24 | 2019/12/25 | 14.8 | 11.7 | 10.0 | 4.8 | 0.0 | 2018/12/25 | 12.5 | 8.1 | 4.0 | 8.5 | 0.0 |
| 25 | 2019/12/26 | 15.9 | 12.6 | 10.0 | 5.9 | 1.0 | 2018/12/26 | 12.9 | 10.4 | 6.2 | 6.7 | 0.0 |
| 26 | 2019/12/27 | 14.8 | 10.7 | 6.0 | 8.8 | 4.5 | 2018/12/27 | 14.4 | 9.5 | 5.5 | 8.9 | 0.0 |
| 27 | 2019/12/28 | 13.2 | 7.4 | 3.6 | 9.6 | 0.0 | 2018/12/28 | 8.4 | 5.0 | 1.8 | 6.6 | 0.0 |
| 28 | 2019/12/29 | 12.4 | 9.2 | 3.3 | 9.1 | 0.0 | 2018/12/29 | 7.3 | 3.9 | 1.2 | 6.1 | 0.0 |
| 29 | 2019/12/30 | 13.2 | 11.3 | 9.9 | 3.3 | 3.0 | 2018/12/30 | 10.3 | 4.8 | 0.8 | 9.5 | 0.0 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 43 | 2020/1/13 | 11.9 | 8.8 | 6.4 | 5.5 | 0.0 | 2019/1/13 | 12.0 | 9.7 | 7.6 | 4.4 | 0.0 |
| 44 | 2020/1/14 | 12.6 | 9.2 | 5.8 | 6.8 | 0.0 | 2019/1/14 | 11.2 | 8.9 | 6.9 | 4.3 | 0.5 |
| 45 | 2020/1/15 | 11.4 | 8.0 | 4.8 | 6.6 | 4.5 | 2019/1/15 | 11.8 | 8.8 | 7.1 | 4.7 | 5.0 |
| 46 | 2020/1/16 | 10.6 | 6.5 | 3.3 | 7.3 | 0.0 | 2019/1/16 | 12.3 | 8.3 | 5.5 | 6.8 | 0.0 |
| 47 | 2020/1/17 | 12.0 | 7.9 | 4.4 | 7.6 | 6.5 | 2019/1/17 | 11.1 | 7.2 | 3.5 | 7.6 | 0.0 |
| 48 | 2020/1/18 | 8.8 | 8.0 | 6.7 | 2.1 | 5.0 | 2019/1/18 | 11.1 | 6.9 | 4.6 | 6.5 | 0.0 |
| 49 | 2020/1/19 | 10.8 | 7.3 | 2.2 | 8.6 | 0.0 | 2019/1/19 | 11.9 | 8.4 | 4.7 | 7.2 | 0.0 |
| 50 | 2020/1/20 | 12.8 | 9.5 | 7.1 | 5.7 | 0.0 | 2019/1/20 | 12.4 | 9.5 | 6.8 | 5.6 | 0.0 |
| 51 | 2020/1/21 | 13.7 | 9.1 | 5.7 | 8.0 | 0.0 | 2019/1/21 | 10.8 | 7.2 | 5.3 | 5.5 | 0.0 |
| 52 | 2020/1/22 | 13.5 | 10.9 | 8.4 | 5.1 | 0.0 | 2019/1/22 | 11.1 | 7.4 | 4.4 | 6.7 | 0.0 |
| 53 | 2020/1/23 | 16.9 | 12.2 | 10.5 | 6.4 | 17.5 | 2019/1/23 | 11.5 | 7.7 | 2.1 | 9.4 | 0.0 |
| 54 | 2020/1/24 | 16.7 | 12.0 | 9.1 | 7.6 | 0.0 | 2019/1/24 | 10.7 | 7.1 | 3.3 | 7.4 | 0.0 |
| 55 | 2020/1/25 | 14.8 | 11.0 | 6.4 | 8.4 | 0.0 | 2019/1/25 | 10.5 | 6.0 | 1.7 | 8.8 | 0.0 |
| 56 | 2020/1/26 | 10.9 | 8.9 | 7.5 | 3.4 | 10.5 | 2019/1/26 | 11.0 | 5.4 | 1.1 | 9.9 | 0.0 |
| 57 | 2020/1/27 | 10.9 | 9.2 | 6.0 | 4.9 | 7.0 | 2019/1/27 | 10.5 | 4.6 | 0.3 | 10.2 | 0.0 |
| 58 | 2020/1/28 | 14.1 | 11.9 | 8.4 | 5.7 | 4.0 | 2019/1/28 | 10.0 | 6.4 | 1.0 | 9.0 | 0.0 |
| 59 | 2020/1/29 | 17.4 | 13.2 | 10.0 | 7.4 | 0.5 | 2019/1/29 | 11.6 | 6.3 | 2.1 | 9.5 | 0.0 |
| 60 | 2020/1/30 | 13.6 | 10.0 | 7.0 | 6.6 | 0.0 | 2019/1/30 | 12.0 | 8.3 | 3.3 | 8.7 | 0.0 |
| 61 | 2020/1/31 | 11.7 | 7.7 | 4.3 | 7.4 | 0.0 | 2019/1/31 | 11.5 | 8.2 | 5.6 | 5.9 | 11.5 |
| 62 | 2020/2/1 | 12.9 | 7.3 | 3.8 | 9.1 | 0.0 | 2019/2/1 | 9.5 | 5.5 | 2.3 | 7.2 | 0.0 |
| 63 | 2020/2/2 | 12.2 | 7.0 | 2.1 | 10.1 | 0.0 | 2019/2/2 | 11.7 | 8.0 | 4.5 | 7.2 | 0.0 |
| 64 | 2020/2/3 | 12.8 | 9.0 | 3.9 | 8.9 | 0.0 | 2019/2/3 | 14.0 | 9.6 | 5.0 | 9.0 | 6.0 |
| 65 | 2020/2/4 | 13.3 | 8.7 | 4.9 | 8.4 | 0.0 | 2019/2/4 | 17.0 | 13.4 | 6.7 | 10.3 | 8.5 |
| 66 | 2020/2/5 | 11.6 | 7.3 | 3.8 | 7.8 | 0.0 | 2019/2/5 | 13.1 | 9.1 | 3.6 | 9.5 | 0.0 |
| 67 | 2020/2/6 | 8.4 | 4.7 | 1.8 | 6.6 | 0.0 | 2019/2/6 | 12.2 | 9.7 | 8.0 | 4.2 | 9.0 |
| 68 | 2020/2/7 | 8.4 | 5.5 | 3.3 | 5.1 | 2.5 | 2019/2/7 | 15.4 | 11.5 | 5.9 | 9.5 | 0.0 |
| 69 | 2020/2/8 | 13.5 | 8.6 | 4.9 | 8.6 | 0.0 | 2019/2/8 | 11.7 | 9.4 | 7.4 | 4.3 | 0.0 |
| 70 | 2020/2/9 | 9.9 | 5.4 | 2.4 | 7.5 | 0.0 | 2019/2/9 | 9.5 | 8.0 | 5.4 | 4.1 | 0.0 |
| 71 | 2020/2/10 | 9.5 | 5.7 | 1.7 | 7.8 | 0.0 | 2019/2/10 | 9.7 | 6.3 | 3.3 | 6.4 | 0.0 |
| 72 | 2020/2/11 | 11.5 | 7.4 | 2.8 | 8.7 | 0.0 | 2019/2/11 | 10.3 | 8.0 | 6.1 | 4.2 | 0.0 |
73 rows × 12 columns
