我有一個資料框,它以月份為一列,第一列代表年份。我想繪制此資料框的時間序列,即讀取每一行并繪制時間序列。我在下面提供了我的資料框的一小部分。請讓我知道執行此任務的任何方式。
年一月二月三月四月五月六月七月八月九月十月十一月十二月
0 1870 -0.02 -0.02 -0.01 -0.01 -0.01 -0.01 -0.01 -0.01 -0.01 -0.01 -0.01 -0.01
1 1871 -0.01 -0.01 -0.01 -0.01 -0.01 -0.01 -0.01 -0.01 -0.01 0.00 0.00 0.00
等等....
uj5u.com熱心網友回復:
我假設您以如下形式將資料存盤在 Pandas DataFrame 中(每行代表一年):
df = pd.DataFrame(np.array([[1870,0.02,0.02,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01],
[1871,0.02,0.02,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]]),
columns = ["YEAR", "JAN", "FEB", "MAR", "APR", "MAY", "JUN", "JUL", "AUG", "SEP", "OCT", "NOV", "DEC"])
以這種方式輸出 df :
YEAR JAN FEB MAR APR MAY ... JUL AUG SEP OCT NOV DEC
0 1870.0 0.02 0.02 0.01 0.01 0.01 ... 0.01 0.01 0.01 0.01 0.01 0.01
1 1871.0 0.02 0.02 0.01 0.01 0.01 ... 0.01 0.01 0.01 0.01 0.01 0.01
[2 rows x 13 columns]
這只是具有重復行條目的兩年樣本。
您需要的是以下內容:
import matplotlib.pyplot as plt
cols = np.array(df.columns)[1:]
rows_size= df.shape[0]
x = np.empty((1, 0), str)
y = np.empty((1, 0), float)
for i in range (rows_size):
x = np.append(x, str(int(df.iloc[i, 0])) "-" cols.reshape(1,12) , axis = 1)
y = np.append(y, np.array(df.iloc[i, 1:]).reshape(1,12), axis = 1)
x = x.reshape(-1)
y = y.reshape(-1)
plt.plot(x, y)
plt.xticks(x,x, rotation ='vertical')
plt.subplots_adjust(bottom = 0.2)
plt.show()
由此產生的情節將是這樣的: 
轉載請註明出處,本文鏈接:https://www.uj5u.com/qiye/372126.html
上一篇:影像分割numpy陣列中的元素檢查和修改同時保持形狀
下一篇:NumPy:沿軸1減少<
