我有一个csv文件,它包含StateName、Population、CityName等列。。。请注意,对于每个州,u可以有多个城市名称,因此同一个城市有多个人口
我想要的是将州名与同一个城市中人口最多的三个进行分组。你知道吗
what i have: (image click to see)
what i want to have (image click to see) 我的代码是:
def answer_six():
x=census_df['STNAME'].unique()
census_df2 = df = pd.DataFrame()
for a in x :
census_dfcopy = census_df.copy()
census_dfcopy = census_dfcopy.set_index(['STNAME'])
census_dfcopy = census_dfcopy.loc[a]
census_dfcopy = census_dfcopy.reset_index()
census_dfcopy = census_dfcopy.set_index(['CENSUS2010POP'])
census_dfcopy1=census_dfcopy.sort_index(ascending = False)
census_dfcopy1= census_dfcopy1.append(census_dfcopy1)
census_dfcopy1.groupby('STNAME')
return census_dfcopy1.head(3)
回答六()
我只得到最后一个状态的最后3个值。你知道吗
要下载csv文件,请访问以下链接: https://drive.google.com/open?id=1ptE6MRQ1NGrfRYBB7NKjqhOJZXlxScPo
你能做到的
行动中:
相关问题 更多 >
编程相关推荐