Medical appointment no shows — appointments • qacr

Predicting no-show medical appointments

appointments

Format

A data frame with 110527 rows and 14 variables:

PatientId: double. Identification of a patient.
AppointmentID: double. dentification of each appointment.
Gender: factor. Male, Female.
ScheduledDay: datatime. The day and time of the actual appointment, when they have to visit the doctor.
AppointmentDay: double. The day someone called or registered the appointment, this is before appointment of course.
Age: double. Age of the patient.
Neighbourhood: character. Where the appointment takes place.
Scholarship: integer. 0=FALSE, 1=TRUE. Scholarship is a social welfare program providing financial aid to poor Brazilian families.
Hypertension: integer. 0=FALSE, 1=TRUE.
Diabetes: integer. 0=FALSE, 1=TRUE.
Alcoholism: integer. 0=FALSE, 1=TRUE.
Handcap: integer. 0=FALSE, 1=TRUE.
SMS_received: integer. 0=FALSE, 1=TRUE. 1 or more messages sent to the patient.
No_show: factor. Yes, No.

Source

Joni Hoppen, Kaggle Medical Appointment No Shows https://www.kaggle.com/joniarroba/noshowappointments.

Details

This Kaggle competition was designed to challenge participants to predict office no-shows. It is also a good dataset to practice date and time manipulation.

Examples

summary(appointments)
#>    PatientId         AppointmentID        Gender     
#>  Min.   :3.920e+04   Min.   :5030230   Male  :71840  
#>  1st Qu.:4.173e+12   1st Qu.:5640286   Female:38687  
#>  Median :3.173e+13   Median :5680573                 
#>  Mean   :1.475e+14   Mean   :5675305                 
#>  3rd Qu.:9.439e+13   3rd Qu.:5725524                 
#>  Max.   :1.000e+15   Max.   :5790484                 
#>   ScheduledDay                 AppointmentDay                     Age        
#>  Min.   :2015-11-10 07:13:56   Min.   :2016-04-29 00:00:00   Min.   : -1.00  
#>  1st Qu.:2016-04-29 10:27:01   1st Qu.:2016-05-09 00:00:00   1st Qu.: 18.00  
#>  Median :2016-05-10 12:13:17   Median :2016-05-18 00:00:00   Median : 37.00  
#>  Mean   :2016-05-09 07:49:15   Mean   :2016-05-19 00:57:50   Mean   : 37.09  
#>  3rd Qu.:2016-05-20 11:18:37   3rd Qu.:2016-05-31 00:00:00   3rd Qu.: 55.00  
#>  Max.   :2016-06-08 20:07:23   Max.   :2016-06-08 00:00:00   Max.   :115.00  
#>  Neighbourhood       Scholarship         Diabetes         Alcoholism    
#>  Length:110527      Min.   :0.00000   Min.   :0.00000   Min.   :0.0000  
#>  Class :character   1st Qu.:0.00000   1st Qu.:0.00000   1st Qu.:0.0000  
#>  Mode  :character   Median :0.00000   Median :0.00000   Median :0.0000  
#>                     Mean   :0.09827   Mean   :0.07186   Mean   :0.0304  
#>                     3rd Qu.:0.00000   3rd Qu.:0.00000   3rd Qu.:0.0000  
#>                     Max.   :1.00000   Max.   :1.00000   Max.   :1.0000  
#>     Handcap         SMS_received   No_show      Hypertension   
#>  Min.   :0.00000   Min.   :0.000   No :88208   Min.   :0.0000  
#>  1st Qu.:0.00000   1st Qu.:0.000   Yes:22319   1st Qu.:0.0000  
#>  Median :0.00000   Median :0.000               Median :0.0000  
#>  Mean   :0.02225   Mean   :0.321               Mean   :0.1972  
#>  3rd Qu.:0.00000   3rd Qu.:1.000               3rd Qu.:0.0000  
#>  Max.   :4.00000   Max.   :1.000               Max.   :1.0000