-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathcompile_race_ethnicity_data.py
More file actions
172 lines (162 loc) · 13.1 KB
/
compile_race_ethnicity_data.py
File metadata and controls
172 lines (162 loc) · 13.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
"""
"""
import pandas as pd
from count_by_race import raceCountByProvider
from tkinter.filedialog import askopenfilename
from tkinter.filedialog import asksaveasfilename
class CreateCombinedEthnicityData:
def __init__(self):
self.entry_data = pd.read_excel(askopenfilename(title="Service Data"))
self.providers = {
"Transition Projects (TPI) Rent - MGF (STRA) - HP(6712)": "Placement Provider",
"Transition Projects (TPI) - Walnut Park Shelter(6853)": "Walnut Park Shelter",
"Transition Projects (TPI) - SSVF - HP (VA)(6351)": "Vets",
"Impact Northwest - SSVF_18-OR-399 – Rapid Re-Housing (VA)(6366)": "Vets",
"Transition Projects (TPI) - SSVF - RRH (VA)(6350)": "Vets",
"Impact Northwest - SSVF_Renewal 15-ZZ-127 - Homeless Prevention (VA) - SP(4794)": "Vets",
"Impact Northwest - SSVF_Renewal 15-ZZ-127 - Rapid Re-Housing (VA) - SP(4795)": "Vets",
"Ticket Home - Served (OR-501)(5431)": "Outreach",
"Transition Projects (TPI) - ACCESS - CM(5471)": "Housing CM",
"Transition Projects (TPI) - Agency - SP(19)": "",
"Transition Projects (TPI) - Clark Center - SP(25)": "Clark Center",
"Transition Projects (TPI) - Clark Center Corrections Beds(6035)": "Clark Center",
"Transition Projects (TPI) - Clark Guest Beds - SP(3071)": "Clark Center",
"Transition Projects (TPI) - Columbia Shelter(6527)": "Columbia Shelter",
"Transition Projects (TPI) - Coordinated Housing Access Team (CHAT)(5965)": "Outreach",
"Transition Projects (TPI) - Day Center - SP(26)": "Resource Center",
"Transition Projects (TPI) - Destination Housing - RRH(6284)": "Placement Provider",
"Transition Projects (TPI) - Doreen's Place - SP(28)": "Doreen's Place",
"Transition Projects (TPI) - Doreen's Place Guest Beds - SP(3072)": "Doreen's Place",
"Transition Projects (TPI) - Health Connections - SERVICES ONLY(6481)": "Health and Wellness",
"Transition Projects (TPI) - Health Navigation(6050)": "Health and Wellness",
"Transition Projects (TPI) - Holgate Project(6486)": "Placement Provider",
"Transition Projects (TPI) - Housing Choice Voucher(5961)": "Placement Provider",
"Transition Projects (TPI) - Housing Services - SP(27)": "Housing CM",
"Transition Projects (TPI) - Jean’s Place VA Grant Per Diem (GPD) - SP(3362)": "Jean's Place",
"Transition Projects (TPI) - Jean's Place L1 - SP(29)": "Jean's Place",
"Transition Projects (TPI) - Jean's Place Corrections(6231)": "Jean's Place",
"Transition Projects (TPI) - Mental Health Programming - SP(3175)": "Health and Wellness",
"Transition Projects (TPI) - Oregon Vets (OHA) - PSH(5744)": "Vets",
"Transition Projects (TPI) - Outreach - SP(3782)": "Outreach",
"Transition Projects (TPI) - PGE Veteran Families - HP(6484)": "Placement Provider",
"Transition Projects (TPI) - Residential - CM(5473)": "Housing CM",
"Transition Projects (TPI) - Retention - CM(5472)": "Retention CM",
"Transition Projects (TPI) - SOS Shelter(2712)": "SOS Shelter",
"Transition Projects (TPI) - SSVF_18-OR-399 – Homeless Prevention (VA)(6351)": "Vets",
"Transition Projects (TPI) - SSVF_18-OR-399 – Rapid Re-Housing (VA)(6350)": "Vets",
"Transition Projects (TPI) - SSVF_18-OR-399 – SSVF_Screening (VA)(6352)": "Vets",
"Transition Projects (TPI) - SSVF_C15-OR-501A - Homeless Prevention (VA) - SP(4803)": "Vets",
"Transition Projects (TPI) - SSVF_C15-OR-501A - Rapid Re-Housing (VA) - SP(4804)": "Vets",
"Transition Projects (TPI) - SSVF_Renewal 15-ZZ-127 - Homeless Prevention (VA) - SP(4801)": "Vets",
"Transition Projects (TPI) - SSVF_Renewal 15-ZZ-127 Rapid Re-Housing (VA) - SP(4802)": "Vets",
"Transition Projects (TPI) - SSVF_Screening C15-OR-501A (VA) - SP(4805)": "Vets",
"Transition Projects (TPI) - SSVF_Screening_15-ZZ-127 (VA) - SP(4870)": "Vets",
"Transition Projects (TPI) - Substance Abuse Programming (IAP) - SP(3168)": "Health and Wellness",
"Transition Projects (TPI) - Substance Abuse Programming (PIAP) - SP(6074)": "Health and Wellness",
"Transition Projects (TPI) - Support Services - Employment(6593)": "Employment",
"Transition Projects (TPI) - Support Services(4325)": "",
"Transition Projects (TPI) - Titan Manor - HP(6277)": "Placement Provider",
"Transition Projects (TPI) - VA Grant Per Diem (inc. Doreen's Place GPD) - SP(3189)": "Doreen's Place",
"Transition Projects (TPI) - Wellness Access(6051)": "Health and Wellness",
"Transition Projects (TPI) - Willamette Center(5764)": "Willamette Shelter",
"Transition Projects (TPI) - Women's Housing Program - RRH(6153)": "Placement Provider",
"Transition Projects (TPI) - WyEast Emergency Shelter(6612)": "WyEast Shelter",
"Transition Projects (TPI) -CCC-PSH-Scattered Site-NonADFC-HOPE-PSH Subsidy-(4999)": "Placement Provider",
"Transition Projects (TPI) Housing - Barbara Maher Apartments PSH - SP(3018)": "Barbara Maher Shelter",
"Transition Projects (TPI) Housing - Clark Annex GPD - SP(4259)": "Clark Center Annex Shelter",
"Transition Projects (TPI) Housing - Clark Annex PSH - SP(2858)": "Clark Center Annex Shelter",
"Transition Projects (TPI) Rent - Collaboration (HUD) - SP(2563)": "Placement Provider",
"Transition Projects (TPI) Rent - EHA Vets (STRA) - HP(5794)": "Vets",
"Transition Projects (TPI) Rent - EHA Vets (STRA) - RRH(4930)": "Vets",
"Transition Projects (TPI) Rent - EHA (STRA) - HP(6328)": "Placement Provider",
"Transition Projects (TPI) Rent - EHA (STRA) - RRH(6327)": "Placement Provider",
"Transition Projects (TPI) Rent - Horizons (HUD) - SP(52)": "Placement Provider",
"Transition Projects (TPI) Rent - Housing for Veterans (PHB)(5138)": "Vets",
"Transition Projects (TPI) Rent - Human Solutions Safehome (HUD) - SP(3792)": "Placement Provider",
"Transition Projects (TPI) Rent - MGF (STRA) - RRH(6711)": "Placement Provider",
"Transition Projects (TPI) Rent - OTIS (HUD) - SP(56)": "Placement Provider",
"Transition Projects (TPI) Rent - Portland Housing Bureau (PHB) - SP(3219)": "Placement Provider",
"Transition Projects (TPI) Rent - START (HUD) - RRH(4431)": "Placement Provider",
"Transition Projects (TPI) Rent - United Way (STRA) - RRH(4261)": "Placement Provider",
"Transition Projects (TPI) Rent - Veterans - SP(2715)": "Vets",
"Transition Projects (TPI) Rent – Vets Section 8 (PHB)(5139)": "Vets",
"Transition Projects (TPI) Rent - VRLC TH - SP(2428)": "Vets",
"Transition Projects (TPI) Winter Housing For Women (WH4W) (HUD)(4821)": "Placement Provider",
"Transition Projects (TPI) Rent - WIHN (Women into Housing Now) - SP(3955)": "Placement Provider",
"Transition Projects (TPI) x-(END 2018/06) Rent - EHA2 (STRA) - HP(6392)": "Placement Provider",
"Transition Projects (TPI) x-(END 2018/06) Rent - EHA2 (STRA) - RRH(6393)": "Placement Provider",
"Transition Projects (TPI) x-(END 2018/06) Rent - PGF (STRA) - RRH(3220)": "Placement Provider",
"Transition Projects (TPI) x-(END 2018/06) Rent - EHA-OTO (STRA) - RRH(5611)": "Placement Provider",
"El Programa Hispano Catolico (EPHC) - Coordinated Housing Access Team (CHAT)(6082)": "Outreach",
"Urban League - Coordinated Housing Access Team (CHAT)(6081)": "Outreach",
"ZZ - Transition Projects (TPI) - Columbia Shelter (Do not use after 4/25/18)(5857)": "Placement Provider",
"Transition Projects (TPI) x-(END 2018/06) Rent - ESGP - Rapid Re-Housing - SP(3926)": "Placement Provider",
"Transition Projects (TPI) - Hansen Emergency Shelter - SP(5588)": "Hansen Shelter",
"Transition Projects (TPI) - 5th Avenue Shelter(6281)": "5th Ave Shelter",
"Transition Projects (TPI) Rent - EHA-OTO (STRA) - RRH(5611)": "Placement Provider",
"Transition Projects (TPI) Rent - PGF (STRA) - RRH(3220)": "Placement Provider",
"xx-Transition Projects (TPI) - Jean's Place L2 (HUD) - SP - xx(2805)": "Jean's Place Shelter",
"Transition Projects (TPI) Rent - EHA2 (STRA) - HP(6392)": "Placement Provider",
"Transition Projects (TPI) Rent - EHA2 (STRA) - RRH(6393)": "Placement Provider",
"Transition Projects (TPI) - WyEast Emergency Shelter - SP(6612)": "WyEast Shelter",
"ransition Projects (TPI) - Housing Assistance for Section 8 (HSA)(5772)": "Placement Provider",
"Transition Projects (TPI) - Housing Assistance for Section 8 (HSA)(5772)": "Placement Provider",
"Transition Projects (TPI) Rent - CGF (STRA) - RRH(54)": "Placement Provider",
"Transition Projects (TPI) - Health Connections - HP(6485)": "Health and Wellness",
"Transition Projects (TPI) - Health Connections - RRH(6482)": "Health and Wellness",
"Impact Northwest - SSVF_C15-OR-501A - Rapid Re-Housing (VA) - SP(4797)": "Vets",
"xx_Northwest Pilot Project - SSVF_Renewal 15-ZZ-127 - Rapid Re-Housing (VA) - SP(4785)": "Vets",
"Transition Projects (TPI) - Peace 2(5793)": "Peace 2 Shelter",
"Transition Projects (TPI) x-(END) - EHA-OTO (STRA) - HP(5623)": "Placement Provider",
"Transition Projects (TPI) Rent - JGF (STRA) - RRH(6189)": "Placement Provider",
"xx_Northwest Pilot Project - SSVF_C15-OR-501A - Rapid Re-Housing (VA) - SP(4787)": "Vets",
"Transition Projects (TPI) Rent - OHCS_ESGP - Rapid Re-Housing - SP(3926)": "Placement Provider",
"Impact Northwest - SSVF_C15-OR-501A - Homeless Prevention (VA) - SP(4796)": "Vets",
"xx_Northwest Pilot Project - SSVF_Renewal 15-ZZ-127 - Homeless Prevention (VA) - SP(4784)": "Vets",
"xx_Northwest Pilot Project - SSVF_Renewal 15-ZZ-127 - Homeless Prevention (VA) - SP(4784)": "Vets",
"Impact Northwest - SSVF_18-OR-399 – Homeless Prevention (VA)(6367)": "Vets",
"Transition Projects (TPI) Rent - OHCS_ESGP - Homeless Prevention(6186)": "Placement Provider",
"Transition Projects (TPI) - Health Connections - CM(6481)": "Health and Wellness",
"Transition Projects (TPI) - Residential Enhancement Program - SP(4237)": "Placement Provider",
"Transition Projects (TPI) Rent - Placements From Shelter (PFS) - RRH(6891)": "Placement Provider",
"z-Transition Projects (TPI) - SSVF_Renewal 15-ZZ-127 Rapid Re-Housing (VA) - SP(4802)": "Vets",
"z-Transition Projects (TPI) - SSVF_Renewal 15-ZZ-127 - Homeless Prevention (VA) - SP(4801)": "Vets",
"z-Transition Projects (TPI) - Peace Annex Emergency Shelter - SP(5434)": "Peace Shelter",
"Transition Projects (TPI) - Columbia Shelter(5857)": "Columbia Shelter",
"Transition Projects (TPI) Rent - PHB_ESGP2012 (HUD) - SP(3926)": "Placement Provider",
"Transition Projects (TPI) - Jean's Place L2 (HUD) - SP(2805)": "Jean's Place Shelter",
"z-Transition Projects (TPI) - Peace Emergency Shelter - SP(5239)": "Peace Shelter",
"Transition Projects (TPI) - Hope Permanent Supportive Housing - SP(4999)": "Placement Provider",
"Transition Projects (TPI) Rent - START (HUD) - SP(4431": "Placement Provider",
"Transition Projects (TPI) Rent - START (HUD) - SP(4431)": "Placement Provider",
"Transition Projects (TPI) - Skills & Ed (VETS) - SP(3781)": "Placement Provider",
"Transition Projects (TPI) Rent - EHA-OTO (STRA) - HP(5623)": "Placement Provider",
"Transition Projects (TPI) Rent - Jessie's Fund - SP(3338)": "Placement Provider",
"Transition Projects (TPI) Housing - Men's Level 3(5204)": "Placement Provider",
"TPI Women's Registry Shelter Interest List(5216)": "Placement Provider"
}
self.entry_data["Provider"] = [self.providers[value] for value in self.entry_data["Service Provide Provider"]]
self.output_data = {}
def iterate_on_data(self):
for value in self.entry_data["Provider"].drop_duplicates():
provider_data = self.entry_data[self.entry_data["Provider"] == value]
row = raceCountByProvider(provider_data).process()
self.output_data[value] = row
def create_df(self):
output = pd.DataFrame.from_dict(
self.output_data,
orient="index"
)
return output
def process(self):
self.iterate_on_data()
output = self.create_df()
writer = pd.ExcelWriter(
asksaveasfilename(title="Save the Output Data"),
engine="xlsxwriter"
)
output.to_excel(writer, sheet_name="Summary")
writer.save()
if __name__ == "__main__":
a = CreateCombinedEthnicityData()
a.process()