取DataFrame里面某个位置的值
知道index的时候:
for j in raw.index:
chs_map = china_map[china_map['city_name']==raw.loc[j]['MAP_CITY']]
sjz_map = china_map[china_map['prv_name']==raw.loc[j]['MAP_PRV']]
不知道index的时候
for j in raw['city'].unique()
chs_map = china_map[china_map['city']==j]['MAP_CITY'].max()
sjz_map = china_map[china_map['city']==j]['MAP_PRV'].max()
修改对应位置的值
知道index 和列名的时候
data2.loc[3,'hhd'] = 0
不知道index 根据条件修改的时候
HD.loc[(HD['STATUS']=='a'|(HD['STATUS']=='b'),'FLAG']=1
所有查询
df[row_start_index, row_end_index] 查对应行
df[0:]
df[:2]
df[0:1]
df[1:3]
df[-1:]
df[-3:-1]
df.loc[index,column] (使用索引值)
data2.loc['a','segments_name']
data2.loc['a',['segments_name','cnt_case_with_segment']]
data2.loc['a':'c',['segments_name','cnt_case_with_segment']]
data.loc[data['gender']=='m','name']
data.loc[data['gender']=='M',['name','age']]
loc 修改
df.loc['a','name'] = 'aa'
df.loc['a'] = ['bb','ff',11]
df.loc['a',['name','age']] = ['bb',11]
iloc[row_index, column_index] (使用索引位置)
data2.iloc[0,0]
data2.iloc[1,2]
data2.iloc[[1,3],0:2]
data2.iloc[1:3,[1,2]]
iloc 修改
df.iloc[1,2] = 19
df.iloc[:,2] = [11,22,33]
df.iloc[0,:] = ['lily','F',15]
.at .iat .ix
df.at['a','A']
df.iat[0,0]
df.ix[0:2,'A':'C']