title: Replace comma with semicolon when creating Csv Dataframe
body: <p>I have a code that creates a csv file, when I first open it I everything is in one column so I have  to do the usual</p>
  
  <p>Go to    Data and do the following. The data is then spplited into columns.</p>
  
  <p><a href="https://i.stack.imgur.com/DtVOv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DtVOv.png" alt="enter image description here"></a></p>
  
  <p>I work with Office 365, and recently I was told that if I change the commas with semicolons then when I open the newly created file Csv file, Excel will automatically open the file already separated into columns.</p>
  
  <p>I’m asking for some advice here, since having to do this process for every created Csv file is really time consuming.</p>
  
  <p>Looking for a way to alter my code so it does this automatically maybe instead of splitting columns with commas, do it with semicolons in this case. Just to try if this works out. </p>
  
  <pre><code>with open('created.csv', 'w', newline='') as f:
      writer = csv.writer(f)
  
  
    [1]: https://i.stack.imgur.com/OtxO4.png
  </code></pre>