openpyxl1 엑셀 파일 요약 import pandas as pdimport openpyxlfrom openpyxl.styles.fonts import Fonttry: for a in range(1,4): for b in range(1,13): df1 = pd.read_excel('출석부/원생출석부 202'+str(a)+'년 '+str(b)+'월.xlsx') df1 = df1.fillna(0) day = [] names=[] walker =['박희수','이유수','정은지','웬하늘','박철현','정다은'] for i in range(3,len(df1),2): names.ap.. 2023. 6. 2. 이전 1 다음 728x90 반응형
