我正在使用pandas从excel文件中获取列表.
start_path = r'C:\scratch\\'
File = 'test.xlsx'
import pandas as pd
mylist = []
df = pd.read_excel(start_path + File, sheet_name='GIS')
mylist = df['Column A'].tolist()
list :
mylist = ['LB-52/LP-7', 'LB-53/LI-5', 'LB-54/LP-8', 'LB-55', 'LB-56', 'ABC']
我的目标是从这个列表中创建一个新列表,只包含以LB开头的元素.因此,新列表将是:
newlist = ['LB-52/LP-7', 'LB-53/LI-5', 'LB-54/LP-8', 'LB-55', 'LB-56']
或者从列表中删除所有不以"LB"开头的元素(从而从列表中删除ABC).
newlist = [str(x for x in mylist if "LB" in x)]
我试过上面的方法,结果是:
['<generator object <genexpr> at 0x0000024B5B8F62C8>']
我还try 了以下方法:
approved = ['LB']
mylist[:] = [str(x for x in mylist if any(sub in x for sub in approved))]
这将获得与之前相同的生成器对象消息.
我觉得这真的很简单,但无法理解.