Python equivalent of select * from a where account_id in (select account_id from b)

Question

 I am from an SQL background was looking for the best way of doing this.

c = a.account_id.isin(b.account_id).astype(bool) 

a[c]

Is the above method efficient way?

Answer 1

Yes, it is, but we can put them into one row, and you do not need to convert isin output as bool since it is already bool type.

a[a.account_id.isin(b.account_id)]

Learn Data Science with Python Course to improve your technical knowledge.