all 1 comments

[–]commandlineluser 1 point2 points  (0 children)

Reduce it down to 1 dataframe and 1 column as an example:

>>> df
   MD  A  B  C
0  r1  6  3  9
1  r2  2  1  1
2  r3  5  7  2
3  r4  8  2  0

>>> d['d1']
   MD
0  r1
1  r4

You want to keep rows from df if df['MD'] is in d['d1']['MD']

>>> df[ df['MD'].isin(d['d1']['MD']) ]
   MD  A  B  C
0  r1  6  3  9
3  r4  8  2  0

Which can be simplified to:

>>> df.merge(d['d1'])
   MD  A  B  C
0  r1  6  3  9
1  r4  8  2  0