列操作汇总

import pandas as pd
import numpy as np

page_001=pd.read_excel('D:/Code/.vscode/Students.xlsx',sheet_name='Page_001')
page_002=pd.read_excel('D:/Code/.vscode/Students.xlsx',sheet_name='Page_002')

students = pd.concat([page_001,page_002],axis=1)#并排放在一起
print(students)
# students = pd.concat([page_001,page_002]).reset_index(drop=True) 将两张表连接起来，上下连接，和append一样的效果

实现一个工作簿里面的多张表格的连接，比较常用

import pandas as pd
import numpy as np

page_001=pd.read_excel('D:/Code/.vscode/Students.xlsx',sheet_name='Page_001')
page_002=pd.read_excel('D:/Code/.vscode/Students.xlsx',sheet_name='Page_002')

students = pd.concat([page_001,page_002]).reset_index(drop=True) 
students['Age'] = np.repeat(25,len(students))
print(students)

生成新的列，并且是重复的值

students['Age'] = np.arange(0,len(students))

生成一个0到*的序列

students.drop(columns=['Age','Score'],inplace=True)
students.insert(1,column='Foo',value=np.repeat('foo',len(students)))
students.rename(columns={'Foo':'FOO','Name':'NAME'},inplace=True)
print(students)

drop删除指定列，并改字段名称

注意：只有设置为浮点数时才能转化为not number`

students['ID'] = students['ID'].astype(float)
for i in range(5,15):
    students['ID'].at[i] = np.nan
    
students.dropna(inplace=True)    
    

删除空值，需要先转化为浮点数据类型