Change values in excel file from values of other excel using python

Question

I have data

And next excel

     id                mail
30049  [email protected]  
30046  [email protected]    
30040  [email protected]

I want to change id from 1 file to mail from 2 excel. Desire output

id  
[email protected]   
[email protected] 
[email protected]
[email protected]

I try

for (id1, id2, mail) in zip(ids1, ids2, mails):
    if id1 == id2:
        ids1.replace(id1, mail)

Do you want to change the Excel files or just print out the emails? — doctorlove
– doctorlove, Commented Jun 23, 2016 at 10:38
@doctorlove, I need to change df, df = pd.read_excel('name.xlsx'), but don't want to change excel — NineWasps
– NineWasps, Commented Jun 23, 2016 at 10:40

jezrael · Accepted Answer · 2016-06-23 10:45:32Z

2

I think you need map column id in df1 by Serie created by set_index from df2:

print (df1)
      id
0  30046
1  30049
2  30040
3  30046

print (df2)
      id                     mail
0  30049  [email protected]
1  30046        [email protected]
2  30040        [email protected]

df1['id'] = df1.id.map(df2.set_index('id')['mail'])
print (df1)
                        id
0        [email protected]
1  [email protected]
2        [email protected]
3        [email protected]

answered Jun 23, 2016 at 10:45

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

4 Comments

NineWasps Over a year ago

and may suggest to me to the same example? If I have in columns with quantity of hours, for example 3 and I should add it to column with string like 17/Jun/2016:06:25:05, i want to get 17/Jun/2016:09:25:05, i can use your example, but what I shoud do, to make it datetime type

jezrael Over a year ago

I think you can create new question, please add sample and desired output if simple pd.to_datetime(df['date_col']) doesnt work.

NineWasps Over a year ago

I add new question stackoverflow.com/questions/37990019/…

NineWasps Over a year ago

Can you say, I have similar question, I should change one column from another, but I should change that and to new value add last. I do df['id'] = df.id.map(status.set_index('mail')['status' + ' ' + df.id]) but it returns ValueError: cannot index with vector containing NA / NaN values

Collectives™ on Stack Overflow

Change values in excel file from values of other excel using python

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related