pandas行操作

import pandas as pd
import os
#完整显示列
pd.set_option('display.max_columns',None)
#完整显示行
pd.set_option('display.max_rows',None)
os.chdir(r'文件路径')
df1 = pd.read_excel('students.xlsx',sheet_name='page_001')
df2 = pd.read_excel('students.xlsx',sheet_name='page_002')
#drop=True代表删除原来的index
df = df1.append(df2).reset_index(drop=True)
#新建一行series
stu = pd.Series({'ID':41,'Name':'Abel','Score':99})
#插入一行，忽略index
df = df.append(stu,ignore_index=True)
#更改39行的Name为Baily
df.at[39,'Name']='Bailey'
df.at[39,'Score']='100'
#整行替换
stu = pd.Series({'ID':40,'Name':'Bailey','Score':120})
df.iloc[39] = stu
#插入行，先切片
stu = pd.Series({'ID':101,'Name':'Danni','Score':101})
part1 = df[:20]
part2 = df[20:]
df = part1.append(stu,ignore_index=True).append(part2).reset_index(drop=True)
#删除行
# df.drop(index=df[0:10].index,inplace=True)
for i in range(5,15):
    df['Name'].at[i] = ''
#删除空值行
missing = df.loc[df['Name']=='']
df.drop(index=missing.index,inplace=True)
print(df)