Data cleaning & integration
Duplicate Faculty List into WHD Data
Add individual data from Faculty List duplicated to the CBorn file. Match on username, split @carleton.edu off the email address.
Purpose: These will not be a perfect match. There will be 478 final records; append the the new columns off to the right of the keyed data file (CBorn.) Duplicating information if the same username appears multiple times.
When the data are tidied/merged, upload the result and Paula will fill in any missing information. Paula will then create a duplicate with usernames removed - then you (or someone else) may play with the data to see what we can learn about the profile of our helpdesk activity in the past year-ish*. We don’t care who is calling - we care whether there’s something interesting happening by classifications of people (Pos_EEO_Rank_Desc) or by years at Carleton (Service_Years).
- Partner
- Academic Technology
- Team
- Steven Wu
- Source
- Originally published ↗