Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I am trying to create and excel output with multiple sheet. This is what i've come up with so far.
with output.get_writer("Summary_File"+current_day+".xlsx") as writer: report_df.to_excel(writer, sheet_name='summary') cleaned_inbound_prepared_distinct_prepared_joined_df.to_excel(writer, sheet_name='Duplicates') distinct_biomakers_df.to_excel(writer, sheet_name='Biomakers') distinct_subjid_df.to_excel(writer, sheet_name='SubjectIDS') distinct_visits_df.to_excel(writer, sheet_name='Vists') all_df.to_excel(writer, sheet_name='numeric') less_than_df.to_excel(writer, sheet_name='non_numeric')
Operating system used: windows