python pandas行操作 10

import pandas as pd 
page_001 = pd.read_excel('Students.xlsx',sheet_name = 'Page_001')
page_002 = pd.read_excel('Students.xlsx',sheet_name = 'Page_002')
students = page_001.append(page_002)reset_index(drop = True)
# 不管原来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'

方法二

stu = pd.Series({'ID':40,'Name':'Bailey','Score':120})
students.iloc[39] = stu

插入（先切片）

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)

删除

students.drop(index=range(0,10),inplace=True)

students.drop(index=students[0:10],inplace=True)

条件删除(删除空的)

missing = students.loc[students['Name']=='']
students.drop(index=missing.index,inplace=True)
students=students.reset_index(drop=True)

课时27