Analysing an excel file with pandas in jupyter notebook
The script it will display the following results:
- Read file
- Display all name of the columns
- Display total rows and columns
- Sum all indexes (weekdays only)
- Display full table
- Sum all weekdays by index in a new column
- Get the longest week
- Get the shortest week
- Sum all weekdays by column
- Display sum of each weekday by column in bar chart
- Display sum of each weekday by column in pie chart
- Sum all working hours from all weeks