Python 練習

num = len(sheet_names)
max_inflow = pd.DataFrame()

for i in range(num):
    wb = pd.read_excel("masudagawa_YearlyReport.xlsx", header=5, sheet_name=sheet_names[i])

    word = '流入量'
    column_word = [column for column in wb.columns if word in column]
    wb1 = pd.DataFrame(wb[column_word])
    max = pd.DataFrame(wb1.iloc[33])
    max.columns = ['max_inflow']
    max_inflow = max_inflow.append(max, ignore_index=True)
    
print(max_inflow)