Python – 从电子邮件中提取信息

huangapple
go评论109阅读模式
英文:

Python - extract information from email

问题

以下是您提供的电子邮件示例的翻译部分：

电子邮件示例1

亲爱的大家，

请注意总销售量和剩余总库存

总销售量：45677
总剩余库存 A：3456

如有任何疑问或意见，请随时联系。

最好的问候，

电子邮件示例2

亲爱的大家，

请查看以下数据：

总体积：1,231,245
剩余库存 A 的数量：232
剩余库存 B 的数量：1,435

电子邮件示例3

亲爱的大家，

请查找我们的总体积为 233,435

总剩余库存 A：2453

电子邮件示例4

在五月份，我们剩余库存 A 为 90，TEU 为 4190。

我想从这些电子邮件中提取体积和总剩余库存数字。是否有任何关于如何使用 Python 获取这些数字的提示？

我已经准备好了以下代码，用于从电子邮件中提取数字。但我无法区分哪个数字是总销售量，哪个数字是总剩余库存。

英文:

I am new to Python. Below are some sample emails I received.

Email sample 1

Dear all,

Please note the Total selling volume and total remaining stock

Total selling volume: 45677
Total remaining stock A:3456

Remain at your disposal in case of any doubt or comments.

Best Regards,

Email sample 2

Dear all,

Please see the data as below:

Tol volume: 1,231,245
No. of remaining stock A: 232
No. of remaining stock B: 1,435

Email sample 3

Dear All,

Please find our volume was 233,435

Total remaining stock A: 2453

Email sample 4

In May we had 90 remaining stock A and 4190 TEUs.

I would like to extract the volume and total remaining stock figures from those emails. Any hints if I can get those figures by using python?

I have prepared the below code to extract the figures from email. However I can not distinguish which figure is total selling volume, total remaining stock

  1. import re
  2. import pandas as pd
  3. import win32com.client
  4. from datetime import datetime, timedelta
  6. outlook = win32com.client.Dispatch('outlook.application')
  7. mapi = outlook.GetNamespace("MAPI")
  8. inbox = mapi.GetDefaultFolder(6).Folders.Item("AI email testing")
  9. #outlook.GetDefaultFolder(6) .Folders.Item("Your_Folder_Name")
  10. #inbox = outlook.GetDefaultFolder(6)
  11. messages = inbox.Items
  13. received_dt = datetime.now() - timedelta(days=1)
  14. received_dt = received_dt.strftime('%m/%d/%Y %H:%M %p')
  17. for message in list(messages):
  18.     #print (message)
  19.     body_content = message.body
  20.     body_content =body_content[body_content.find("Subject:"):]
  21.     #print(body_content)
  22.     figures = re.findall("\d+(?:,\d+)*(?:\.\d+)?",body_content)
  23.     print(figures)

答案1

得分: 0

以下是使用正则表达式的解决方案：

  1. from __future__ import annotations
  3. import re
  4. from typing import List, Tuple
  7. def get_number(text: str) -> float | int | str:
  8.     """
  9.     从输入字符串中提取第一个数值。
  11.     该函数使用正则表达式从`text`中提取第一个数值。
  12.     如果未找到数字值，则返回原始字符串。如果从提取的数字中删除逗号（如果有的话）。
  13.     该函数首先尝试将数字转换为整数，如果失败，则尝试将其转换为浮点数。
  15.     Parameters
  16.     ----------
  17.     text : str
  18.         应从中提取数值的字符串。
  20.     Returns
  21.     -------
  22.     float | int | str
  23.         转换为int或float的`text`中的第一个数值，如果未找到数字值，则返回原始`text`。
  25.     Raises
  26.     ------
  27.     ValueError
  28.         如果提取的数字无法转换为整数或浮点数。
  30.     Examples
  31.     --------
  32.     函数用法和行为的说明。
  34.     >>> get_number("Hello world 123!")
  35.     123
  36.     >>> get_number("I have 2,200 dollars.")
  37.     2200
  38.     >>> get_number("No numbers here.")
  39.     'No numbers here.'
  40.     >>> get_number("It is over 9000!")
  41.     9000
  42.     >>> get_number("The value of pi is about 3.14159.")
  43.     3.14159
  44.     >>> get_number("Total: 123,456,789.")
  45.     123456789.0
  46.     """
  47.     number = re.search(r'(\d+|,)+.', text, re.I)
  48.     if number:
  49.         number = number[0].strip().replace(',', '')
  50.     if not number:
  51.         print(f"Found no numbers inside text: {text!r}")
  52.         return text
  53.     try:
  54.         return int(number)
  55.     except ValueError:
  56.         return float(number)
  59. def extract_stock_volume_from_email(email: str) -> Tuple[int | float | str, int | float | str]:
  60.     """
  61.     从电子邮件文本中提取容量和剩余库存A的详细信息。
  63.     此函数使用正则表达式解析给定的电子邮件文本并提取有关容量和剩余库存A的详细信息。
  64.     然后清理提取的值并返回。
  66.     Parameters
  67.     ----------
  68.     email : str
  69.         要解析的电子邮件文本。
  71.     Returns
  72.     -------
  73.     volume : int | float | str
  74.         从电子邮件中提取的容量。
  75.         如果未找到容量详细信息，则返回'Volume not found'。
  76.     remaining_stock_a : int | float | str
  77.         从电子邮件中提取的剩余库存A。
  78.         如果未找到库存A详细信息，则返回'Remaining stock A not found'。
  80.     Raises
  81.     ------
  82.     re.error
  83.         如果使用无效的正则表达式。
  85.     See Also
  86.     --------
  87.     re.search：用于提取容量和剩余库存详细信息的方法。
  89.     Examples
  90.     --------
  91.     >>> email_text = "The volume was 5000 TEUs. Stock A: 1000 units."
  92.     >>> extract_stock_volume_from_email(email_text)
  93.     (5000, 1000)
  94.     >>> email_text = "No volume and stock data available."
  95.     >>> extract_stock_volume_from_email(email_text)
  96.     ('Volume not found', 'Remaining stock A not found')
  97.     """
  98.     # 提取容量
  99.     volume = re.search(
  100.         r'(?:volume:|volume was|TEUs\.|TEUs |TEU |$)\s(\d+|,)+.*?|(\d+|,)+.(?:\sTEUs|\sTEU)',
  101.         email, re.I
  102.     )
  103.     if volume:
  104.         volume = get_number(volume[0].strip())
  105.     if not volume:
  106.         volume = 'Volume not found'
  108.     # 提取剩余库存A
  109.     remaining_stock_a = re.search(r'(?:stock A:|stock A: |$)(\d+|,)+.*?', email, re.I)
  110.     if remaining_stock_a:
  111.         remaining_stock_a = remaining_stock_a[0].strip()
  112.     if not remaining_stock_a:
  113.         remaining_stock_a = re.search(r'(\d+)(.+)(stock A)', email, re.I)
  114.         if remaining_stock_a:
  115.             remaining_stock_a = remaining_stock_a[0].strip()
  116.     if remaining_stock_a:
  117.         remaining_stock_a = get_number(remaining_stock_a)
  118.     if not remaining_stock_a:
  119.         remaining_stock_a = 'Remaining stock A not found'
  120.     return volume, remaining_stock_a
  123. def extract_stock_volume_from_emails(
  124.     emails: List[str],
  125. ) -> List[Tuple[int | float | str, int | float | str]]:
  126.     """
  127.     将函数`extract_stock_volume_from_email`应用于电子邮件列表。
  129.     Parameters
  130.     ----------
  131.     emails : List[str]
  132.         要解析的电子邮件文本列表。
  134.     Returns
  135.     -------
  136.     List[Tuple[int | float | str, int | float | str]]
  137.         包含从每封电子邮件中提取的容量和剩余库存A的元组列表。
  138.         如果无法从电子邮件中提取容量或库存A详细信息，则元组中的相应元素将是'Volume not found'或'Remaining stock A not found'。
  140.     Raises
  141.     ------
  142.     re.error
  143.         如果在`extract_stock_volume_from_email`中使用无效的正则表达式。
  145.     See Also
  146.     --------
  147.     extract_stock_volume_from_email：用于从每封电子邮件中提取详细信息的函数。
  149.     Examples
  150.     --------
  151.     >>> email_texts = [
  152.     ...     "The volume was 5000 TEUs. Stock A: 1000 units.",
  153.     ...     "No volume and stock data available.",
  154.     ... ]
  155.     >>> extract_stock_volume_from_emails(email_texts)
  156.     [(5000, 1000), ('Volume not found', 'Remaining stock A not found')]
  157.     """
  158.     return list(map(extract_stock_volume_from_email, emails))

使用上述代码对您提供的示例电子邮件进行操作：

  1. emails = [
  2.     r"""Dear all,
  4. Please note the Total selling volume and total remaining stock
  6. Total selling volume: 45677 Total remaining stock A:3456
  8. Remain at your disposal in case of any doubt or comments.
  10. Best Regards,""",
  11.     r"""Dear all,
  13. Please see the data as below:
  15. Tol volume: 1,231,245 No. of remaining stock A: 232 No. of remaining stock B: 1,435""",
  16.     r"""Dear All,
  18. Please find our volume was 
  20. <details>
  21. <summary>英文:</summary>
  23. Here&#39;s a solution using RegEx:
  25. ```python
  26. from __future__ import annotations
  28. import re
  29. from typing import List, Tuple
  32. def get_number(text: str) -&gt; float | int | str:
  33.     &quot;&quot;&quot;
  34.     Extract the first numeric value from the input string.
  36.     The function uses regular expressions to extract the first numeric
  37.     occurrence from `text`. If no numeric value is found, the original string
  38.     is returned. Commas are removed from the extracted number, if any.
  39.     The function first attempts to convert the number to an integer,
  40.     and if that fails, it tries to convert it to a float.
  42.     Parameters
  43.     ----------
  44.     text : str
  45.         The string from which the numeric value should be extracted.
  47.     Returns
  48.     -------
  49.     float | int | str
  50.         The first numeric value in `text` converted to int or float,
  51.         or original `text` if no numeric value is found.
  53.     Raises
  54.     ------
  55.     ValueError
  56.         If the extracted number can&#39;t be converted to an integer or a float.
  58.     Examples
  59.     --------
  60.     Illustration of the function usage and behavior.
  62.     &gt;&gt;&gt; get_number(&quot;Hello world 123!&quot;)
  63.     123
  64.     &gt;&gt;&gt; get_number(&quot;I have 2,200 dollars.&quot;)
  65.     2200
  66.     &gt;&gt;&gt; get_number(&quot;No numbers here.&quot;)
  67.     &#39;No numbers here.&#39;
  68.     &gt;&gt;&gt; get_number(&quot;It is over 9000!&quot;)
  69.     9000
  70.     &gt;&gt;&gt; get_number(&quot;The value of pi is about 3.14159.&quot;)
  71.     3.14159
  72.     &gt;&gt;&gt; get_number(&quot;Total: 123,456,789.&quot;)
  73.     123456789.0
  74.     &quot;&quot;&quot;
  75.     number = re.search(r&#39;(\d+|,)+.&#39;, text, re.I)
  76.     if number:
  77.         number = number[0].strip().replace(&#39;,&#39;, &#39;&#39;)
  78.     if not number:
  79.         print(f&quot;Found no numbers inside text: {text!r}&quot;)
  80.         return text
  81.     try:
  82.         return int(number)
  83.     except ValueError:
  84.         return float(number)
  87. def extract_stock_volume_from_email(email: str) -&gt; Tuple[int | float | str, int | float | str]:
  88.     &quot;&quot;&quot;
  89.     Extract the volume and remaining stock A details from an email text.
  91.     This function employs regular expressions to parse the given email text and
  92.     extract details about volume and remaining stock A.
  93.     The values extracted are then cleaned and returned.
  95.     Parameters
  96.     ----------
  97.     email : str
  98.         Text from the email to parse.
  100.     Returns
  101.     -------
  102.     volume : int | float | str
  103.         Volume extracted from the email.
  104.         Returns &#39;Volume not found&#39; if no volume details are found.
  105.     remaining_stock_a : int | float | str
  106.         Remaining stock A extracted from the email.
  107.         Returns &#39;Remaining stock A not found&#39; if no stock A details are found.
  109.     Raises
  110.     ------
  111.     re.error
  112.         If a non-valid regular expression is used.
  114.     See Also
  115.     --------
  116.     re.search : The method used for extracting volume and remaining stock details.
  118.     Examples
  119.     --------
  120.     &gt;&gt;&gt; email_text = &quot;The volume was 5000 TEUs. Stock A: 1000 units.&quot;
  121.     &gt;&gt;&gt; extract_stock_volume_from_email(email_text)
  122.     (5000, 1000)
  123.     &gt;&gt;&gt; email_text = &quot;No volume and stock data available.&quot;
  124.     &gt;&gt;&gt; extract_stock_volume_from_email(email_text)
  125.     (&#39;Volume not found&#39;, &#39;Remaining stock A not found&#39;)
  126.     &quot;&quot;&quot;
  127.     # Extract the volume
  128.     volume = re.search(
  129.         r&#39;(?:volume:|volume was|TEUs\.|TEUs |TEU |$)\s(\d+|,)+.*?|(\d+|,)+.(?:\sTEUs|\sTEU)&#39;,
  130.         email, re.I
  131.     )
  132.     if volume:
  133.         volume = get_number(volume[0].strip())
  134.     if not volume:
  135.         volume = &#39;Volume not found&#39;
  137.     # Extract the remaining stock
  138.     remaining_stock_a = re.search(r&#39;(?:stock A:|stock A: |$)(\d+|,)+.*?&#39;, email, re.I)
  139.     if remaining_stock_a:
  140.         remaining_stock_a = remaining_stock_a[0].strip()
  141.     if not remaining_stock_a:
  142.         remaining_stock_a = re.search(r&#39;(\d+)(.+)(stock A)&#39;, email, re.I)
  143.         if remaining_stock_a:
  144.             remaining_stock_a = remaining_stock_a[0].strip()
  145.     if remaining_stock_a:
  146.         remaining_stock_a = get_number(remaining_stock_a)
  147.     if not remaining_stock_a:
  148.         remaining_stock_a = &#39;Remaining stock A not found&#39;
  149.     # print(f&quot;Volume: {volume}\nRemaining Stock A: {remaining_stock_a}\n&quot;)
  150.     return volume, remaining_stock_a
  153. def extract_stock_volume_from_emails(
  154.     emails: List[str],
  155. ) -&gt; List[Tuple[int | float | str, int | float | str]]:
  156.     &quot;&quot;&quot;
  157.     Apply the function `extract_stock_volume_from_email` to a list of emails.
  159.     Parameters
  160.     ----------
  161.     emails : List[str]
  162.         A list of email texts to be parsed.
  164.     Returns
  165.     -------
  166.     List[Tuple[int | float | str, int | float | str]]
  167.         A list of tuples. Each tuple contains the volume and remaining stock A
  168.         extracted from each email. If no volume or stock A details could be
  169.         extracted from an email, the corresponding element in the tuple will be
  170.         &#39;Volume not found&#39; or &#39;Remaining stock A not found&#39;, respectively.
  172.     Raises
  173.     ------
  174.     re.error
  175.         If a non-valid regular expression is used in `extract_stock_volume_from_email`.
  177.     See Also
  178.     --------
  179.     extract_stock_volume_from_email : The function used to extract details from each email.
  181.     Examples
  182.     --------
  183.     &gt;&gt;&gt; email_texts = [
  184.     ...     &quot;The volume was 5000 TEUs. Stock A: 1000 units.&quot;,
  185.     ...     &quot;No volume and stock data available.&quot;,
  186.     ... ]
  187.     &gt;&gt;&gt; extract_stock_volume_from_emails(email_texts)
  188.     [(5000, 1000), (&#39;Volume not found&#39;, &#39;Remaining stock A not found&#39;)]
  189.     &quot;&quot;&quot;
  190.     return list(map(extract_stock_volume_from_email, emails))

Using the above code on the e-mails you provided as example:

  1. emails = [
  2.     r&quot;&quot;&quot;Dear all,
  4. Please note the Total selling volume and total remaining stock
  6. Total selling volume: 45677 Total remaining stock A:3456
  8. Remain at your disposal in case of any doubt or comments.
  10. Best Regards,&quot;&quot;&quot;,
  11.     r&quot;&quot;&quot;Dear all,
  13. Please see the data as below:
  15. Tol volume: 1,231,245 No. of remaining stock A: 232 No. of remaining stock B: 1,435&quot;&quot;&quot;,
  16.     r&quot;&quot;&quot;Dear All,
  18. Please find our volume was 233,435
  20. Total remaining stock A: 2453&quot;&quot;&quot;,
  21.     r&quot;In May we had 90 remaining stock A and 4190 TEUs.&quot;,
  22. ]
  23. extract_stock_volume_from_emails(emails)
  24. # Returns:
  25. #
  26. # [(45677, 3456), (1231245, 232), (233435, 2453), (4190, 90)]
  27. #  ^----^  ^--^
  28. #  |       |
  29. #  |       +-- Remaining stock A
  30. #  +-- Volume

Note

It should be noted that the function extract_stock_volume_from_email, that parses each e-mail is not failproof. The RegEx patterns it contains were all based on the e-mails you provided as example. If other e-mails don't follow the same patterns as the example e-mails, these additional patterns will have to be added to the extract_stock_volume_from_email function.

答案2

得分: 0

import re

email_content = """亲爱的大家，请注意总销售量
和总剩余库存 总销售量：45677 总剩余库存A：3456 如有任何疑问或意见，请随时联系。
最好的问候，
"""

正则表达式模式以匹配数字及其上下文

number_pattern = r'总销售量：(\d+[.,]?\d+)\s+总剩余库存A：(\d+[.,]?\d+)'

使用正则表达式提取数字及其上下文

matches = re.findall(number_pattern, email_content)

for match in matches:
total_selling_volume = match[0]
total_remaining_stock = match[1]
print("总销售量：", total_selling_volume)
print("总剩余库存A：", total_remaining_stock)

输出

总销售量：45677
总剩余库存A：3456

英文: 
  1. import re
  2. email_content = &quot;&quot;&quot;Dear all,Please note the Total selling volume 
  3. and total remaining stock Total selling volume: 45677 Total 
  4. remaining stock A:3456 Remain at your disposal in case of any 
  5. doubt or comments.
  6. Best Regards,
  7. &quot;&quot;&quot;
  8. #Regular expression pattern to match numbers and their context
  9. number_pattern = r&#39;Total selling volume: (\d+[.,]?\d+)\s+Total 
  10. remaining stock A:(\d+[.,]?\d+)&#39;
  11. #Extract numbers and their context using regular expression
  12. matches = re.findall(number_pattern, email_content)
  13. for match in matches:
  14. total_selling_volume = match[0]
  15. total_remaining_stock = match[1]
  16. print(&quot;Total selling volume:&quot;, total_selling_volume)
  17. print(&quot;Total remaining stock:&quot;, total_remaining_stock)
  18. #Output
  19. Total selling volume: 45677
  20. Total remaining stock: 3456

huangapple
  • 本文由 发表于 2023年6月13日 11:32:47
  • 转载请务必保留本文链接：https://go.coder-hub.com/76461534.html
  • artificial-intelligence
  • extract
  • nlp
  • python
  • text-extraction
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定