/sumrows-datacleaning

Reading multiple sheets, sum up each row in each sheet, return dataframe containing sums

Primary LanguageJupyter Notebook

sumrows-datacleaning

Workflow:

  1. read in multiple sheets in excel
  2. for each sheet,
  • perform data cleaning (drop columns, replace text)
  • sum up each row, store series into a variable
  1. concatenate final dataframe with series containing sums