In [7]:
original_txt = """Bob_the_builder_2@hotmail.com,davidkinwong@hotmail.com,dong_w@yahoo.com,flptrade@bigpond.com,
franktennistar@hotmail.com,garychen168@hotmail.com,gordonyu0028@gmail.com,Grace_yuhua@hotmail.com,
info@mobileciti.com.au,liux626@hotmail.com,janicepark@msn.com,jc9494@gmail.com,
mocktong@hotmail.com,jenniferhumail@yahoo.com.au,lanlandog@hotmail.com,Johnchen636@hotmail.com,
jordanfeng@hotmail.com,kellieaus@hotmail.com,Peter.lin@ato.gov.au,lwmaggie@hotmail.com,
meili_sec@yahoo.com,michaellinking@aol.com,nalphky@yahoo.com,pengj2@anz.com,
percychan@optusnet.com.au,rebecca.yywong@optusnet.com.au,
ricky_lee_wk@yahoo.com.au,shaobenweng@hotmail.com,sieucoms@hotmail.com,
sport.gift@bigpond.com.au,stephenyu@optusnet.com.au,stewartdy@hotmail.com,slyv_t@hotmail.com,
yangxinhua@hotmail.com,syukongdi@yahoo.com,teresa.li@people.net.au,threeqiu@tpg.com.au,
tigermum@sina.com,toby_to@swiftdsl.com.au,tse888@gmail.com,ying11302004@yahoo.com,
zhouli316@yahoo.com,sales@powerun.com,chan@drsmile.com.au,dhenryko@hotmail.com,jhuang1119@hotmail.com,
pauli_nguyen@hotmail.com,thanhvo@optushome.com.au,davidkinwong@hotmail.com,jacky.Leung@anz.com,
linyanqing@gmail.com,j.chan@tpg.com.au,Kevin.Hsu@reuters.com,pleung@westpac.com.au,
lppforyou@hotmail.com,leozhou@hotmail.com,raymond@auctionaustralia.com.au,gavinpan2001@Yahoo.com,
lmoore@biway.com.au,jiaqi0311@sina.com.cn, jia_luo@hotmail.com, ryangzhang@hotmail.com,
frank@tri-pacific.com.au, sophia.su@optusnet.com.au, xiaozha@hotmail.com,
celine_ywei@hotmail.com, linyanqing@gmail.com,
uowhd@yahoo.com,zdengyun@hotmail.com,buscars@hotmail.com,linfan68@hybondair.com,
stephen3leung@optusnet.com.au,sheenzhaox@gmail.com,bluemt69@hotmail.com,eric00on@yahoo.com.hk,
eric@otcbs.com.au,hcai2002@yahoo.com.au,jinsshipchandler@hotmail.com,
crono36@gmail.com,vickychang@hotmail.com,rose389898@hotmail.com,david.shu@dic.com.au,
ekschan@optusnet.com.au,maccas_sundae_burger@hotmail.com,jamesjunjia@hotmail.com,
rosalineho@hotmail.com,jenniferhumail@yahoo.com.au,terrycai288@hotmail.com,dtmy@optusnet.com.au,
zuoren.liu@breville.com.au,neopets30@hotmail.com,dtmy@optusnet.com.au,
newimm@hotmail.com,keith.is250@gmail.com,sunnyfish0906@gmail.com,
newimm@hotmail.com,datongfu@optusnet.com.au,chenyong_fan@yahoo.com,pinkjade@hotmail.com,
joshhua@optusnet.com.au,zhangjunyi7@hotmail.com,liuliu7531@hotmail.com,
tonyfriends@gmail.com,yuting_sz@yahoo.com,york.y.huang@gmail.com,eagleskyhuang@gmail.com,
stevenwjz@hotmail.com,yuting_sz@yahoo.com,wu.vivian@hotmail.com, hemhem6688@hotmail.com,
behindgone@hotmail.com, glenelg878@hotmail.com,
yu818@yahoo.cn,panhui0685@hotmail.com,auckland@hotmail.com,
goodpanda@hotmail.com,deminzou@hotmail.com,kevin.li.letter@hotmail.com,
goodpanda@hotmail.com,lwimam@gmail.com,kevilian@gmail.com,rose@ridersgroup.com,xkmail@gmail.com,
zengfor@126.com,neilinaustralia@hotmail.com,yong.t.huang@gmail.com,
ttang888@hotmail.com,thedraykid@hotmail.com, zdengyun@hotmail.com,
neilinaustralia@hotmail.com,clementcheung@hotmail.com,shaofa@hotmail.com,chenrui00@hotmail.com,
xqxiang@yahoo.com,kv_lg@hotmail.com,xiaobaimangmang@hotmail.com,
yjjgdr@hotmail.com,guan.su@gmail.com,parry@enerjet.com.au,chenrui00@hotmail.com,
shiliang.zhao@gmail.com,atao@pacbrands.com,
xlkk@hotmail.com,xixi888@hotmail.com,huangruiyu013405@hotmail.com,
floraxu2003@hotmail.com,lemonctp@hotmail.com,maxwinner@msn.com,
gengbo327@hotmail.com,s970022@gmail.com,
tim6699_2@hotmail.com,xuzhenga_a@hotmail.com,yanyan429@hotmail.com,romewzr@gmail.com,
xxf81922506@hotmail.com,delaocnyx@hotmail.com,ada_lxq@hotmail.com,yishengyang@hotmail.com,
tonyfriends@gmail.com,cornwong@126.com,sukyhuang@hotmail.com,
amyshao001@hotmail.com,
tcy80@yahoo.com,katielkl@hotmail.com,sanpii@hotmail.com,martinwang_oz@hotmail.com,
spharm16@gmail.com, YUJ@stgeorge.com.au, annieoz@hotmail.com, xutie30@gmail.com,
clira@163.com,mick4883@tpg.com.au,allenlaw2004@hotmail.com,zhaoyubrian@gmail.com,zane.zuo@gmail.com,julia0187@hotmail.com"""
In [16]:
email_list = [i.strip().lower() for i in original_txt.split(',')]
In [17]:
len(email_list)
Out[17]:
In [18]:
email_list
Out[18]:
In [11]:
returned_list = """shasha6111@hotmail.com
dongxia@hotmail.com
mick4883@tpg.com.au
adalou@bank-of-china.com
curtaingoods@yahoo.co.jp
roni.trieu@fly.virgin.com
steven.zhu@integ.net.au
yu818@yahoo.cn
zengfor@126.com
hasegawa7@bigpond.com
austrina@bigpond.net.au
henglifan@optusnet.com.au
James.Peng@anz.com
atao@pacbrands.com
jjza188@hotmail.com
metase.neck@gmail.com
aupanhui0685@hotmail.com
richard.he@unomedicd.com
hourjf@hotmail.com
mick883@optusnet.com.au
wendy.fu@schenker.com
maichi@tpgi.com.au
Xin.Gu@optus.com.au
gavinpan@huawei.com
kesum@cisco.com
keiths@unwired.com.au
tong_xu@optusnet.com.au
cgrealty@optusnet.com.au
lilyemb@optusnet.com.au
mohamed.mouhajer@eds.com
tom.lau@syd.textpacific.com.au
tleung@cochlear.com.au
beheung@optusnet.com.au
yiyan@ozemail.com.au
tianfei@optusnet.com.au
z3098096@student.unsw.edu.au
badawaki@letsgo.com.au
"""
In [19]:
returned = returned_list.split()
returned = [i.lower() for i in returned]
In [20]:
returned
Out[20]:
In [21]:
for i in returned:
if i in email_list:
print i
In [22]:
updated = [i for i in email_list if i not in returned]
In [24]:
len(updated)
Out[24]:
In [25]:
li_2012="""Wangjiannsw@hotmail.com
joe.zhou.8@hotmail.com
joe.zhou.8@hotmail.com
josephytlau@gmail.com
gavinpan2001@yahoo.com
jscclui@hotmail.com
jscclui@hotmail.com
yuj@stgeorge.com.au
yuj@stgeorge.com.au
jenny.lian@optusnet.com.au
angeneca@yahoo.com.au
angeneca@yahoo.com.au
janus_k@hotmail.com
Nesse.Chan40@gmail.com
Nesse.Chan40@gmail.com
cdwang98@yahoo.com
cdwang98@yahoo.com
Nesse.Chan40@gmail.com
Zhongxy2001@hotmail.com
aubeaches@gmail.com
myanhsydney@yahoo.com
Kui_l@hotmail.com
min.wang.pp@gmail.com
jhuang1119@hotmail.com
nalphky@yahoo.com
jhuang1119@hotmail.com
angeneca@yahoo.com.au
angeneca@yahoo.com.au
janus_k@hotmail.com
Nesse.Chan40@gmail.com
Nesse.Chan40@gmail.com
cdwang98@yahoo.com
cdwang98@yahoo.com
Nesse.Chan40@gmail.com
Zhongxy2001@hotmail.com
aubeaches@gmail.com
myanhsydney@yahoo.com
Kui_l@hotmail.com
min.wang.pp@gmail.com
jhuang1119@hotmail.com
nalphky@yahoo.com
jhuang1119@hotmail.com
"""
In [26]:
li_2012 = [i.lower() for i in li_2012.split()]
li_2012
Out[26]:
In [27]:
update_2012 = []
for i in li_2012:
if i not in update_2012:
update_2012.append(i)
else:
print i
In [28]:
update_2012
Out[28]:
In [32]:
new_2012 = []
for i in update_2012:
if i not in updated:
new_2012.append(i)
print ','.join(new_2012)
In [33]:
new_2012.remove('janus_k@hotmail.com')
In [34]:
new_2012.remove('jenny.lian@optusnet.com.au')
In [35]:
new_2012
Out[35]:
In [36]:
len(updated)
Out[36]:
In [37]:
updated.remove('teresa.li@people.net.au')
In [38]:
updated.remove('toby_to@swiftdsl.com.au')
In [39]:
len(updated)
Out[39]:
In [40]:
updated.extend(new_2012)
In [41]:
len(updated)
Out[41]:
In [44]:
for i in updated:
print i+','
In [1]:
players='''Jasonx168@gmail.com
johnlu64@optusnet.com.au
Graceliu80@hotmail.com
shelley168@live.com.au
willjyw@hotmail.com
helenzhai@gmail.com
nalphky@yahoo.com
yong.t.huang@gmail.com
david.shu@dic.com.au
aida-lubing@hotmail.com
richard@realtyprofessional.com.au
buscars@hotmail.com
xiaoyuanjin626@hotmail.com
pzchen@hotmail.com
johnyson1123@hotmail.com
richardygong@gmail.com
koala.147@hotmail.com
georgeguoshaobo@hotmail.com
357735230@QQ.COM
rwnz@hotmail.com
henry@herculift.com.au
civetlai@gmail.com
hcai2002@yahoo.com.au
zhongdarren@hotmail.com
460144267@qq.com
WZYIN12@GMAIL.COM
jasonwzhu@gmail.com
chnjack@gmail.com
he0210@163.com
wxy0317@gmail.com
yuj@stgeorge.com.au
andrew@realtyprofessional.com.au
316396469@qq.com
Yu.kingsley@yahoo.com
gongli54@gmail.com
zuorenliu@yahoo.com
louiliao@gmail.com
josephytlau@gmail.com
jameszhang666@hotmail.com
robertluo20@yahoo.com.au
kitty0618@gmail.com
dongxia68@hotmai.com
chenrui00@hotmail.com
juliasong5@bigpond.com
Kathyqiu.wu@gmail.com
stephen.crawford@nat.awu.net.au
david.shu@dic.com.au
zhangzhuo94@126.com
brianhuang@baulkhamhillshighschool.com.au
zhum@y7mail.com
dhenryko@hotmail.com
357735230@QQ.COM
rwnz@hotmail.com
flptrade@bigpond.com
285574747@qq.com
john521116@hotmail.com
stevenyang_1992@hotmail.com
he0210@163.com
yuj@stgeorge.com.au
48287164@qq.com
michaellin@promata.cn
louiliao@gmail.com
chantulio@gmail.com
vicye59@hotmail.com
crystaltoba@msn.com
joanne.yan@quintiles.com'''
lp = [i.lower().strip() for i in players.split() if i.lower().strip()]
slp = set(lp)
lp = list(slp)
print ',\n'.join(lp)
In [ ]: