언어/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()