Merge together the buildings and parcels file into a consolidated data set.
import geopandas as gpd
import warnings
warnings.simplefilter("ignore")
buildings = gpd.pd.read_csv(
"./output/buildings.csv",
dtype={"ACCOUNT": str, "IN_HOUSTON": str}
)
parcels = gpd.read_file("./output/parcels.shp")
merged = parcels.merge(
buildings,
on="ACCOUNT",
how="inner"
)
merged.columns = [
'account',
'condo',
'owner',
'address',
'city',
'zipcode',
'geometry',
'use',
'class',
'number',
'erected',
'houston',
'decade',
]
merged.to_file("./output/buildings-and-parcels.shp")