通过运行2个sql查询,我在python中有2个数据帧。表A:
名称 | 电子邮件 | 代码 |
---|---|---|
A | E | E1、E2、E3 |
B | F | >td style="text-align:right;">F1,F2|
C | G | G1 |
你可以试试这样的东西:
new_df = df1.assign(Code=df['Code'].str.split(',')).explode('Code').merge(df2)
for email, sub_df in new_df.groupby(['Email']):
print(f'Sending df to {email}...')
print(sub_df.to_csv())
输出:
Sending df to E...
,Name,Email,Code,Info1,Info2
0,A,E,E1,...,...
1,A,E,E2,...,...
2,A,E,E3,...,...
Sending df to F...
,Name,Email,Code,Info1,Info2
3,B,F,F1,...,...
4,B,F,F2,...,...
Sending df to G...
,Name,Email,Code,Info1,Info2
5,C,G,G1,...,...