我有一个包含电子邮件文本的数据框:
id e-mail
1 text_1
2 text_2
3 text_3
. .
. .
与文本1(例如)一起:
"Gallag, Keit G" <Keit.Gallag@chart.com>
Date: Friday, March 29, 2019 at 3:14 AM
To: Lesl Kirch <ljkirch@action.com>
Subject: Automatic reply: News Recap, March 29, 2019 Issue of CrossTalk
Thank you for your email. I will be out of the office Thursday, March 28th
through Monday, April 1st. I will respond to emails on Tuesday, April 2nd.
If this is urgent please contact lisa.chiap@chart.com or for National
Account question or Steph.thomp@chart.com or 309-557-1234 for
National TeleSales
inquiries.
Thank you, Keith
我需要提取发件人的电子邮件地址(第一个电子邮件),电子邮件文本中的所有电子邮件地址和所有美国电话号码,并以以下方式呈现结果:
id email sender_email mail telephone
1 text_1 Keit.Gallag@chart.com ljkirch@action.com 309-557-1234
1 text_1 Keit.Gallag@chart.com lisa.chiap@chart.com ?
1 text_1 Keit.Gallag@chart.com Steph.thomp@chart.com ?
2 text_2 e-mail_sender_2 e-mail_text_2_1 Tel_text_2_1
2 text_2 e-mail_sender_2 e-mail_text_2_2 Tel_text_2_2
2 text_2 e-mail_sender_2 ? Tel_text_2_3
3 text_3 e-mail_sender_3 e-mail_text_3_1 Tel_text_3_1
4 text_4 e-mail_sender_4 e-mail_text_4_1 ?
. . . . .
. . . . .
电子邮件中的电子邮件数量和美国电话号码的数量在电子邮件文本中会有所不同(在0和+inf之间)。