Read Inventory

[amhanson9]

Read the Hub inventory, which is an Excel spreadsheet with one sheet per share, into a single dataframe. There are currently 11 shares and the same 7 columns in each sheet.

Cleanup needed:

• Remove the instruction row, which is the second row in each sheet and explains what belongs in a column.
• Remove rows for content that has been deleted, which will have a value in the last column.
• Remove empty rows, which happens if someone clears a row after content is deleted
• Rename columns, which are long and include parentheses, to streamline the rest of the code

Also add new columns for the three error types: Audit_Dates, Audit_Inventory, Audit_Required.

[amhanson9]

Resources: https://www.statology.org/combine-multiple-excel-sheets-pandas/ https://stackoverflow.com/questions/18172851/deleting-dataframe-row-in-pandas-based-on-column-value https://stackoverflow.com/questions/16327055/how-to-add-an-empty-column-to-a-dataframe