notebook.community

Edit and run 





In [79]:



    


import pandas as pd
import numpy as np
import os



    











In [80]:



    


os.chdir('/Users/WhoaaaItsDavid/Desktop/Data Library Projects/Age Friendly Communities/')

rcfe_df = pd.read_csv('ResidentialElderCareFacility01012017.csv')
rcfe_df = rcfe_df[rcfe_df['County Name'] == 'SAN DIEGO']
rcfe_df = rcfe_df[rcfe_df['Facility Status'] != 'CLOSED']
rcfe_df = rcfe_df[rcfe_df['Facility Status'] != 'UNLICENSED']

# Display df
rcfe_df.head(1)



    


















    
Out[80]:










  
    

      
      Facility Type
      Facility Number
      Facility Name
      Licensee
      Facility Administrator
      Facility Telephone Number
      Facility Address
      Facility City
      Facility State
      Facility Zip
      ...
      Regional Office
      Facility Capacity
      Facility Status
      License First Date
      Closed Date
      Last Visit Date
      Inspection Visits
      Complaint Visits
      Other Visits
      Total Visits
    

  
  
    

      8
      RCFE-CONTINUING CARE RETIREMENT COMMUNITY
      374603618
      BROOKDALE CARLSBAD
      S-H OPCO CARLSBAD LLC/BKD TWENTY-ONE MNGMNT CO...
      SASHA HIGHTOWER
      (760) 720-9898
      3140 EL CAMINO REAL
      CARLSBAD
      CA
      92008
      ...
      8
      125.0
      LICENSED
      8/29/14
      NaN
      10/20/16
      0
      8
      7
      15
    

  



1 rows × 21 columns



















In [81]:



    


# Are there any duplicate facilities in rcfe_df?
duplicates_df = rcfe_df[rcfe_df.duplicated(subset='Facility Name', keep=False)]
duplicates_df



    


















    
Out[81]:










  
    

      
      Facility Type
      Facility Number
      Facility Name
      Licensee
      Facility Administrator
      Facility Telephone Number
      Facility Address
      Facility City
      Facility State
      Facility Zip
      ...
      Regional Office
      Facility Capacity
      Facility Status
      License First Date
      Closed Date
      Last Visit Date
      Inspection Visits
      Complaint Visits
      Other Visits
      Total Visits
    

  
  
    

      876
      RESIDENTIAL CARE ELDERLY
      374603563
      AMBASSADOR SENIOR RETREAT II
      AMBASSADOR SENIOR RETREAT LLC
      FAHIMA NAZREEN
      (858) 800-7455
      8554 CAPRICORN WAY
      SAN DIEGO
      CA
      92126
      ...
      8
      6.0
      LICENSED
      4/8/14
      NaN
      9/16/16
      0
      17
      25
      42
    

    

      877
      RESIDENTIAL CARE ELDERLY
      374603755
      AMBASSADOR SENIOR RETREAT II
      NAZREEN LLC
      NAZREEN, FAHIMA
      (858) 800-7455
      8554 CAPRICORN WAY
      SAN DIEGO
      CA
      92126
      ...
      8
      6.0
      PENDING
      NaN
      NaN
      NaN
      0
      0
      0
      0
    

    

      1219
      RESIDENTIAL CARE ELDERLY
      374603560
      ARBORS AT RANCHO PENASQUITOS, THE
      CRP ARBORS RANCHO LLC/INTEGRAL SNR LVG MNGMNT LLC
      TIM BATTON
      (858) 538-0802
      12979 RANCHO PENASQUITOS BLVD
      SAN DIEGO
      CA
      92129
      ...
      8
      120.0
      LICENSED
      12/11/14
      NaN
      12/28/16
      0
      1
      12
      13
    

    

      1220
      RESIDENTIAL CARE ELDERLY
      374603560
      ARBORS AT RANCHO PENASQUITOS, THE
      CRP ARBORS RANCHO LLC/INTEGRAL SNR LVG MNGMNT LLC
      TIFFANY YIN
      (858) 538-0802
      12979 RANCHO PENASQUITOS BLVD
      SAN DIEGO
      CA
      92129
      ...
      8
      120.0
      LICENSED
      12/11/14
      NaN
      10/28/15
      0
      1
      12
      13
    

    

      3172
      RESIDENTIAL CARE ELDERLY
      374601242
      COUNTRY GARDENS
      A* ADVANTAGE HOME CARE, INC.
      BARBARA ZINNER
      (760) 728-5656
      1504 HILLCREST LANE
      FALLBROOK
      CA
      92028
      ...
      8
      16.0
      LICENSED
      5/8/02
      NaN
      11/3/16
      4
      9
      6
      19
    

    

      3173
      RESIDENTIAL CARE ELDERLY
      374603710
      COUNTRY GARDENS
      HILLCREST CARE HOME LLC
      CASTELLANOS, JENNY
      (951) 216-8130
      1504 HILLCREST LANE
      FALLBROOK
      CA
      92028
      ...
      8
      16.0
      PENDING
      NaN
      NaN
      11/8/16
      0
      0
      2
      2
    

    

      3988
      RESIDENTIAL CARE ELDERLY
      374601303
      ENCINITAS RETIREMENT GARDENS
      GAFFNEY, RICA
      RICA GAFFNEY
      (760) 943-8476
      2228 ENCINITAS BLVD
      ENCINITAS
      CA
      92024
      ...
      8
      6.0
      LICENSED
      10/21/02
      NaN
      7/24/15
      1
      2
      2
      5
    

    

      3989
      RESIDENTIAL CARE ELDERLY
      374603737
      ENCINITAS RETIREMENT GARDENS
      ENCINITAS RETIREMENT GARDENS 1 LLC
      SISON, ROBBY ALLEN
      (760) 487-5100
      2228 ENCINITAS BLVD
      ENCINITAS
      CA
      92024
      ...
      8
      6.0
      PENDING
      NaN
      NaN
      NaN
      0
      0
      0
      0
    

    

      5815
      RESIDENTIAL CARE ELDERLY
      374601447
      ISLAND GROVE GUEST HOME II
      RAPAYRAPAY, BABY RUTH G.
      CARMINDA RAMIREZ
      (619) 443-3158
      12624 WILLOW ROAD
      LAKESIDE
      CA
      92040
      ...
      8
      12.0
      LICENSED
      9/20/06
      NaN
      9/8/16
      1
      6
      5
      12
    

    

      5816
      RESIDENTIAL CARE ELDERLY
      374603752
      ISLAND GROVE GUEST HOME II
      LAKESIDE LIVING CORNERSTONE LLC
      RAMIREZ, CARMINDA
      (619) 454-3166
      12624 WILLOW ROAD
      LAKESIDE
      CA
      92040
      ...
      8
      15.0
      PENDING
      NaN
      NaN
      NaN
      0
      0
      0
      0
    

    

      7320
      RESIDENTIAL CARE ELDERLY
      374603589
      MONTE VISTA VILLAGE
      GOODMAN, JOHN B, GP OF MONTE VISTA LODGE LP
      MARIA SHETLER
      (619) 465-1331
      2211 MASSACHUSETTS AVENUE
      LEMON GROVE
      CA
      91945
      ...
      8
      219.0
      PENDING
      NaN
      NaN
      11/14/14
      0
      0
      1
      1
    

    

      7321
      RESIDENTIAL CARE ELDERLY
      374600564
      MONTE VISTA VILLAGE
      GOODMAN, JOHN B. & SIDNEY A.
      MARIA SHETLER
      (619) 465-1331
      2211 MASSACHUSETTS AVENUE
      LEMON GROVE
      CA
      91945
      ...
      8
      225.0
      LICENSED
      11/21/97
      NaN
      2/25/16
      1
      4
      4
      9
    

    

      7687
      RESIDENTIAL CARE ELDERLY
      374603527
      NORTH COUNTY CARE HOME
      OLIVE HAVEN CARE INC
      ALEXANDER LIMPIN
      (858) 842-4608
      15042 AMSO STREET
      POWAY
      CA
      92064
      ...
      8
      6.0
      LICENSED
      1/21/15
      NaN
      12/2/16
      0
      0
      3
      3
    

    

      7688
      RESIDENTIAL CARE ELDERLY
      374603748
      NORTH COUNTY CARE HOME
      LIMPIN, PERLA
      LIMPIN, ALEXANDER
      (858) 842-4608
      15042 AMSO STREET
      POWAY
      CA
      92064
      ...
      8
      6.0
      PENDING
      NaN
      NaN
      NaN
      0
      0
      0
      0
    

    

      7767
      RESIDENTIAL CARE ELDERLY
      374603689
      OAKDALE OF LA MESA
      WL LA MESA PROPERTY, LLC/WESTLIVNG MANAGEMENT,...
      JOEY COLLADO
      (619) 464-6801
      5740 LAKE MURRAY BOULEVARD
      LA MESA
      CA
      91942
      ...
      8
      225.0
      LICENSED
      4/1/16
      NaN
      12/21/16
      0
      0
      5
      5
    

    

      7768
      RESIDENTIAL CARE ELDERLY
      374603679
      OAKDALE OF LA MESA
      LAKE MURRAY HOLDING LLC/WESTLIVING MNGMNT, LLC
      KATHLEEN NABER-JORDAN
      (619) 464-6801
      5740 LAKE MURRAY BOULEVARD
      LA MESA
      CA
      91942
      ...
      8
      225.0
      PENDING
      NaN
      NaN
      NaN
      0
      0
      0
      0
    

    

      7780
      RESIDENTIAL CARE ELDERLY
      374603506
      OAKMONT OF ESCONDIDO HILLS
      OAKMONT SENIOR LIVING LLC
      ROB ALLEN
      (760) 884-8141
      3012 BEAR VALLEY PARKWAY SOUTH
      ESCONDIDO
      CA
      92025
      ...
      8
      143.0
      PENDING
      NaN
      NaN
      NaN
      0
      0
      0
      0
    

    

      7781
      RESIDENTIAL CARE ELDERLY
      374601486
      OAKMONT OF ESCONDIDO HILLS
      OSL MANAGEMENT LLC/OAKMONT MANAGEMENT GROUP
      LAURIE TOMASELLO
      (760) 735-8084
      3012 BEAR VALLEY PKWY SOUTH
      ESCONDIDO
      CA
      92025
      ...
      8
      160.0
      LICENSED
      3/12/03
      NaN
      11/9/16
      1
      8
      5
      14
    

    

      8377
      RESIDENTIAL CARE ELDERLY
      374602972
      PLAZA VILLAGE SENIOR LIVING
      PLAZA VILLAGE SR LVG LLC; CORNERSTON SR LVG LLC
      WESTERMAN, ANGELA
      (619) 474-4844
      960 L AVE
      NATIONAL CITY
      CA
      91950
      ...
      8
      85.0
      LICENSED
      1/10/11
      NaN
      12/22/16
      1
      22
      9
      32
    

    

      8378
      RESIDENTIAL CARE ELDERLY
      374603620
      PLAZA VILLAGE SENIOR LIVING
      PLAZA VILLAGE SENIOR LIVING LLC/CORNERSTONE SE...
      JOSHUA BULLARD
      (619) 474-4844
      950 L AVENUE
      NATIONAL CITY
      CA
      91950
      ...
      8
      85.0
      PENDING
      NaN
      NaN
      NaN
      0
      0
      0
      0
    

    

      8825
      RESIDENTIAL CARE ELDERLY
      374603297
      RIGHT CHOICE SENIOR LIVING LLC
      RIGHT CHOICE SENIOR LIVING LLC
      TODD BROOKS
      (858) 737-4984
      4949 MOUNT LONGS
      SAN DIEGO
      CA
      92117
      ...
      8
      6.0
      LICENSED
      11/1/12
      NaN
      11/2/16
      0
      1
      4
      5
    

    

      8826
      RESIDENTIAL CARE ELDERLY
      374603884
      RIGHT CHOICE SENIOR LIVING LLC
      RIGHT CHOICE SENIOR LIVING LLC
      TODD BROOKS
      (619) 246-2003
      4929 MOUNT LONGS
      SAN DIEGO
      CA
      92117
      ...
      8
      6.0
      LICENSED
      8/30/16
      NaN
      10/6/16
      0
      1
      6
      7
    

    

      9628
      RESIDENTIAL CARE ELDERLY
      374600900
      SILVERCREST GUEST HOME
      PADILLA, JOSEPHINE I.
      JOSEPHINE I. PADILLA
      (619) 475-6459
      8236 WATERVIEW COURT
      SPRING VALLEY
      CA
      91977
      ...
      8
      6.0
      LICENSED
      3/8/00
      NaN
      5/29/15
      1
      1
      0
      2
    

    

      9629
      RESIDENTIAL CARE ELDERLY
      370804404
      SILVERCREST GUEST HOME
      PELINA, AMALIA
      PELINA, AMALIA
      (619) 442-3957
      960 GROSSMONT AVENUE
      EL CAJON
      CA
      92020
      ...
      8
      15.0
      LICENSED
      12/29/93
      NaN
      12/8/16
      1
      5
      2
      8
    

    

      11276
      RESIDENTIAL CARE ELDERLY
      374603781
      VILLA FLORENZA
      VILLA FLORENZA
      DAN
      (760) 807-8585
      5171 ALAMOSA PARK DRIVE
      OCEANSIDE
      CA
      92057
      ...
      8
      6.0
      LICENSED
      NaN
      NaN
      NaN
      0
      0
      0
      0
    

    

      11277
      RESIDENTIAL CARE ELDERLY
      374602543
      VILLA FLORENZA
      PARKER-SANTOS INC.
      DANIEL LEAVITT
      (760) 842-5946
      5171 ALAMOSA PARK DRIVE
      OCEANSIDE
      CA
      92057
      ...
      8
      6.0
      LICENSED
      9/24/07
      NaN
      8/2/12
      1
      1
      0
      2
    

  



26 rows × 21 columns



















In [82]:



    


# We can see that there are 13 duplicate pairs (one of which is a false duplicate)
# Based on Facility Status and Last Visit Date I will drop certain entries
drop_facilities = [877, 1220, 3173, 3989, 5816, 7320, 7688, 7768, 7780, 8378, 8825, 11276]



    











In [83]:



    


# Create a df to answer the question: What is the number of RCFEs in a given community?
rcfe_count_df = rcfe_df[rcfe_df['Facility Status'] != 'PENDING']

# Create a df to answer the queestion: What is the capacity (by licensed bed) in a given community?
rfce_capacity_df = rcfe_df
rfce_capacity_df = rfce_capacity_df[np.logical_not(rfce_capacity_df.index.isin(drop_facilities))] # Drop duplicate facilities



    











In [84]:



    


# Create a list of unique zipcodes within San Diego County
unique_zips = list(rcfe_df['Facility Zip'].unique())

# Create two empty dictionaries using the list of unique zipcodes
count_RCFEs = {}
capacity_RCFEs = {}
for unique_zipcode in unique_zips:
    count_RCFEs[unique_zipcode] = 0
    capacity_RCFEs[unique_zipcode] = 0
    
    
for unique_zipcode in unique_zips:
    # Find the number of RCFEs in each zipcode: count_RCFEs  
    for all_zipcode in rcfe_count_df['Facility Zip']:
        if unique_zipcode == all_zipcode: 
            count_RCFEs[unique_zipcode] += 1
            
    # Find the capacity within each zipcode: capacity_RCFEs            
    for all_zipcode in rfce_capacity_df['Facility Zip']:
        if unique_zipcode == all_zipcode:
            temp_df = q1_df[q1_df['Facility Zip'] == unique_zipcode]
            capacity_RCFEs[unique_zipcode] = temp_df['Facility Capacity'].sum()



    











In [85]:



    


# What is the capacity (by licensed bed) in a given community?
print('There are', len({k:v for k, v in capacity_RCFEs.items() if v}), 'zipcodes.')
for zipcode in sorted(capacity_RCFEs.keys()):
    if capacity_RCFEs[zipcode] != 0:
        print('Zipcode', zipcode, 'has a capacity of', capacity_RCFEs[zipcode])



    


















    






There are 72 zipcodes.
Zipcode 91901 has a capacity of 56.0
Zipcode 91902 has a capacity of 54.0
Zipcode 91910 has a capacity of 861.0
Zipcode 91911 has a capacity of 113.0
Zipcode 91913 has a capacity of 300.0
Zipcode 91914 has a capacity of 192.0
Zipcode 91932 has a capacity of 32.0
Zipcode 91935 has a capacity of 6.0
Zipcode 91941 has a capacity of 92.0
Zipcode 91942 has a capacity of 736.0
Zipcode 91945 has a capacity of 353.0
Zipcode 91950 has a capacity of 391.0
Zipcode 91977 has a capacity of 531.0
Zipcode 92003 has a capacity of 13.0
Zipcode 92004 has a capacity of 6.0
Zipcode 92007 has a capacity of 175.0
Zipcode 92008 has a capacity of 728.0
Zipcode 92009 has a capacity of 1509.0
Zipcode 92014 has a capacity of 6.0
Zipcode 92019 has a capacity of 375.0
Zipcode 92020 has a capacity of 228.0
Zipcode 92021 has a capacity of 161.0
Zipcode 92024 has a capacity of 482.0
Zipcode 92025 has a capacity of 745.0
Zipcode 92026 has a capacity of 1099.0
Zipcode 92027 has a capacity of 401.0
Zipcode 92028 has a capacity of 298.0
Zipcode 92029 has a capacity of 249.0
Zipcode 92037 has a capacity of 641.0
Zipcode 92040 has a capacity of 80.0
Zipcode 92054 has a capacity of 30.0
Zipcode 92056 has a capacity of 668.0
Zipcode 92057 has a capacity of 102.0
Zipcode 92058 has a capacity of 12.0
Zipcode 92064 has a capacity of 308.0
Zipcode 92065 has a capacity of 39.0
Zipcode 92069 has a capacity of 103.0
Zipcode 92071 has a capacity of 182.0
Zipcode 92075 has a capacity of 136.0
Zipcode 92078 has a capacity of 614.0
Zipcode 92081 has a capacity of 174.0
Zipcode 92082 has a capacity of 13.0
Zipcode 92083 has a capacity of 153.0
Zipcode 92084 has a capacity of 441.0
Zipcode 92101 has a capacity of 230.0
Zipcode 92103 has a capacity of 300.0
Zipcode 92104 has a capacity of 9.0
Zipcode 92105 has a capacity of 40.0
Zipcode 92106 has a capacity of 29.0
Zipcode 92107 has a capacity of 6.0
Zipcode 92108 has a capacity of 227.0
Zipcode 92109 has a capacity of 653.0
Zipcode 92110 has a capacity of 179.0
Zipcode 92111 has a capacity of 45.0
Zipcode 92113 has a capacity of 6.0
Zipcode 92114 has a capacity of 164.0
Zipcode 92115 has a capacity of 373.0
Zipcode 92117 has a capacity of 419.0
Zipcode 92118 has a capacity of 120.0
Zipcode 92119 has a capacity of 75.0
Zipcode 92120 has a capacity of 66.0
Zipcode 92122 has a capacity of 855.0
Zipcode 92123 has a capacity of 45.0
Zipcode 92124 has a capacity of 18.0
Zipcode 92126 has a capacity of 181.0
Zipcode 92127 has a capacity of 662.0
Zipcode 92128 has a capacity of 330.0
Zipcode 92129 has a capacity of 264.0
Zipcode 92130 has a capacity of 131.0
Zipcode 92131 has a capacity of 6.0
Zipcode 92139 has a capacity of 89.0
Zipcode 92154 has a capacity of 30.0

















In [86]:



    


# What is the number of RCFEs in a given community?
print('There are', len({k:v for k, v in count_RCFEs.items() if v}), 'zipcodes.')
for zipcode in sorted(count_RCFEs.keys()):
    if count_RCFEs[zipcode] != 0:
        print('Zipcode', zipcode, 'has a capacity of', count_RCFEs[zipcode])



    


















    






There are 72 zipcodes.
Zipcode 91901 has a capacity of 3
Zipcode 91902 has a capacity of 9
Zipcode 91910 has a capacity of 13
Zipcode 91911 has a capacity of 10
Zipcode 91913 has a capacity of 1
Zipcode 91914 has a capacity of 3
Zipcode 91932 has a capacity of 1
Zipcode 91935 has a capacity of 1
Zipcode 91941 has a capacity of 7
Zipcode 91942 has a capacity of 13
Zipcode 91945 has a capacity of 5
Zipcode 91950 has a capacity of 10
Zipcode 91977 has a capacity of 10
Zipcode 92003 has a capacity of 3
Zipcode 92004 has a capacity of 1
Zipcode 92007 has a capacity of 1
Zipcode 92008 has a capacity of 10
Zipcode 92009 has a capacity of 20
Zipcode 92014 has a capacity of 1
Zipcode 92019 has a capacity of 13
Zipcode 92020 has a capacity of 12
Zipcode 92021 has a capacity of 10
Zipcode 92024 has a capacity of 11
Zipcode 92025 has a capacity of 20
Zipcode 92026 has a capacity of 23
Zipcode 92027 has a capacity of 33
Zipcode 92028 has a capacity of 13
Zipcode 92029 has a capacity of 7
Zipcode 92037 has a capacity of 14
Zipcode 92040 has a capacity of 8
Zipcode 92054 has a capacity of 5
Zipcode 92056 has a capacity of 6
Zipcode 92057 has a capacity of 17
Zipcode 92058 has a capacity of 2
Zipcode 92064 has a capacity of 29
Zipcode 92065 has a capacity of 3
Zipcode 92069 has a capacity of 15
Zipcode 92071 has a capacity of 9
Zipcode 92075 has a capacity of 2
Zipcode 92078 has a capacity of 8
Zipcode 92081 has a capacity of 7
Zipcode 92082 has a capacity of 2
Zipcode 92083 has a capacity of 7
Zipcode 92084 has a capacity of 29
Zipcode 92101 has a capacity of 2
Zipcode 92103 has a capacity of 2
Zipcode 92104 has a capacity of 1
Zipcode 92105 has a capacity of 1
Zipcode 92106 has a capacity of 3
Zipcode 92107 has a capacity of 1
Zipcode 92108 has a capacity of 4
Zipcode 92109 has a capacity of 4
Zipcode 92110 has a capacity of 3
Zipcode 92111 has a capacity of 8
Zipcode 92113 has a capacity of 1
Zipcode 92114 has a capacity of 26
Zipcode 92115 has a capacity of 7
Zipcode 92117 has a capacity of 13
Zipcode 92118 has a capacity of 1
Zipcode 92119 has a capacity of 13
Zipcode 92120 has a capacity of 10
Zipcode 92122 has a capacity of 13
Zipcode 92123 has a capacity of 8
Zipcode 92124 has a capacity of 3
Zipcode 92126 has a capacity of 31
Zipcode 92127 has a capacity of 6
Zipcode 92128 has a capacity of 3
Zipcode 92129 has a capacity of 6
Zipcode 92130 has a capacity of 2
Zipcode 92131 has a capacity of 1
Zipcode 92139 has a capacity of 15
Zipcode 92154 has a capacity of 5

















In [ ]:

Content source: sandiegodata/age-friendly-communities

Similar notebooks:

notebook.community | gallery | about