(jb .filter(like=r'job.role.*t') .where(jb.isna(), 1) ) results in a single col with the indexes 1...54461 (jb .filter(like=r'job.role.*t') .where(jb.isna(), 1) .fillna(0) ) ditto Thereafter seems to be ok