title: Pandas remove all of a string in a column after a character
body: <p>So I have a data set with over 500 rows where one of the columns has values like this:</p>
  
  <p>df:</p>
  
  <pre><code>         column1
  
   0    a{'...'}  
   1    b{'...'}
   2    c{'...'}  
   3    d{'...'}  
  </code></pre>
  
  <p>I want to remove everything within and including the <code>{}</code>.</p>
  
  <p>I have been looking at this question, <a href="https://stackoverflow.com/questions/23767376/pandas-delete-parts-of-string-after-specified-character-inside-a-dataframe">Pandas delete parts of string after specified character inside a dataframe</a> and tried the solutions there but I keep getting errors(And I am aware that <code>StringIO</code> is now <code>io.StringIO</code>).</p>
  
  <p>I've tried </p>
  
  <pre><code>df.column1 = df.column1.str.split('{')[0]
  </code></pre>
  
  <p>but get the error message: <code>KeyError: 0</code>  and don't really understand what that means</p>
  
  <p>I've also tried:</p>
  
  <pre><code>df.column1 = df.column1.str.split(pat='{')
  </code></pre>
  
  <p>But this only seems deletes the '{' so I'm left with </p>
  
  <pre><code>      column1
  
   0    a'...'}   
   1    b'...'}
   2    c'...'}   
   3    d'...'}   
  </code></pre>
  
  <p>Also I'm not sure if it's important but the column is an <code>object</code> type.
  Can anyone tell me what I'm doing wrong and how to fix the issue??? </p>