GSA / GSA/MG_WB2

ENH: Join Absenteeism and IEQ Datasets

Open
#3 5 comments 0 reactions 1 assignee Claimed by @kstreepy View on GitHub
enhancement help wanted
Dominant language
Jupyter Notebook
Stars
0
Forks
2
PR merge metrics
No merged PRs in 30d

Description

## User story
As a fictitious employee of MG, I want to see if there's a relationship between IEQ and employee absenteeism so that we can make a stronger case for monitoring IEQ as a part of the Total Workplace pilot.

## Acceptance criteria
In order to perform this analysis, we'll need to use the BookIt data to figure out where each employee in the absenteeism dataset sits. Naturally, a single individual will book a number of different workstations (if they're even using BookIt at all) so we'll need to use some rule-of-thumb to determine which workstation/wing we assign to them. Taking the mode of their bookings might be good. Then, once we've got a physical location for the employees in the absenteeism dataset, we can join that to the IEQ data on the physical location and date. If the dates in the datasets don't overlap, we should adjust them so that they do. If this results in a join that gives us enough data to work with, then we can request the right time periods from HR for the absenteeism/bookit datasets.

- [x] ReadMe updated with notes on where/how to access the required data.
- [ ] A single dataframe where each row is an employee with columns containing the relevant fields from the absenteeism dataset and IEQ datasets. This dataframe should include employees that weren't in the absenteeism dataset as we want to include in our sample folks that did not take leave as well.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.