title: Pandas: How to read CSV file from google drive public?
body: <p>I searched similar questions about reading csv from URL but I could not find a way to read csv file from google drive csv file.</p>
  
  <p>My attempt:</p>
  
  <pre class="lang-py prettyprint-override"><code>import pandas as pd
  
  url = 'https://drive.google.com/file/d/0B6GhBwm5vaB2ekdlZW5WZnppb28/view?usp=sharing'
  dfs = pd.read_html(url)
  </code></pre>
  
  <p>How can we read this file in pandas?</p>
  
  <p>Related links:  </p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/32400867/pandas-read-csv-from-url">Pandas read_csv from url</a>  </li>
  <li><a href="https://pandas.pydata.org/pandas-docs/version/0.22/io.html#io-read-html" rel="noreferrer">https://pandas.pydata.org/pandas-docs/version/0.22/io.html#io-read-html</a></li>
  </ul>