python dataframe 获取修改某行某列

代码示例

import pandas as pd
def pandTest():
    scores1 = {
        'A': ["A0", "A1", "A2", "A3"],
        'B': ["B0", "B1", "B2", "B3"],
        'C': ["C0", "C1", "C2", "C3"],
        'D': ["D0", "D1", "D2", "D3"],
    }
    df1 = pd.DataFrame(data=scores1)
    print(df1)
    print("#######################")
    #获取当前是几行几列
    print(df1.shape)
    print("#######################")
    # 获取第1行第一列数据
    a=df1.loc[1,['A']]
    b=a[0]
    print(a)
    print(b)

    print("#######################")
    # 修改第0行第二列数据
    df1.iloc[0,1]='A-1'
    print(df1)
    print("#######################")
    # 获取第0行第一列数据
    a=df1.iloc[0, 0]
    print(a)


# Press the green button in the gutter to run the script.
if __name__ == '__main__':
    pandTest()

结果显示

    A   B   C   D
0  A0  B0  C0  D0
1  A1  B1  C1  D1
2  A2  B2  C2  D2
3  A3  B3  C3  D3
#######################
(4, 4)
#######################
A    A1
Name: 1, dtype: object
A1
#######################
    A    B   C   D
0  A0  A-1  C0  D0
1  A1   B1  C1  D1
2  A2   B2  C2  D2
3  A3   B3  C3  D3
#######################
A0