BigData + graph

import openpyxl
import matplotlib.pyplot as plt

def barChart(data, labels):
    num_bars = len(data)
    positions = range(1, num_bars + 1)
    plt.barh(positions, data, align='center')
    plt.yticks(positions, labels)
    plt.grid()
    plt.show()

def main():
    # 엑셀 파일 열기
    wb = openpyxl.load_workbook('s.xlsx')

    # 현재 Active Sheet 얻기
    ws = wb.active

    yearData = []
    sData = []
    num = 1
    for r in ws.rows:
        #print (r)
        if (num == 1):
            num += 1
            continue
        else: # num != 1
            sData.append(r[1].value)
            yearData.append(r[0].value)
    print (sData, yearData)
    barChart(sData, yearData)
if __name__ == "__main__":
    main()