In [11]:
%matplotlib inline
import pandas as pd
df = pd.read_excel("c:\\Users\\yoshi\\imypy\\omaezaki6.xlsx", sheet_name="Sheet1",header=1, encoding="SHIFT_JIS")
df.plot.line(x="年月日",y=["最高気温","17最高気温"])
df.plot.line(x="年月日",y=["最低気温","17最低気温"])
# df.plot.line(x="年月日",y="最低気温")
# df.plot.line(x="年月日",y="気温差")
# df.plot.bar(x="年月日",y="日照時間")
# df.plot.bar(x="年月日",y="降水量")
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[11]:
| 年月日 | 平均気温 | 最高気温 | 最低気温 | 気温差 | 降水量 | 日照時間 | 17最高気温 | 17最低気温 | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 2018-08-01 | 27.7 | 30.5 | 25.1 | 5.4 | 0.0 | 12.2 | 31.8 | 24.6 |
| 1 | 2018-08-02 | 28.5 | 31.5 | 26.8 | 4.7 | 0.0 | 10.8 | 26.3 | 24.2 |
| 2 | 2018-08-03 | 28.5 | 32.6 | 25.9 | 6.7 | 0.0 | 10.2 | 29.7 | 23.9 |
| 3 | 2018-08-04 | 28.6 | 31.7 | 26.9 | 4.8 | 0.0 | 9.2 | 30.7 | 25.1 |
| 4 | 2018-08-05 | 28.8 | 31.8 | 27.1 | 4.7 | 0.0 | 11.1 | 30.0 | 25.4 |
| 5 | 2018-08-06 | 29.5 | 33.7 | 26.3 | 7.4 | 0.0 | 11.3 | 30.5 | 25.1 |
| 6 | 2018-08-07 | 28.4 | 31.0 | 26.8 | 4.2 | 0.0 | 8.4 | 27.6 | 26.3 |
| 7 | 2018-08-08 | 28.1 | 31.1 | 24.4 | 6.7 | 0.0 | 2.6 | 30.3 | 25.1 |
| 8 | 2018-08-09 | 28.7 | 31.1 | 27.0 | 4.1 | 0.0 | 12.5 | 31.9 | 25.0 |
| 9 | 2018-08-10 | 28.7 | 31.7 | 27.4 | 4.3 | 0.0 | 9.6 | 29.9 | 25.3 |
| 10 | 2018-08-11 | 28.6 | 31.2 | 27.0 | 4.2 | 0.0 | 6.4 | 28.5 | 24.9 |
| 11 | 2018-08-12 | 28.4 | 32.2 | 26.4 | 5.8 | 12.5 | 4.1 | 29.0 | 23.8 |
| 12 | 2018-08-13 | 28.3 | 31.6 | 26.1 | 5.5 | 0.0 | 6.3 | 29.4 | 25.6 |
| 13 | 2018-08-14 | 28.6 | 31.7 | 25.6 | 6.1 | 0.0 | 9.9 | 29.5 | 24.0 |
| 14 | 2018-08-15 | 27.0 | 31.2 | 25.1 | 6.1 | 15.5 | 4.8 | 28.8 | 24.1 |
| 15 | 2018-08-16 | 28.0 | 31.2 | 25.1 | 6.1 | 7.0 | 8.1 | 26.4 | 23.1 |
| 16 | 2018-08-17 | 26.7 | 30.2 | 22.6 | 7.6 | 0.0 | 11.2 | 29.9 | 24.3 |
| 17 | 2018-08-18 | 24.8 | 27.6 | 23.2 | 4.4 | 0.0 | 10.0 | 30.0 | 25.4 |
| 18 | 2018-08-19 | 24.8 | 28.4 | 21.3 | 7.1 | 0.0 | 11.5 | 30.2 | 24.2 |
| 19 | 2018-08-20 | 26.2 | 29.8 | 21.9 | 7.9 | 0.5 | 7.1 | 29.4 | 25.6 |
| 20 | 2018-08-21 | 27.8 | 31.4 | 25.3 | 6.1 | 0.0 | 6.7 | 29.6 | 25.4 |
| 21 | 2018-08-22 | 28.8 | 32.9 | 26.5 | 6.4 | 0.0 | 11.1 | 31.2 | 25.6 |
| 22 | 2018-08-23 | 28.0 | 31.1 | 26.5 | 4.6 | 6.5 | 1.8 | 33.1 | 26.4 |
| 23 | 2018-08-24 | 28.0 | 30.2 | 27.0 | 3.2 | 2.0 | 3.5 | 32.0 | 26.0 |
| 24 | 2018-08-25 | 27.9 | 30.5 | 26.6 | 3.9 | 0.0 | 3.8 | 31.4 | 26.2 |
| 25 | 2018-08-26 | 28.0 | 31.2 | 26.3 | 4.9 | 0.0 | 12.5 | 31.7 | 24.5 |
| 26 | 2018-08-27 | 28.2 | 32.5 | 25.6 | 6.9 | 0.0 | 12.4 | 30.4 | 25.4 |
| 27 | 2018-08-28 | 28.0 | 31.6 | 25.0 | 6.6 | 0.0 | 8.3 | 30.2 | 24.9 |
| 28 | 2018-08-29 | 28.2 | 31.8 | 26.3 | 5.5 | 0.0 | 11.9 | 30.2 | 24.4 |
| 29 | 2018-08-30 | 28.1 | 30.8 | 26.6 | 4.2 | 0.0 | 9.9 | 31.2 | 26.5 |
| 30 | 2018-08-31 | 27.9 | 30.9 | 25.0 | 5.9 | 8.5 | 11.0 | 29.8 | 24.5 |
| 31 | 2018-09-01 | 26.0 | 29.9 | 24.2 | 5.7 | 10.5 | 2.6 | 28.4 | 19.3 |
| 32 | 2018-09-02 | 24.9 | 26.7 | 22.0 | 4.7 | 34.0 | 1.5 | 27.1 | 18.7 |
| 33 | 2018-09-03 | 25.5 | 28.2 | 22.4 | 5.8 | 18.0 | 6.8 | 27.2 | 23.0 |
| 34 | 2018-09-04 | 26.6 | 28.7 | 23.1 | 5.6 | 58.5 | 0.2 | 27.1 | 21.9 |
