python - Putting a pandas datagram column into excel

Question

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

Answer 1

Waitting for answers