title: Databricks Python handling with delimiter
body: <p>I am using Python in order to make a dataframe based on a CSV file.</p>
  <p>The input CSV file looks like this:</p>
  <p><a href="https://i.stack.imgur.com/NO0qE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NO0qE.png" alt="enter image description here" /></a></p>
  <p>After running the following code:</p>
  <pre><code>dataframe_sales = spark.read.format('csv').options(header='true',inferSchema='true').load('/mnt/sadwhpostgre001/excel/goud/sales_file.csv')
  </code></pre>
  <p>I see that the  some characters on of the column <code>CompanyName</code> moved to the right.</p>
  <p>See the output file:</p>
  <p><a href="https://i.stack.imgur.com/kdNnn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kdNnn.png" alt="enter image description here" /></a></p>
  <p>How can I make a dataframe that just keeps the structure of the values on the record? So after making a dataframe the structure must be the same as the input CSV file.</p>