我正在繪制 4 支球隊(duì)的賽季與完成位置，但 y 軸是由代碼隨機(jī)繪制的，而不是根據(jù)位置排序的。有什么辦法解決這個問題？這是我的代碼Sample data: Season Finish - df10 1950 4th1 1951 3rd2 1952 4th3 1953 3rd4 1954 3rd Season Finish - df20 1950 4th1 1951 2nd2 1952 1st3 1953 1st4 1954 1st Season Finish - df30 1950 1st1 1951 1st2 1952 1st3 1953 1st4 1954 1st Season Finish - df40 1950 2nd1 1951 5th2 1952 8th3 1953 6th4 1954 5th將 pandas 導(dǎo)入為 pd，將 numpy 導(dǎo)入為 np，將 matplotlib 導(dǎo)入為 mpl，將 matplotlib.pyplot 導(dǎo)入為 plt，df1 = pd.read_csv('Pistons.csv')df2 = pd.read_csv('lions.csv')df3 = pd.read_csv('red-wings.csv')df4 = pd.read_csv('Tigers.csv')df_list = [df1, df2, df3, df4]for i in df_list: # i['Season'] = i['NFL season'] i.rename(columns={i.columns[0]: "Season"}, inplace=True)# print(df1['Season'])# change name of to season# for i in df_list:# plt.plot(i.Season, i.Finish,)plt.plot(df1.Season, df1.Finish, label="Pistons")plt.plot(df2.Season, df2.Finish, label="Lions")plt.plot(df3.Season, df3.Finish, label="Red Wings")plt.plot(df4.Season, df4.Finish, label="Tigers")plt.gca().invert_yaxis()plt.title("Season vs Finish Position Graph", fontsize=17)plt.xlabel('Season (Year)', fontsize=13)plt.ylabel('Finish Position', fontsize=13)plt.legend(loc=4, fontsize=10, frameon=False)plt.show()[Image of the output here][1].stack.imgur.com/POmXR.png
1 回答
冉冉說
TA貢獻(xiàn)1877條經(jīng)驗(yàn) 獲得超1個贊
df1-df4想法是使用by創(chuàng)建一個 Dataframe concat，僅在列表理解中將Finish列轉(zhuǎn)換為數(shù)字，并且還通過索引。Series.str.extractSeasonDataFrame.set_index
最后的情節(jié)DataFrame.plot：
names = ['Pistons','Lions','Red Wings','Tigers']
df_list = [df1, df2, df3, df4]
new = [x.set_index('Season')['Finish'].str.extract('(\d+)', expand=False).astype(int)
for x in df_list]
df = pd.concat(new, axis=1, keys=names)
print (df)
Pistons Lions Red Wings Tigers
Season
1950 4 4 1 2
1951 3 2 1 5
1952 4 1 1 8
1953 3 1 1 6
1954 3 1 1 5
df.plot()
plt.gca().invert_yaxis()
plt.title("Season vs Finish Position Graph", fontsize=17)
plt.xlabel('Season (Year)', fontsize=13)
plt.ylabel('Finish Position', fontsize=13)
plt.legend(loc=4, fontsize=10, frameon=False)
plt.show()
添加回答
舉報
0/150
提交
取消