import pandas as pd
import matplotlib.pyplot as plt

class LineChart:


    def __init__(self):

        self._xlsx    = LineChart.getConfig()
        self._xvalues = list()
        self._yvalues = list()


    def doLine(self):

        for i in self._xlsx.index:
            rowData = self._xlsx["날짜"][i], self._xlsx["방문자수"][i]
            self._xvalues.append(rowData[0])
            self._yvalues.append(rowData[1])

        df = pd.DataFrame({"xvalues" : self._xvalues, "yvalues" : self._yvalues})

        # plot
        plt.plot("xvalues", "yvalues", data=df, color="g")
        plt.xlabel("year")
        plt.ylabel("count")
        plt.title("tistory my count")
        plt.show()


    @classmethod
    def getConfig(cls):

        PATH      = "/home/kim/Desktop/PY.dir/stu_01.dir/KimJH_uv.xlsx"
        SHEETNAME = "uv"
        xlxsObj = pd.read_excel(PATH, sheet_name=SHEETNAME)

        return xlxsObj

def main():

    obj = LineChart()
    obj.doLine()

if __name__ == "__main__":
    main()

'python > matplolib' 카테고리의 다른 글

matplotlib => pie_chart + xlsx  (0) 2019.11.02