行操作汇总-增加/修改/删除/筛选删除行数据

import pandas as pd
from pandas._libs import missing
page_001 = pd.read_excel("",sheet_name="")
page_002 = pd.read_excel("",sheet_name="")

students = page_001.append(page_002).reset_index(drop=True)
print(students)

#可以将两张表上下拼接起来,reset 放弃原来的index

stu = pd.Series({'ID':41,"Name":'Abel','Score':99})
students = students.append(stu, ignore_index=True)

students.at(39,'Name') = 'Bailey'
students.at(39,'Score') = '120'   
# 直接在index=39列改数据

stu = pd.Series({'ID':40,"Name":'Bailey','Score':120})
students.iloc[39] = stu
#将原来的series替换成新的对象

stu = pd.Series({'ID':101,"Name":'Danni','Score':101})
part1 = students[:20]
part2 = students[20:]
students = part1.append(stu,ignore_index=True).append(part2).reset_index(drop=True)
#在某行插入新的series

stu.drop(index = students[0,10].index,inplace=True)
#用index索引并且删除数据行

missing = students.loc[students['Name']=='']
students.drop(index=missing.index,inplace=True)
#删除名字为空的行，筛选用loc
students.drop(index = [0,1,2],inplace=True)
#删除前三行

for i in range[5,15]:
    students['Name'].at[i]=''
#z在5到15插入名字为空的行        

print(students)