Mapping or Merging two csv files in python based on two columns in python?

Question

I have two files one contains

    0       1

0   0.0     0.0
1   2.0     8.0
2   7.0     3.0
3   6.0     1.0
4   5.0     0.0
5   4.0     NaN
6   9.0     NaN
7   0.0     NaN

and another one contains:

I want to map the second file with two columns (0 and 1) of the first file.

Expected output is like this:

1_st_column   2nd_column 
A             A
C             I
H             D
G             B
F             A
E
J
A

I tried with merging but couldn't get it work. How can i solve this? Thank you!

anky · Accepted Answer · 2020-01-12 15:02:30Z

3

You can use df.replace() here:

file1.replace(dict(enumerate(file2['0']))) #replace '0' with original column name
#if column name is int , use: file1.replace(dict(enumerate(file2[0])))
# if needed to create dict with index: file1.replace(dict(zip(file2.index,file2['0'])))

   0    1
0  A    A
1  C    I
2  H    D
3  G    B
4  F    A
5  E  NaN
6  J  NaN
7  A  NaN

answered Jan 12, 2020 at 15:02

anky

75.3k11 gold badges46 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shekhar Over a year ago

Thanks. I was trying looping and then mapping. But this is much better.

anky Over a year ago

@Shekhar No problem. happy coding :)

Collectives™ on Stack Overflow

Mapping or Merging two csv files in python based on two columns in python?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related