In [2]:
%matplotlib inline
import pandas as pd
df = pd.read_excel("c:\\Users\\yoshi\\imypy\\omaezaki7.xlsx", sheet_name="Sheet2",header=1, encoding="SHIFT_JIS")
df.plot.line(x="年月日",y=["最高気温","18最高気温"])
df.plot.line(x="年月日",y=["最低気温","18最低気温"])
df.plot.bar(x="年月日",y=["降水量","18降水量"])
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]:
| 年月日 | 最高気温 | 平均気温 | 最低気温 | 気温差 | 降水量 | 18年月日 | 18最高気温 | 18平均気温 | 18最低気温 | 18気温差 | 18降水量 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2019-06-30 | 27.1 | 24.9 | 23.5 | 3.6 | 5.0 | 2018-06-30 | 29.5 | 26.1 | 24.1 | 5.4 | 3.0 |
| 1 | 2019-07-01 | 24.8 | 23.1 | 22.2 | 2.6 | 11.0 | 2018-07-01 | 29.0 | 26.1 | 24.4 | 4.6 | 0.5 |
| 2 | 2019-07-02 | 23.3 | 22.5 | 21.7 | 1.6 | 3.0 | 2018-07-02 | 29.2 | 26.0 | 23.1 | 6.1 | 4.0 |
| 3 | 2019-07-03 | 25.5 | 23.3 | 21.7 | 3.8 | 16.5 | 2018-07-03 | 29.0 | 25.8 | 24.2 | 4.8 | 0.0 |
| 4 | 2019-07-04 | 24.9 | 23.5 | 22.2 | 2.7 | 61.5 | 2018-07-04 | 29.2 | 26.0 | 23.7 | 5.5 | 5.0 |
| 5 | 2019-07-05 | 23.3 | 21.7 | 20.2 | 3.1 | 50.0 | 2018-07-05 | 27.7 | 25.6 | 24.6 | 3.1 | 2.0 |
| 6 | 2019-07-06 | 23.3 | 21.8 | 20.0 | 3.3 | 54.5 | 2018-07-06 | 25.7 | 24.9 | 23.2 | 2.5 | 21.5 |
| 7 | 2019-07-07 | 27.2 | 24.5 | 22.3 | 4.9 | 0.0 | 2018-07-07 | 27.6 | 25.1 | 23.4 | 4.2 | 0.5 |
| 8 | 2019-07-08 | 24.7 | 23.3 | 22.2 | 2.5 | 0.0 | 2018-07-08 | 29.4 | 25.6 | 23.2 | 6.2 | NaN |
| 9 | 2019-07-09 | 24.8 | 21.9 | 19.8 | 5.0 | 6.0 | 2018-07-09 | 29.5 | 26.2 | 23.2 | 6.3 | 0.0 |
| 10 | 2019-07-10 | 26.3 | 23.3 | 21.0 | 5.3 | 0.0 | 2018-07-10 | 30.0 | 26.6 | 23.6 | 6.4 | 0.0 |
| 11 | 2019-07-11 | 24.3 | 21.6 | 18.4 | 5.9 | 9.5 | 2018-07-11 | 29.7 | 26.8 | 24.6 | 5.1 | 0.0 |
| 12 | 2019-07-12 | 27.0 | 23.2 | 19.8 | 7.2 | 1.0 | 2018-07-12 | 28.7 | 25.9 | 24.9 | 3.8 | 0.0 |
| 13 | 2019-07-13 | 25.5 | 23.4 | 22.3 | 3.2 | 4.0 | 2018-07-13 | 31.7 | 27.4 | 24.1 | 7.6 | 0.0 |
| 14 | 2019-07-14 | 24.8 | 22.7 | 20.1 | 4.7 | 38.5 | 2018-07-14 | 31.5 | 28.2 | 25.2 | 6.3 | 0.0 |
| 15 | 2019-07-15 | 24.7 | 22.5 | 21.1 | 3.6 | 18.5 | 2018-07-15 | 31.8 | 28.4 | 26.1 | 5.7 | 0.0 |
| 16 | 2019-07-16 | 25.2 | 22.6 | 20.7 | 4.5 | 5.0 | 2018-07-16 | 31.7 | 28.4 | 26.1 | 5.6 | 0.0 |
| 17 | 2019-07-17 | 26.1 | 23.5 | 19.8 | 6.3 | 19.5 | 2018-07-17 | 30.8 | 28.3 | 27.1 | 3.7 | 0.0 |
| 18 | 2019-07-18 | 27.7 | 25.0 | 23.0 | 4.7 | 22.5 | 2018-07-18 | 31.7 | 28.5 | 26.8 | 4.9 | 0.0 |
| 19 | 2019-07-19 | 26.3 | 24.6 | 23.1 | 3.2 | 2.5 | 2018-07-19 | 31.9 | 28.8 | 26.5 | 5.4 | 0.0 |
| 20 | 2019-07-20 | 29.2 | 25.6 | 24.0 | 5.2 | 0.0 | 2018-07-20 | 31.9 | 28.7 | 25.8 | 6.1 | 0.0 |
| 21 | 2019-07-21 | 26.9 | 25.3 | 23.9 | 3.0 | 0.0 | 2018-07-21 | 32.2 | 28.7 | 25.7 | 6.5 | 0.0 |
| 22 | 2019-07-22 | 27.3 | 25.6 | 23.8 | 3.5 | 39.5 | 2018-07-22 | 32.3 | 29.0 | 27.2 | 5.1 | 0.0 |
| 23 | 2019-07-23 | 28.5 | 25.8 | 23.2 | 5.3 | 32.0 | 2018-07-23 | 32.7 | 29.4 | 26.9 | 5.8 | 0.0 |
| 24 | 2019-07-24 | 29.0 | 26.5 | 24.9 | 4.1 | 0.0 | 2018-07-24 | 32.4 | 29.1 | 27.1 | 5.3 | 0.0 |
| 25 | 2019-07-25 | 30.0 | 27.5 | 25.4 | 4.6 | 0.0 | 2018-07-25 | 32.0 | 28.7 | 26.0 | 6.0 | 1.5 |
| 26 | 2019-07-26 | 29.4 | 26.5 | 24.3 | 5.1 | 56.5 | 2018-07-26 | 30.4 | 26.9 | 25.3 | 5.1 | 0.0 |
| 27 | 2019-07-27 | 28.6 | 26.8 | 25.6 | 3.0 | 10.0 | 2018-07-27 | 30.7 | 27.3 | 24.8 | 5.9 | 0.0 |
| 28 | 2019-07-28 | 29.7 | 27.3 | 26.1 | 3.6 | 0.0 | 2018-07-28 | 30.4 | 25.8 | 22.1 | 8.3 | 55.0 |
| 29 | 2019-07-29 | 30.0 | 27.6 | 26.2 | 3.8 | 0.0 | 2018-07-29 | 30.8 | 27.0 | 24.8 | 6.0 | 5.5 |
| 30 | 2019-07-30 | 30.3 | 27.9 | 26.6 | 3.7 | 0.0 | 2018-07-30 | 30.8 | 27.7 | 25.8 | 5.0 | 0.0 |
