# Section0
print("-"*30 + "Begin Section 0 开场" + "-"*30)
print("lesson7 数据选择")
print("1.列选择\n2.行选择\n3.行列选择")
print("-"*30 + "End Section 0 开场" + "-"*30)
import pandas as pd
# Section1 列
df = pd.read_excel(r"D:/Users/sf_xiaowei_lin/PycharmProjects/pythonProject/venv/Lesson7.xlsx")
#定义行标
df.index = ["one","two","three","four","five"]
print("readload content of table :")
print(df,'\n')
# 只选择名称列
print("只选择名称列:")
print(df["名称"],'\n')
# 选择名称列和观看次数
print("选择名称列和观看次数:")
print(df[["名称","观看次数"]],'\n')
#选择指定列,:冒号表示所有行,后面表示第几列
print("选择指定列:")
print(df.iloc[:,[0,2]],&#