pandas中loc、iloc、at、iat的区别

 废话不多说，直接上代码

import pandas as pd

if __name__ == "__main__":

    data = [["lucy", "female", 17], ["lilei", "male", 18],["hanmeimei", "female", 17],["lily", "female", 16]]
    index = ['a', 'b','c','d']
    columns = ['name', 'sex', 'age']
    df = pd.DataFrame(data=data, index=index, columns=columns)
    print("*" * 10,"获取所有数据","*" * 10)
    print(df.loc[:])
    print("*" * 10,"获取第一行数据","*" * 10)
    print(df.loc["a",:])
    print("*" * 10,"获取第一行，第二列数据","*" * 10)
    print(df.loc["a","sex"])
    print("*" * 10,"获取前两行，前两列数据","*" * 10)
    print(df.loc[:"b",:"sex"])
    print("*" * 10,"获取第一、三行，第一、三列列数据","*" * 10)
    print(df.loc[['a','c'],['name','age']])
    # print(df.loc[1,2]) #报错：KeyError:
    print("*" * 20, "iloc", "*" * 20)
    print("*" * 10, "获取所有数据", "*" * 10)
    print(df.iloc[:])
    print("*" * 10, "获取第一行数据", "*" * 10)
    print(df.iloc[0, :])
    print("*" * 10, "获取第一行，第二列数据", "*" * 10)
    print(df.iloc[0, 2])
    print("*" * 10, "获取前