Skip to content

Parsing an excel file to extract information about working hours of a employee in company (me :))

Notifications You must be signed in to change notification settings

Vasile-Hij/excels-pandas

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

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

About

Parsing an excel file to extract information about working hours of a employee in company (me :))

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published