pandas列操作

import pandas as pd
import matplotlib.pyplot as plt
import matplotlib
import numpy as np
import os
pd.set_option('display.max_columns',None)
pd.set_option('display.max_rows',None)
os.chdir(r'文件路径')
df1 = pd.read_excel(r'students.xlsx',sheet_name='page_001')
df2 = pd.read_excel(r'students.xlsx',sheet_name='page_002')
#横向数向拼接数据
df = pd.concat([df1,df2],axis=0).reset_index(drop=True)
#新增age列
df['Age'] = 30
#删除age和score列
df.drop(columns=['Age','Score'],inplace=True)
#插入列
df.insert(1,column='Foo',value=np.repeat('foo',len(df)))
#更改列名
df.rename(columns={'Foo':'FOO','Name':'NAME'},inplace=True)
#变更格式
df['ID'] = df['ID'].astype(float)
for i in range(5,15):
    df['ID'].at[i] = np.nan
#删除空值
df.dropna(inplace=True)

print(df)