title: Python Pandas: Split column and add new column next to current
body: <p>I have a excel sheet similar to this, although with a lot more columns:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Team</th>
  <th>Members</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Team1 (553)</td>
  <td>95435</td>
  </tr>
  <tr>
  <td>Team2 (443)</td>
  <td>872</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to split the team column into Team and a new column, named Team ID. I currently do this with the following code:</p>
  <pre><code>df[['Team', 'Team ID']] = df['Team'].str.split(r&quot;\s\(+(?=\S*$)&quot;, expand=True)
  df['Team ID'] = df['Team ID'].str[:-1]
  </code></pre>
  <p>This works fine (note that Team name can include numbers, spaces and paranthesis). So while this might not be perfect, I gets the job done.</p>
  <p>My issue is that the new column, &quot;Team ID&quot; is placed at the end of the dataset. So it would be &quot;Team - Members - Team ID&quot;. While not an issue with 3 columns, sometimes there is 10 columns where 7 needs to be split.</p>
  <p>So the question: Is there any way to split a column in 2, and place the newly created column next to the old one?</p>