1

I have a dataframe df1

Name Cluster Centroid
Ann    1        (1,2)
Josh   2         (3,4)
Drake  3         (5,6)

and another dataframe df2

Name
Ann
Josh
Drake
Ann
Drake
nan    
Josh

How do I make cluster and centroid columns in df2 based on matching names in df1, accounting for nan? without iterating

So I want df2:

Name    Cluster   Centroid
Ann      1          (1,2)
Josh     2          (3,4)
Drake    3          (5,6)
Ann      1          (1,2)
Drake    3          (5,6)
nan      nan        nan
Josh     2          (3,4)

Thanks!

wanderingstu
  • 317
  • 4
  • 12

0 Answers0