ANLY482 AY2017-18T2 Group19 Project Findings

HOME

PROJECT OVERVIEW

PROJECT FINDINGS

PROJECT MANAGEMENT

DOCUMENTATION

BACK TO MAIN PAGE

 

DATA CLEANING AND PREPARATION

DATA EXPLORATION FINDINGS

 

ADDITIONAL COLUMNS

The same fields were added into the 3-hour and 3-day datasets with the sole intention of facilitating our data exploratory. All calculations were performed in JMP. The following fields were included:

No.	Name of Field	Description
01	Loan_Timestamp	This variable is a result of concatenating the ‘loan_date’ and ‘loan_time’ variables into a single field. This enhances the ease-of-use and aesthetic appeal.
02	Return_Timestamp	This variable is a result of concatenating the ‘return_date’ and ‘return_time’ variables into a single field. This enhances the ease-of-use and aesthetic appeal.
03	Term	This allows us to segment the ‘loan_timestamp’ into academic terms to allow us to breakdown the analysis later on. We got the various academic terms start and end dates from the SMU’s official academic calendar document and applied an IF() logical statement to classify the various loan timestamps into the different academic terms.
04	Hours_borrowed	This variable refers to the number of hours borrowed per transaction. It is derived by calculating the date difference between the ‘return_timestamp’ and ‘loan_timestamp’ in terms of hours. This could potentially help us in understanding the usage patterns per borrow.
05	Assigned_loan_period	This variable refers to the amount of hours a user is entitled to when borrowing a book. The library’s policy is as follows: Depending on the hour in which the transaction occurs, the hours of usage allowed to the user differs. As such, we created a calculated field in which follows the above-mentioned rules by utilizing an IF() logical statement.
06	Sufficiency_measure	This variable was created with intentions to further our analysis on the extent of user usage patterns. Given the varying assigned loan periods, we believed that it was necessary to take this variable into account when analyzing if a loan period is currently sufficient for users. As such, ‘sufficiency_measure’ is calculated by deducting ‘assigned_loan_period’ from ‘hours_borrowed’. A positive value would indicate that the current loan period assigned is adequate for the users while a negative sufficiency measure would indicate otherwise.
07	Exam_week	This variable classifies ‘loan_timestamp’ into whether they occur during exam periods as stipulated in SMU’s official academic calendar. We believe that usage patterns may be influenced during examinations. This variable is a binary variable, whereby the observations only displays ‘Y’ for ‘Yes’ or ‘N’ for ‘No’.
08	Break_week	This variable classifies ‘loan_timestamp’ into whether they occur during break weeks (week 14), the week before the exam weeks as stipulated in SMU’s official academic calendar. We believe that usage patterns may be influenced during the week before examinations. This variable is a binary variable, whereby the observations only displays ‘Y’ for ‘Yes’ or ‘N’ for ‘No’.
09	Part_of_day	This variable refers to the part of day the ‘loan_timestamp’ occurs, whether the book loan occurs in the ‘morning’, ‘afternoon’, or ‘night’.

 

MISSING VALUES

We performed a ‘Summary Statistics’ for all the columns in our 3-hour and 3-day datasets in order to identify the number of observations with missing values. Missing data have the potential to influence our findings and conclusions drawn from the data, and as such, it was essential that we performed this analysis to sieve out how much missing data we have in the datasets and subsequently, decide on how we would like to proceed on from there.

Dataset	Before	After
3-Hour Transaction Dataset	Total = 13281	Total = 12958
3-Day Transaction Dataset		Total = 1401