import pandas as pd
import xlsxwriter
data = pd.read_excel('表名.xlsx')
FF = data.loc[(data['HP_TYPE'] == 5)|(data['HP_TYPE'] == 6)|(data['HP_TYPE'] == 12)]#搜索HP_TYPE中等于5.6.12中某一个的行
FF.to_excel('导出表名.xlsx', engine='xlsxwriter')
import pandas as pd
import xlsxwriter
data = pd.read_excel('表名.xlsx')
FF = data.loc[(data['HP_TYPE'] == 5)|(data['HP_TYPE'] == 6)|(data['HP_TYPE'] == 12)]#搜索HP_TYPE中等于5.6.12中某一个的行
FF.to_excel('导出表名.xlsx', engine='xlsxwriter')名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
