How to take data from one csv to another csv file based on some common entity?


#1

I want to add the skills column of a particular user into a file(say his performance in a test) from another file that is user description(skill being algebra, trigno…).
performance file:
user ID
problem ID
result : right or wrong(0/1)
User file
user ID
skills
previous score
please help!!


#2

This looks like a join in whatever tool you are using.

If the file is small and you have access to excel, then open the two files in excel and perform a vlookup.

If you prefer a code based approach, import the two csv files and then join them on the common field.