title: Iterating through a pandas dataframe and inserting new values into an empty column
body: <p>I'm relatively new to Pandas and am having trouble iterating through the values in a given column in my dataset and finding those cells which contain a specific string.</p>
  
  <pre><code>Address,City
  ['1234 Apple Drive', 'San Francisco', 'CA'],''
  ['4678 Bannana Street', 'Austin', 'TX'],''
  </code></pre>
  
  <p>For this example, I want to a) extract just the street information of b) addresses which contain the string 'Street' and c) place them in a newly inserted column named 'Street.' </p>
  
  <pre><code>Address,City,Street
  ['1234 Apple Drive', 'San Francisco', 'CA'],'',''
  ['4678 Bannana Street', 'Austin', 'TX'],'','4678 Bannana Street'
  </code></pre>
  
  <p>I know how to insert a new column into my dataset. My code so far looks like this (assume my current dataset has only two columns and the entries from the example):</p>
  
  <pre><code>import numpy as np
  import pandas as pd
  from pandas import DataFrame, read_csv
  
  df = pd.read_csv('dataset.csv', sep = '\t')
  df.insert(loc=3, column = 'street', value=str)
  </code></pre>
  
  <p>The rest of what I have isn't pretty and has been useless so far. Any help with executing a, b and c is much appreciated! Thanks.</p>