目录 一、iloc函数1、iloc取一行2、iloc取多行3、iloc取一列4、iloc取多列5、iloc取一行一列6、iloc取多行多列7、iloc取全部数据 二、loc函数1、loc函数取一行2、loc函数取多行3、loc函数取一列4、loc函数取多列5、loc函数取一行一列6、loc函数取多行多列7、loc函数取所有值
iloc函数根据行号/列号取值
loc函数根据行/列具体的值取值
结果
data: math history chemicy englishtzdbg 0 1 2 3andy 4 5 6 7xfdpkq 8 9 10 11john 12 13 14 15data1: math 0history 1chemicy 2english 3Name: tzdbg, dtype: int32 2、iloc取多行 # iloc取多行data2 = data.iloc[0:2]print('data2:', data2)结果
data2: math history chemicy englishtzdbg 0 1 2 3andy 4 5 6 7 3、iloc取一列 # iloc取一列data3 = data.iloc[:, 1]print('data3:', data3)结果:
data3: tzdbg 1andy 5xfdpkq 9john 13Name: history, dtype: int32 4、iloc取多列 # iloc取多列data4 = data.iloc[:, 1:3]print('data4:', data4)结果:
data4: history chemicytzdbg 1 2andy 5 6xfdpkq 9 10john 13 14 5、iloc取一行一列 # iloc取一行一列data5 = data.iloc[1, 2]print('data5:', data5)结果:
data5: 6 6、iloc取多行多列 # iloc取多行多列data6 = data.iloc[0:2, 1:3]print('data6:', data6)结果:
data6: history chemicytzdbg 1 2andy 5 6 7、iloc取全部数据 # iloc取所有行所有列data66 = data.iloc[:, :]print('data66:', data66)结果:
data66: math history chemicy englishtzdbg 0 1 2 3andy 4 5 6 7xfdpkq 8 9 10 11john 12 13 14 15 二、loc函数 1、loc函数取一行 # loc取一行data7 = data.loc['andy']print('data7:', data7)结果:
data7: math 4history 5chemicy 6english 7Name: andy, dtype: int32 2、loc函数取多行 # loc取多行data8 = data.loc[['andy', 'john'], :]print('data8:', data8)结果:
data8: math history chemicy englishandy 4 5 6 7john 12 13 14 15 3、loc函数取一列 # loc取一列data9 = data.loc[:, 'chemicy']print('data9:', data9)结果:
data9: tzdbg 2andy 6xfdpkq 10john 14Name: chemicy, dtype: int32 4、loc函数取多列 # loc取多列data10 = data.loc[:, ['english', 'history']]print('data10:', data10)结果:
data10: english historytzdbg 3 1andy 7 5xfdpkq 11 9john 15 13 5、loc函数取一行一列 # loc取一行一列data11 = data.loc[['john'], ['history']]print('data11:', data11)结果:
data11: historyjohn 13 6、loc函数取多行多列 # loc取多行多列data12 = data.loc[['andy', 'john'], ['english', 'history']]print('data12:', data12)结果:
data12: english historyandy 7 5john 15 13 7、loc函数取所有值 # loc取所有行所有列data122 = data.loc[:, :]print('data122:', data122)结果:
data122: math history chemicy englishtzdbg 0 1 2 3andy 4 5 6 7xfdpkq 8 9 10 11john 12 13 14 15