我不知道你的档案里有什么，但如果你已经有一行了，那么对于一个老师和一个科目来说就简单多了

def teach_add():
    # read data from file
    df = pd.read_excel('bd1.xlsx', sheet_name='teachers')

    #print(df[['Teachers','Subjects']])

    # ask for data
    index  = int(input("Enter index: "))
    teacher = input("Enter teacher: ")
    subject = input("Enter subject: ")

    # add data to dataframe
    df['Teachers'][index] = teacher
    df['Subjects'][index] = subject

    # save data to file
    df.to_excel('bd1.xlsx', sheet_name='teachers')

这里是代码中包含一些数据的最小工作代码-所以每个人都可以简单地复制它并运行它来查看它是如何工作的

import pandas as pd

df = pd.DataFrame({
            'Class': ['A', 'B', 'C'], 
            'Teachers':['', '', ''], 
            'Subjects':['', '', ''], 
    })

# print(df[['Teachers','Subjects']])

print(df)

index   = 1
teacher = 'Albert Einstein'
subject = 'Physics'

df['Teachers'][index] = teacher
df['Subjects'][index] = subject

index   = 2
teacher = 'Alfred Nobel'
subject = 'Chemistry'

df['Teachers'][index] = teacher
df['Subjects'][index] = subject

# print(df[['Teachers','Subjects']])

print(df)

之前

Class Teachers Subjects
0     A                  
1     B                  
2     C

之后

Class         Teachers   Subjects
0     A                            
1     B  Albert Einstein    Physics
2     C     Alfred Nobel  Chemistry

如果你想请更多的老师，那么你应该使用 for -循环。你可以问你想增加多少教师

def teach_add():
    # read data from file
    df = pd.read_excel('bd1.xlsx', sheet_name='teachers')

    #print(df[['Teachers','Subjects']])

    # how many rows you have in dataframe
    teachers_number = int(input("How many teachers: "))

    # --- loop ---

    for _ in range(teachers_number):

        # ask for data
        index   = int(input("Enter index: "))
        teacher = input("Enter teacher: ")
        subject = input("Enter subject: ")

        # add data to dataframe
        df['Teachers'][index] = teacher
        df['Subjects'][index] = subject

    # --- after loop ---

    # save data to file
    df.to_excel('bd1.xlsx', sheet_name='teachers')

或者，您可以获得有多少空行，并填充所有行而不要求索引。

def teach_add():
    # read data from file
    df = pd.read_excel('bd1.xlsx', sheet_name='teachers')

    #print(df[['Teachers','Subjects']])

    # how many rows you have in dataframe
    rows_number = len(df)

    # --- loop ---

    for index in range(rows_number):

        # ask for data
        teacher = input("Enter teacher: ")
        subject = input("Enter subject: ")

        # add data to dataframe
        df['Teachers'][index] = teacher
        df['Subjects'][index] = subject

    # --- after loop ---

    # save data to file
    df.to_excel('bd1.xlsx', sheet_name='teachers')

如果datafarme中没有行并且必须追加行，那么它可能还需要不同的代码。
编辑： pandas 他警告我说它可以复制数据，我必须使用

df.loc[index, 'Teachers'] = teacher
df.loc[index, 'Subjects'] = subject

而不是

df['Teachers'][index] = teacher
df['Subjects'][index] = subject

我也不得不使用 read_excel(..., index=False) 以及 to_excel(..., index=False) 跳过添加带索引的列。