Match List Value With DataFrame Column Value In Order To Extract Another Column Value?

Question

I have a list, "L" and a DataFrame, "df" and I wish to extract a certain column value only where the L and a certain df column match.

L = [299]
Match = []

df:
['ID']    ['Num']
299       1
300       3
....      ....

I wish to see 1 when I print Match:

print(Match):

1

Does this answer your question? [How to select rows from a DataFrame based on column values?](https://stackoverflow.com/questions/17071871/how-to-select-rows-from-a-dataframe-based-on-column-values) — CodeIt, Mar 01 '20 at 11:52

score 0 · Accepted Answer · answered Mar 01 '20 at 18:10

0

Match = df.loc[df['ID'].isin(L),'Num']

answered Mar 01 '20 at 18:10

BICube

If there are multiple row matches how could you select only the first one? – keenan Nov 11 '22 at 22:01

1 Answers1