"*****@*****.**", ] ############### # gather mails fLOG("fetch mails") if os.path.exists(filename_mails): with open(filename_mails, "r", encoding="utf8") as f: lines = f.readlines() emails = [l.strip("\r\t\n ") for l in lines] else: box = MailBoxImap(user, pwd, server, ssl=True, fLOG=fLOG) box.login() emails = grab_addresses(box, mailfolder, date, fLOG=fLOG) box.logout() emails = list( sorted( set([ _.strip("<>").lower() for _ in emails if _ not in skip_address ]))) with open(filename_mails, "w", encoding="utf8") as f: f.write("\n".join(emails)) ##################### # create a dataframe import pandas rows = [{
"*****@*****.**", ] ############### # gather mails fLOG("fetch mails") if os.path.exists(filename_mails): with open(filename_mails, "r", encoding="utf8") as f: lines = f.readlines() emails = [l.strip("\r\t\n ") for l in lines] else: box = MailBoxImap(user, pwd, server, ssl=True, fLOG=fLOG) box.login() emails = grab_addresses(box, mailfolder, date, fLOG=fLOG) box.logout() emails = list(sorted(set([_.strip("<>").lower() for _ in emails if _ not in skip_address]))) with open(filename_mails, "w", encoding="utf8") as f: f.write("\n".join(emails)) ##################### # create a dataframe import pandas rows = [{"nom_prenom": mail, "sujet": "octobre", "groupe": i + 1} for i, mail in enumerate(emails)] df = pandas.DataFrame(rows) fLOG("dataframe", df.shape)