title: How to upload csv file into google drive and read it from same into python
body: <p>I have a google drive which I have my csv file uploaded in already, the link to share that file is given as:</p>
  
  <pre><code>https://drive.google.com/open?id=1P_UYUsgvGXUhPCKQiZWlEAynKoeldWEi
  </code></pre>
  
  <p>I also know my the directory to the drive as:</p>
  
  <p>C:/Users/.../Google Drive/</p>
  
  <p>Please give me a step-by-step guide to achieving how to read this particular csv file directly from google drive and not by downloading it to my PC first before reading it to python.</p>
  
  <p>I have searched this forum and tried some given solutions such as: </p>
  
  <p><a href="https://stackoverflow.com/questions/48436959/how-to-upload-csv-file-and-use-it-from-google-drive-into-google-colaboratory?rq=1">How to upload csv file (and use it) from google drive into google colaboratory
  </a> </p>
  
  <p>It did not work for me, it resulted to the below error:</p>
  
  <pre><code>      3 from pydrive.auth import GoogleAuth
        4 from pydrive.drive import GoogleDrive
  ----&gt; 5 from google.colab import auth
        6 from oauth2client.client import GoogleCredentials
        7 
  
  ModuleNotFoundError: No module named 'google.colab'
  </code></pre>