I have a data frame:
df=pd.DataFrame({'col1':['a','c','d','f'],'col2':[1,2,3,4]})
and want to create a new column that is 1/0  if the value in col1 is an element in a list, lst=['a','b','c']
I am using:
df['in_lst']=df.col1.apply(lambda x: int(x in lst))
to get
    col1    col2    in_lst
0   a       1       1
1   c       2       1
2   d       3       0
3   f       4       0
my actual dataframe in 100k rows, and my list length is 1k.
This is extremely slow at the moment, is there a way I can speed this up?
Any suggestions
