course project values

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.