NYCPlanning / db-acs

American Community Survey data processing for Population Fact Finder
4 stars 1 forks source link

RntVacRt #5

Closed SPTKL closed 4 years ago

SPTKL commented 4 years ago
df.loc[df.geotype=='NTA2010','rntvacrte'] = 100*df['vacrnte']/df['rntvacue']
df.loc[df.geotype=='NTA2010','rntvacrtm'] = df.apply(lambda row: hovacrtm(row['rntvacue'], row['vacrnte'], row['vacrntm'], row['rntvacum']), axis=1)

confirm w population that in

rntvacrte = IF(RntVacE=0,"",VacRntE/RntVacE*100)

RntVacE should be RntVacuE

SPTKL commented 4 years ago

confirmed