Using the attached CSV file, write a Python script that can perform following tasks.
- Step 1: Find out all the occurrences where No-Show record is either blank or Missing
- Step 2: Replace it with NaN values
- Step 3: Ignore NaN values from the calculation and determine PatientID, Count(No-Show=Yes)
- Step 4: Ignore NaN values from the calculation and determine Calculate Neighbourhood, count(No-Shows=Yes)
For your submission, include the following:
- Attach a Python script.
- An output screenshot.