title: Extracting numbers from outlook email body with Python
body: <p>I get hourly email alerts that tell me how much revenue the company has made in the last hour. I want to extract this information into a pandas dataframe so that i can run some analysis on it.</p>
  
  <p>My problem is that i can't figure out how to extract data from the email body in a usable format. I think i need to use regular expressions but i'm not too familiar with them.</p>
  
  <p>This is what i have so far:</p>
  
  <pre><code>import os
  import pandas as pd
  import datetime as dt
  import win32com.client
  
  outlook = win32com.client.Dispatch("Outlook.Application").GetNamespace("MAPI")
  inbox = outlook.GetDefaultFolder(6)
  messages = inbox.Items
  
  #Empty Lists
  email_subject = []
  email_date = []
  email_content = []
  
  #find emails
  
  for message in messages:
      if message.SenderEmailAddress == 'oracle@xyz.com' and message.Subject.startswith('Demand'):
          email_subject.append(message.Subject)
          email_date.append(message.senton.date()) 
          email_content.append(message.body)
  </code></pre>
  
  <p>The email_content list looks like this:</p>
  
  <pre><code>'                                                                                                                   \r\nDemand: $41,225 (-47%)\t                                                                            \r\n                                                                                                                       \r\nOrders: 515 (-53%)\t                                                                                \r\nUnits: 849 (-59%)\t                                                                                 \r\n                                                                                                                       \r\nAOV: $80 (12%)                                                                                                          \r\nAUR: $49 (30%)                                                                                                          \r\n                                                                                                                       \r\nOrders with Promo Code: 3%                                                                                              \r\nAverage Discount: 21%                                                                                             '
  </code></pre>
  
  <p>Can anyone tell me how i can split its contents to so that i can get the int value of Demand, Orders and Units in separate columns?</p>
  
  <p>Thanks!</p>