Additional EDA questions

[robperch]

Additional questions:

Priority

• [x] With how much time in advance are the consultations scheduled? (overall and per specialty)
• [x] How many appointments datapoints do we have in the database?
• [x] How many of the no-shows are patients that were confirmed?
• [x] How many of the patients register a phone number?
• [x] How does the no-show behavior vary by time of day? At what starting time do appointments most frequently result in no-shows?
• [x] How do no shows behave per week day?
• [ ] What was the final status of the appointments that were confirmed?
• [ ] What are the most popular times of day when appointments are scheduled @robperch
• [ ] How does the different appointment outcomes look like by time between creation and termination? @robperch
• [x] How many patients have location info included @robperch
• [ ] The no show rate changes per doctor?
• [ ] With how much time in advance are appointments confirmed?

  Additional

• [ ] With how much time in advance are the appointments canceled?
• [ ] How many of the patients receive a message/call to confirm their appointment?
• [ ] What's the distribution of the scheduling channels? (phone, online)
• [ ] What are the specialists with the longest waiting list?
• [ ] How many of the appointments were canceled automatically? @robperch

[robperch]

Hey @jefwei , for the patient number, you can find that data in the table ‘pacientetelefono' and the feature 'pacientettel’