matplotlib => line_chart + excel
python/matplolib2019. 11. 2. 19:04
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 |
---|