title: How can I import csv-file with multi-character delimiters into dataframe in Python?
body: <p>I have this movies.csv <a href="http://movies.task-sss.krasilnikov.spb.ru/data/9f66a575a6cfaaf7e43177317461d057" rel="nofollow noreferrer">csv-file</a> which I am to import into dataframe named 'movies'. But I have some troubles with erasing these #, ##, ###, #### delimiters. <a href="https://i.stack.imgur.com/nlv3P.png" rel="nofollow noreferrer">enter image description here</a>
  I tried this code:</p>
  
  <pre><code>    import pandas as pd
  my_cols=["Title", "US Gross", "Worldwide Gross", "Production Budget", "Release Date", "Distributor", "Source", "Major Genre", "Creative Type","Director","Rotten Tomatoes","Rating","IMDB Rating","IMDB Votes"]
  movies=pd.read_csv('movies.csv', 
                     sep="\#\#\#\#",
                     quotechar='"',
                     names=my_cols,
                     engine="python")
  movies
  </code></pre>
  
  <p>but it still leaves this sign "#" and makes only 1 column. Please, help to fix this.</p>
  
  <p>here is a few lines from CSV:
  Title#US Gross#Worldwide Gross#Production Budget#Release Date#Distributor#Source#Major Genre#Creative Type#Director#Rotten Tomatoes Rating#IMDB 
  The Land Girls#146083#"146083"#"8000000"#12.6.1998#Gramercy####""##6,1#1071</p>