Pandas¶
安装¶
pip install pandas
读取Excel¶
import pandas as pd
book_data = pd.read_excel('test.xlsx')
# 返回总的行列数
rows, cols = book_data.shape
print(rows, cols)
# 以列表格式返回第一行数据
# iloc['第几号数据']
rows_list = book_data.iloc[0].tolist()
print(rows_list)
# 以列表格式返回第一列数据
# book_data['列名']
column_list = book_data[1].tolist()
print(f'column_list{column_list}')