title: Python: Split data from csv file in format
body: <p>I am trying to split <code>data['Title']</code> from CSV file  and separate:</p>
  <ul>
  <li>Brand Name</li>
  <li>Model Name</li>
  <li>Engine capacity <em>(like 2.2 or 500)</em></li>
  <li>HorsePower <em>(number with KM)</em></li>
  <li>EnginePower <em>(number with kW)</em></li>
  <li>Model Year <em>(a single year or start_year-end_year)</em></li>
  </ul>
  <p>I did like this, but how can I add all <strong>KM</strong>, <strong>KW</strong>, <strong>Year</strong> and <strong>engine capacity</strong> in each single columns like this</p>
  <p>Here is My Database Link In CSV File <code>https://www.kaggle.com/iamrraj/my-database</code> and here is my code:</p>
  <pre><code>import pandas as pd
  data = pd.read_csv(&quot;../input/Car_data_-_specs_-_Data.csv&quot;)
  data1 = data.Title.str.split(&quot; &quot;,expand=True,)
  data1.head()
  data1.drop(data1.columns[11:18], axis=1, inplace=True)
  data1.head(5)
  </code></pre>
  <p>And i am getting output like this</p>
  <pre><code>0   1   2   3   4   5   6   7   8   9   10
  0   Abarth  124     Spider  1.4     T-Jet   170KM   125kW   2016-2019   None    None    None
  1   Abarth  500     Cabrio  1.4     T-JET   135KM   99kW    2010    None    None    None
  2   Abarth  500     Cabrio  1.4     T-JET   140KM   103kW   2011-2012   None    None    None
  3   Abarth  500     Cabrio  Seria   1   1.4     T-Jet   16V     135KM   99kW    2014-2016
  4   Abarth  500     Cabrio  Seria   1   1.4     T-Jet   16V     140KM   103kW   2012-2014
  </code></pre>
  <p>But i want data like this after split
  SO how to do it please help me</p>
  <pre><code>HorsePower  EnginePower   Engine capacity   Model Year    Model Name   Brand Name
   100KM        20KM            2.2           2019-2020     Land Rover    LandRoverDefender
   80KM         40KM            500           2017-2018     Alfa Romeo    AlfaRomeoStelvio
  </code></pre>
  <p>Here Its After read csv file looks like</p>
  <p><img src="https://i.stack.imgur.com/MiJtW.png" alt="Data looks Lik this aafter read" /></p>