How do I open a tab delimited text file in pandas so that I can then use it for exploratory data analysis?
<p>I have a tab delimited file with data about some movies. Some movie titles are enclosed in a double quote. How can I read the file into a pandas dataframe and how can I remove the double quote from the movie titles?  </p>

<p>I know how to do it in R and I know how to remove the double quotes. However, is there an equivalent function in pandas to do that? But most importantly how do I load it into a pandas dataframe?</p>

<p>First you'll want to
   import pandas</p>

<pre><code>Df = pandas.read_csv("file.csv")
</code></pre>

<p>Get rid of double quotes with</p>

<pre><code>Df2 = Df['columnwithquotes'].apply(lambda x: x.replace('"', ''))
</code></pre>

python pandas