python3 pandas matplotlib绘图

def test03():
    INPUTFILE1 = os.path.join(BASE_PATH, 'Students1.xlsx')
    datas = ExcelUntil.readExcelFile(INPUTFILE1, headerRow=0)
    for sheetname,sheetdatas in datas.items():
        print(sheetdatas.head(8))
        sheetdatas['Number'] = sheetdatas['Number'].astype('int')
        sheetdatas.sort_values(by='Number',ascending=True,inplace=True) # false 从大到小
        print(sheetdatas.head(8))
        plt.bar(sheetdatas['Field'],sheetdatas['Number'],color='orange',width=0.7)
        plt.xticks(sheetdatas['Field'],rotation='60')
        plt.title('International Students by Field',fontsize=16)
        plt.xlabel('Field')
        plt.ylabel('Number')
        plt.tight_layout()
        plt.show()

def test04():
    INPUTFILE1 = os.path.join(BASE_PATH, 'Students2.xlsx')
    datas = ExcelUntil.readExcelFile(INPUTFILE1, headerRow=0)
    for sheetname,sheetdatas in datas.items():
        print(sheetdatas.head(8))
        sheetdatas['2016'] = sheetdatas['2016'].astype('int')
        sheetdatas['2017'] = sheetdatas['2017'].astype('int')
        sheetdatas.sort_values(by='2016',ascending=True,inplace=True) # false 从大到小
        bar_width = 0.7
        x_pos = np.arange(len(sheetdatas) * 2, step=2)
        plt.bar(x_pos, sheetdatas['2016'], color='green', width=bar_width)
        plt.bar(x_pos + bar_width, sheetdatas['2017'], color='blue', width=bar_width)
        plt.xticks(x_pos + bar_width / 2, sheetdatas['Field'], rotation='90')
        plt.title('International Student by Field', fontsize=16)
        plt.xlabel('Field')
        plt.ylabel('Number')
        plt.tight_layout()
        plt.show()

def test05():
    INPUTFILE1 = os.path.join(BASE_PATH, 'Students2.xlsx')
    datas = ExcelUntil.readExcelFile(INPUTFILE1, headerRow=0)
    for sheetname,sheetdatas in datas.items():
        print(sheetdatas.head(8))
        sheetdatas['2016'] = sheetdatas['2016'].astype('int')
        sheetdatas['2017'] = sheetdatas['2017'].astype('int')
        sheetdatas.sort_values(by='2017',ascending=False,inplace=True) # false 从大到小
        sheetdatas.plot.bar('Field', ['2016', '2017'], color=['orange', 'Red'])
        plt.title('International Students by Field', fontsize=16)
        plt.xlabel('Field', fontweight='bold')
        plt.ylabel('Number', fontweight='bold')
        ax = plt.gca()
        ax.set_xticklabels(sheetdatas['Field'], rotation=40, ha='right')
        plt.gcf().subplots_adjust(left=0.2, bottom=0.42)
        plt.show()

def test06():
    INPUTFILE1 = os.path.join(BASE_PATH, 'Users.xlsx')
    datas = ExcelUntil.readExcelFile(INPUTFILE1, headerRow=0)
    for sheetname, sheetdatas in datas.items():
        print(sheetdatas.head(8))
        sheetdatas['Oct'] = sheetdatas['Oct'].astype('int')
        sheetdatas['Nov'] = sheetdatas['Nov'].astype('int')
        sheetdatas['Dec'] = sheetdatas['Dec'].astype('int')
        sheetdatas['Total']=sheetdatas['Oct']+sheetdatas['Nov']+sheetdatas['Dec']
        sheetdatas.sort_values(by='Total', ascending=False, inplace=True)  # false 从大到小
        sheetdatas.plot.bar(x='Name',y= ['Oct', 'Nov','Dec'], color=['orange', 'Red','yellow'])
        plt.tight_layout()
        plt.show()

def test07():
    INPUTFILE1 = os.path.join(BASE_PATH, 'Students3.xlsx')
    datas = ExcelUntil.readExcelFile(INPUTFILE1, headerRow=0,indexCol='From')
    for sheetname, sheetdatas in datas.items():
        print(sheetdatas.head(8))
        sheetdatas['2017'] = sheetdatas['2017'].astype('int')
        sheetdatas['2017'].plot.pie(fontsize=8,counterclock=False,startangle=-270)
        plt.title('Source of International Students', fontsize=16, fontweight='bold')
        plt.ylabel('2017',fontsize=12,fontweight='bold')
        plt.show()

def test08():
    INPUTFILE1 = os.path.join(BASE_PATH, 'Orders.xlsx')
    datas = ExcelUntil.readExcelFile(INPUTFILE1, headerRow=0,indexCol='Week')
    for sheetname, sheetdatas in datas.items():
        print(sheetdatas.head(8))
        sheetdatas['Accessories'] = sheetdatas['Accessories'].astype('float')
        sheetdatas['Bikes'] = sheetdatas['Bikes'].astype('float')
        sheetdatas['Clothing'] = sheetdatas['Clothing'].astype('float')
        sheetdatas['Components'] = sheetdatas['Components'].astype('float')
        sheetdatas['Grand Total'] = sheetdatas['Grand Total'].astype('float')
        # sheetdatas.plot(y=['Accessories','Bikes','Clothing','Components'])
        sheetdatas.plot.area(y=['Accessories','Bikes','Clothing','Components'])
        plt.title('Source of International Students', fontsize=16, fontweight='bold')
        plt.xticks(sheetdatas.index,fontsize=12)
        plt.show()