title: Lambda function to grab numbers from a specific string
body: <p>Is there a way to create a function that searches an entire dataframe for a string, when it finds said string then pulls the proceeding numbers from it?</p>
  
  <p>ex dataframe:</p>
  
  <pre><code>1                       2                               3                       4 
  6/9/2020 1 Per Page  IRES MLS  : 91 PRICE: $59,900    Beautiful Views Sold   Total Concession: $2000
  6/9/2020 1 Per Page  IRES MLS : 906 PRICE: $350,000   Fast Seller!           Total Concession: $5029
  6/9/2020 1 Per Page  IRES MLS : 908 PRICE: $360,000   Total Concession: $9000
  </code></pre>
  
  <p>I was able to create a function which tells if that string exists or not and returns a boolean value</p>
  
  <pre><code>#searches the dataframe for the words Total Concession and returns if True
  df['Concession'] = df.apply(lambda row: row.astype(str).str.contains('Total Concession', regex=True).any(), axis=1)
  </code></pre>
  
  <p>Total Concession doesn't have one column within the created dataframe, it's found within different columns in the dataframe. I was wondering if there was a way to do so it returns this. </p>
  
  <pre><code>Concession
  2000
  5029
  9000
  </code></pre>