title: Left String Function on Pandas Dataframe that Finds Character Location to Stop
body: <p>I have a Pandas dataframe that has a column that looks like this: </p>
  
  <pre><code>&gt;&gt;&gt; df_clean['my_column']
  
       my_column  
  0   COMPANY1 VIDEO  
  1   COMPANY2 VIDEO  
  2   COMPANY1 VIDEO
  </code></pre>
  
  <p>I want to create a new column <code>(df_clean['my_column_trim'] = pd.DataFrame(df_raw['my_column']...</code> that takes all of the text, starting on the left, until the first <code>' '</code> so the result would look like: </p>
  
  <pre><code>&gt;&gt;&gt; df_clean['my_column_trim']
  
       my_column_trim  
  0   COMPANY1  
  1   COMPANY2  
  2   COMPANY1
  </code></pre>
  
  <p>I'm trying to search for the first <code>' '</code> and then do a left function until that location (pseudo-code equivalent <code>df_clean['final_network'].left(find(' '))</code>).</p>
  
  <p>TIA</p>