Home>

csv file 1
a b name
ji kd 1A: 1
ji kd 1A: 1
ji kd 1A: 1
kj sj 1B: 2
ki sa 1c: 3
ki sa 1c: 3

csv file 2
name x y
1A: 1 324 21
1B: 2 473 33
1C: 3 373 68

I have two files

I want to use python pandas so that the x and y values ​​appear in the same place as ‘name’.
(Ideal shape)
a b name x y
ji kd 1A: 1 324 21
ji kd 1A: 1 324 21
ji kd 1A: 1 324 21
kj sj 1B: 2 473 33
ki sa 1c: 3 373 68
ki sa 1c: 3 373 68

I was able to read the file and prepare a new column.
I don't know from there.
I would like somebody to teach.