在熊猫中使用 GroupBy 函数时,"set"对象没有属性"重命名"错误



我试图在Pandas中按面积计算加权平均值,得到以下错误"set"对象没有属性"rename"。我不确定它在告诉我什么。

# read in raw census tract data from .zip and convert to geodataframe
svi = gpd.read_file(r"C:NewMapsPlusMap698us-communities-firedataSVI2018_US.zip")
# read in cdps shapefile
cdps = gpd.read_file(r'C:NewMapsPlusMap698us-communities-firenotebooksdatacdps.shp')
# define fields to intersect on
overall_svi_column = 'RPL_THEMES'
cpd_area_id_column = 'GEOID'
#  intersect using overlay() function. 
inter = gpd.overlay(cdps_ec, svi_ec)
inter['area'] = inter.area
# calculate weighted mean using a lambda and groupby function
wm = lambda x: np.average(x, weights=inter.loc[x.index, 'area']) 
f = ({'wm'}).rename(columns={'overall_svi_column': 'wm_svi'})
newdf = inter.groupby(cpd_area_id_column).agg(f)
newdf.columns = newdf.columns.droplevel()
# calculate weighted mean using a lambda and groupby function
wm = lambda x: np.average(x, weights=inter.loc[x.index, 'area']) 
f = {overall_svi_column:{wm}}
newdf = inter.groupby(cpd_area_id_column).agg(f)
newdf.columns = newdf.columns.droplevel()

最新更新