How to lookup different dataframes and return the values?

Question

Im trying to lookup the index in two different datframes and return the values.

For example, in df1 i would like to lookup in df2 and return the same index and values.

DF1

DF2

I would like my result to be like this.

RESULTS

score 1 · Answer 1 · answered Nov 19 '22 at 22:05

1

Get the IDs from df2 where the ID is in df1

filtered_df = df2[(df2['ID'].isin(df1['ID']))]

answered Nov 19 '22 at 22:05

work but what if i df1 98,95,88,85,81,86,100. how do i return the values in that order. Some one the numbers or not in order but i would like to keep in the order of df1 – Chris Nov 19 '22 at 22:21
there isn't an easy way to do custom sorting in pandas https://stackoverflow.com/questions/13838405/custom-sorting-in-pandas-dataframe – Nicholas Hansen-Feruch Nov 19 '22 at 22:58

score 1 · Accepted Answer · answered Nov 19 '22 at 22:05

1

Try this

new_df = df2[df2.ID == [list(df1.ID)]]

answered Nov 19 '22 at 22:05

CharlieBONS

dot notation is not best practice for pandas https://stackoverflow.com/a/56241496/11280068 – Nicholas Hansen-Feruch Nov 19 '22 at 22:06
Too much pyspark for me where I use '.' rather than col('...'), probably a bad habit! – CharlieBONS Nov 19 '22 at 22:14
dont work if its not the same length – Chris Nov 19 '22 at 22:38
.isin() should work (as answered below by Nicholas) – CharlieBONS Nov 19 '22 at 22:40

2 Answers2