#创建DataFrame
import pandas as pd
data_dict={
'currency':[
['PlN','USD'],
['EUR','USD','PLN','CAD'],
['GBP'],
['JPY','CZK','HUF'],[]
]
}
df=pd.DataFrame(data=data_dict)
df
#结果
currency | |
---|---|
0 | [PlN, USD] |
1 | [EUR, USD, PLN, CAD] |
2 | [GBP] |
3 | [JPY, CZK, HUF] |
4 | [] |
#借用lambda匿名实现逻辑判断:含有'USD'则为1,反之为0
df['USD_flag']=df['currency'].map(
lambda x:1 if 'USD' in x else 0
)
df
#结果
currency | USD_flag | |
---|---|---|
0 | [PlN, USD] | 1 |
1 | [EUR, USD, PLN, CAD] | 1 |
2 | [GBP] | 0 |
3 | [JPY, CZK, HUF] | 0 |
4 | [] | 0 |