Time Series Analysis of Medical Appointments

Project Description

The “Healthcare Appointments Analytics” project is a comprehensive data analysis initiative that delves into the intricacies of medical appointments and explores factors influencing patient attendance and no-show rates. By leveraging advanced analytical techniques, the project aims to uncover valuable insights that can positively impact patient engagement and resource allocation in healthcare settings.

Overview:

• Read the raw data using pandas and create a dataframe.
• Check for duplicates, null values and take necessary actions.
• Appropriate data type conversion for the columns.
• Creating new feature(s) as required from the given dataset.
• Drop unnecessary columns from the dataframe and export the dataset as a .csv file.
• Use the exported dataset to create a database and use SQL to extract insights using any SQL client (MySQL Workbench).
• Used jupyter notebook to show the results as it is easy to share and visualize the code and output.