title: Dataframe Column into Multiple Columns by delimiter ',' : expand = True, n =-1
body: <p>My first question thanks) Sorry for lengthy formulationenter image description here
  Researched all related posts</p>
  <p><strong>What I have</strong></p>
  <ul>
  <li>my Dataframe column (please see screenshot) is strings separated by delimiter ',' Car parameters.</li>
  </ul>
  <p><strong>My Dataframe:-</strong></p>
  <p><a href="https://i.stack.imgur.com/NxnIn.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NxnIn.jpg" alt="enter image description here" /></a></p>
  <ul>
  <li>Some  rows come with mileage while others not (screenshot) hence some rows have fewer delimiters.</li>
  </ul>
  <p><strong>The Task</strong></p>
  <ul>
  <li><p>Need to create 5 columns (max number of delimiters) to store CarParameters separately (Mileage, GearBox, HP, Body etc)</p>
  </li>
  <li><p>If a row doesn't have Mileage Put 0 in the Mileage Column</p>
  </li>
  </ul>
  <p><strong>What I know and works well</strong></p>
  <p><code>df[&quot;name&quot;].str.split(&quot; &quot;, expand = True)</code> by default <code>n=-1</code> and splits into necessary columns
  example:</p>
  <p><strong>The issue:</strong></p>
  <ul>
  <li>If I use the <code>str.split(&quot; &quot;, expand = True)</code> method - GearBox (ATM) is wrongly put under newly created Mileage column because that row is short of one delimiter (screenshot)</li>
  </ul>
  <p>Result:-</p>
  <p><a href="https://i.stack.imgur.com/PvQ4m.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PvQ4m.jpg" alt="enter image description here" /></a></p>
  <p>-</p>