I have a dictionary

smsgateway = {'AT&T':'@txt.att.net', 'Boost Mobile':'@sms.myboostmobile.com', 'Cricket':'@sms.cricketwireless.net', 'Google Fi':'@msg.fi.google.com', 'Metro PCS':'@mymetropcs.com', 'Republic Wireless':'@textrepublicwireless.com', 'Sprint':'@messaging.sprintpcs.com', 'T-Mobile':'@tmomail.net', 'U.S. Cellular': '@email.uscc.net', 'Verizon':'@vtext.com', 'Virgin Mobile': '@vmobil.com', 'XFinity Mobile':'@vtext.com'}

and I have a dataframe like so:

Name         cell_provider  cell_number
Tony Danza   Google Fi      9999999999  
John Smith   T-Mobile       8888888888  

Ultimately, I am trying to create a new df column that is created based on the cell_number and the cell_provider ([email protected]) but I am stuck at trying to create a column that is taking the elements of cell_provider and comparing them to the key/value pair of the smsgateway dictionary. I understand how to concat the columns after I get past this step, could anyone point me in the right direction? Please...and THANK YOU!

CodePudding user response：

You can replace the cell_provider values with the addresses from the dictionary using .replace and then add the resulting series to the cell number after casting to string like this:

df = df.assign(cell_num_provider=df.cell_number.astype(str)   df.cell_provider.replace(smsgateway))

output:

   cell_number cell_provider           cell_num_provider
0     99999999     Google Fi  [email protected]
1     88888888      T-Mobile        [email protected]

See documentation on pandas.Series.replace

CodePudding user response：

An alternative solution to the first answer. you could use transform:

df['address'] = df['cell_number'].astype(str)   df['cell_provider'].transform(lambda: smsgateway[x])

output:

      cell_number  cell_provider    address
0     99999999     Google Fi        [email protected]
1     88888888     T-Mobile         [email protected]

CodePudding user response：

Probably the cleanest way would be to use map:

df['cell_num_provider'] = df.cell_number df.cell_provider.map(smsgateway))