언어/python

openpyxl + numpy + matplotlib

파아랑새 2017. 12. 26. 17:51
import openpyxl as opxl
import matplotlib.pyplot as plt
import numpy as np
import re
def main():
# 엑셀 파일 열기
wb = opxl.load_workbook("C:\\Users\\sleep\\Desktop\\data.xlsx")

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

# for Rvalue in ws.rows:
# print (Rvalue)

SheetV = [v for v in ws.rows]
t_x = list()
t_y = list()
for i in range(1, len(SheetV)):
x, y = SheetV[i][0].value, SheetV[i][1].value
t_x.append(int(x))
if "=" in y:
y = y.replace("=", "")
k = y.split('*')[0]
t_y.append(int(ws[k].value)*2)

plt.plot(t_x, t_y, 'yo')
plt.show()

if __name__ == "__main__":
main()