一、准备工作
解决lzma 告警问题（如果有）：
yum install xz-devel
yum install python-backports-lzma
pip install backports.lzma
cd /usr/local/python3/lib/python3.8
vim lzma.py
第27行修改：
try: from _lzma import * from _lzma import _encode_filter_properties, _decode_filter_propertiesexcept ImportError: from backports.lzma import * from backports.lzma import _encode_filter_properties, _decode_filter_properties
二、
pip install pandas
import pandas as pd
2
3 #读取xlsx、xls数据
4 df = pd.read_excel('fruit2.xlsx')
5 print(df)
6 print(df.values)
7 print(df['名称'])
8 print(df.loc[1])
9 print(df.loc[2,'单价/元'])
10
11 df = df.set_index('名称') #设置名称列为行索引
12 print(df)
13 print(df.values)
14 print(df['库存/kg'])
15 print(df.loc['苹果'])
16 print(df.loc['香蕉','单价/元'])
17 #写入xlsx、xls
18 writer = pd.ExcelWriter('pandas.xlsx')
19 df.to_excel(writer,'sheet1')
20 writer.save()
