I have two dataframes. One is user(UserID, Name) and other one is rating (srcUserId, dstUserId, RatingValue). I have to merge these two dataframes such that in place of srcUserId I get the name of the user corresponding to userid from user dataframe.The format should look like below:-
Name1, Name2, Rating
(srcUserId), (dstUserId), (RatingValue)
How should I apply merging on both of these to get the output?