search

uga-libraries / format-report

Aggregate and analyze csv files with file format information generated by the UGA Libraries' digital preservation system (ARCHive).
Creative Commons Attribution Share Alike 4.0 International
0 stars 0 forks source link

Save to Excel sooner? #34

Closed amhanson9 closed 8 months ago

amhanson9 commented 1 year ago

Currently calculates 15 dataframes before saving at the end to Excel. Benefits of saving to Excel after each dataframe is calculated: part of the functions calculating the dataframe instead of a long thing at the end, don't need unique names for each dataframe, and will have some information saved if the script breaks mid-analysis.

amhanson9 commented 12 months ago

Would have to change from using ExcelWriter, which does not have the ability to add to an existing spreadsheet. https://stackoverflow.com/questions/46672207/add-worksheet-to-existing-excel-file-with-pandas

amhanson9 commented 12 months ago

If implement issue 15 (different spreadsheets for different groups of data), that may simplify enough and make this change unnecessary.

amhanson9 commented 8 months ago

Did implement issue 15. Now that it saves a spreadsheet after a type of analysis is done, that is sufficient.