Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
more formatting