What I am trying to do is to generate a data frame column using pandas and put it into an excel sheet.
wb = load_workbook(excel_file_path_from_db)
ws = wb["Sheet3"]
df = pd.read_excel(excel_file_path_from_db, engine='openpyxl', sheet_name='Sheet3')
grade_sum = df['Grade 1'] + df['Grade 2']
df['Pass/Fail'] = np.where(grade_sum > 60, 'Pass', 'Fail')
column_for_excel = df['Pass/Fail']
ws.cell(column=4, row=1, value= column_for_excel)
wb.save(excel_file_path_from_db)
But this doesn't work. and what i get in the terminal is: Name: Pass/Fail, dtype: object to Excel
question from:
https://stackoverflow.com/questions/65923193/putting-a-pandas-datagram-column-into-excel 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…