Question
ClientID Email 123A Joe@pub.com 124a fun@icloud.com 125ABB roooo@aol.com 126bb a_liza@allstate.com 127cc ADCR-123@ALLSTATE.COM 128dddSD SAB.KAY@AOL.COM 129 fun+jump@JUMP.com I have exported the table to python and convert
| ClientID | |
| 123A | Joe@pub.com |
| 124a | fun@icloud.com |
| 125ABB | roooo@aol.com |
| 126bb | a_liza@allstate.com |
| 127cc | ADCR-123@ALLSTATE.COM |
| 128dddSD | SAB.KAY@AOL.COM |
| 129 | fun+jump@JUMP.com |
I have exported the table to python and convert to DataFrame:df. How can I remove "_","+","-" , "." characters from email field? Then for every email change the domain name to "pun.com". Finally, covert both CIientID and Email to lower case.
Thank you!!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Management Systems Designing And Building Business Applications
Authors: Gerald V. Post
1st Edition
0072898933, 978-0072898934
