– Start
import numpy as np
import pandas as pd
from datetime import datetime
pd.set_option('display.max_columns', 100)
pd.set_option('display.max_rows', 100)
pd.set_option('display.width', 1000)
# 通过读取 Excel 文件创建 DataFrame
df = pd.read_excel("index300.xls", sheet_name="Price Return Index", index_col=0)
print(df)
# 筛选某一列或几列
print(df['收盘Close'])
print(df.收盘Close)
print(df[['开盘Open', '收盘Close']])
# 根据行标签,筛选某一行或几行
print(df.loc[datetime(2021, 6, 15, 0, 0, 0)])
print(df.loc[datetime(2021, 6, 15, 0, 0, 0):datetime(2021, 6, 1, 0, 0, 0)])
# 根据行位置,筛选某一行或几行
print(df.iloc[0])
print(df.iloc[0:5])
print(df[0:5])
# 根据行标签,筛选行和列
print(df.loc[[datetime(2021, 6, 1, 0, 0, 0), datetime(2021, 5, 31, 0, 0, 0)], ['开盘Open', '收盘Close']])
print(df.loc[datetime(2021, 6, 1, 0, 0, 0):datetime(2021, 5, 31, 0, 0, 0), '开盘Open':'收盘Close'])
print(df.loc[:, '开盘Ope