表格如下图所示:
# -*- coding:utf-8 -*-
import pandas as pd
from datetime import datetime
column = []
df = pd.read_excel('data.xls',sheet_name='Sheet2')
for i in df.columns.tolist():
if i < datetime(2019,11,2):
column.append(i)
print(df.iloc[:,:len(column)])
读取excel数据,然后把想要的列写入新的excel
import pandas as pd
df = pd.read_excel(filename)
print(df.iloc[:,:3]) 取前3列