选择包含“承德”的列数据
#-*-coding:utf-8-*-
import pandas as pd
from pandas import DataFrame
#读取数据
file = pd.read_excel('test.xlsx',encoding='utf-8')
df = pd.DataFrame(file)
for index,row in df.iterrows():
if '承德' not in row['子库存']:
df.drop(index,axis=0,inplace=True)
print(df)