本文共 1481 字，大约阅读时间需要 4 分钟。

第1关：数据集介绍

import pandas as pdf500 = pd.read_csv('f500.csv',index_col=0)f500.index.name = None# 请在此添加代码，分别打印f500的类型和形状大小#********** Begin **********#print(type(f500))print(f500.shape)#********** End **********#

第5关：值统计的方法

import pandas as pdf500 = pd.read_csv('f500.csv',index_col=0)f500.index.name = Nonef500_sel = f500.iloc[[0,1,2,3,4,8]]# 请在此添加代码#********** Begin **********#countries = f500_sel["country"]country_counts = countries.value_counts()print(countries)print(country_counts)#********** End **********#

第6关：通过标签从series中选择项

import pandas as pdf500 = pd.read_csv('f500.csv',index_col=0)f500.index.name = Nonecountries = f500['country']countries_counts = countries.value_counts()# 请在此添加代码#********** Begin **********#india = countries_counts["India"]north_america = countries_counts.loc[["USA","Canada","Mexico"]]print(india)print(north_america)#********** End **********##********** End **********#

第7关：综合挑战

#i  在educoder.net上测试不了import pandas as pdf500 = pd.read_csv('f500.csv',index_col=0)f500.index.name = None#i-------------countries = f500['country']countries_counts = countries.value_counts()#india = countries_counts["India"]#north_america = countries_counts.loc[["USA","Canada","Mexico"]]# 请在此添加代码#********** Begin **********#big_movers = f500.loc[["Aviva","HP","JD.com","BHP Billiton"],["rank","previous_rank"]]print(big_movers)bottom_companies = f500.loc["National Grid":"AutoNation",["rank","sector","country"]]print(bottom_companies)#********** End **********#

转载地址：http://qdozi.baihongyu.com/