seif-mohamed1 / medical-appointment-

Analysis, EDA, and answer some questions.

Medical-Appointment-

Analysis, EDA, and answer some questions.

Project: Medical Appointment _ No Shows

Table of Contents

• Data Dictionary
• Introduction
• Data Wrangling
• Exploratory Data Analysis
• Conclusions

Data Dictionary

01 - PatientId

Identification of a patient

02 - AppointmentID

Identification of each appointment

03 - Gender

Male or Female 

04 - DataMarcacaoConsulta

The day of the actuall appointment, when they have to visit the doctor.

05 - DataAgendamento

The day someone called or registered the appointment, this is before appointment of course.

06 - Age

How old is the patient.

07 - Neighbourhood

Where the appointment takes place.

08 - Scholarship

True of False. 

09 - Hipertension

True or False

10 - Diabetes

True or False

Alcoholism

True or False

Handcap

True or False

SMS_received

1 or more messages sent to the patient.
No-show
True or False.

Introduction

This data works on the problem that 30% of patients miss their scheduled appointments.So we have to analyze this data and find out the problem. Let's put some questions that need an answer.

The main question is why 30% of patients miss their scheduled appointments?

Does the patient's gender affect attendance?

What affects patients and makes them not attend their scheduled appointments?