I have 2 csv file like this:
file 1:
name, mid_name, last_name, year, birth
andini, swift, antonia, 1992, bojong
antono, kokoro, putih, 1991, sawit
jambore, tris, mana, 1990, kuwarto
lambe, turah, partayana, 1990, jagang
file 2:
name, mid_name, last_name
andini, swift, antonia
antono, kokoro, putih
output file:
name, mid_name, last_name, year, birth
andini, swift, antonia, 1992, bojong
antono, kokoro, putih, 1991, sawit
I want to keep the column, name, mid_name, and last_name from file 2. So i can get those output csv file with the reference file 1.