How to map index from another dataset

[Xiaoli Li]

Hi,

I have two files. Each line in the first file includes userName and other
relevant information. Each line in the second file includes userName and
userID. I was wondering what is the best way to find userID from the second
file and replace the corresponding userName in the first file.


Thanks in advance.


Best,

Xiaoli