title: How to upload csv file (and use it) from google drive into google colaboratory
body: <p>Wanted to try out python, and google colaboratory <em>seemed</em> the easiest option.I have some files in my google drive, and wanted to upload them into google colaboratory.
  so here is the code that i am using:</p>
  
  <pre><code>!pip install -U -q PyDrive
  
  from pydrive.auth import GoogleAuth
  from pydrive.drive import GoogleDrive
  from google.colab import auth
  from oauth2client.client import GoogleCredentials
  
  # 1. Authenticate and create the PyDrive client.
  auth.authenticate_user()
  gauth = GoogleAuth()
  gauth.credentials = GoogleCredentials.get_application_default()
  drive = GoogleDrive(gauth)
  
  # 2. Create &amp; upload a file text file.
  uploaded = drive.CreateFile({'xyz.csv': 'C:/Users/abc/Google Drive/def/xyz.csv'})
  uploaded.Upload()
  print('Uploaded file with title {}'.format(uploaded.get('title')))
  
  import pandas as pd
  xyz = pd.read_csv('Untitled.csv')
  </code></pre>
  
  <p>Basically, for user "abc", i wanted to upload the file xyz.csv from the folder "def".
  I can upload the file, but when i ask for the title it says the title is "Untitled".
  when i ask for the Id of the file that was uploaded, it changes everytime, so i can not use the Id.</p>
  
  <p>How do i read the file??? and set a proper file name???</p>
  
  <pre><code>xyz = pd.read_csv('Untitled.csv') doesnt work
  xyz = pd.read_csv('Untitled') doesnt work
  xyz = pd.read_csv('xyz.csv') doesnt work
  </code></pre>
  
  <p>Here are some other links that i found..</p>
  
  <p><a href="https://stackoverflow.com/questions/47212852/how-to-import-and-read-a-shelve-or-numpy-file-in-google-colaboratory">How to import and read a shelve or Numpy file in Google Colaboratory?</a></p>
  
  <p><a href="https://stackoverflow.com/questions/47320052/load-local-data-files-to-colaboratory">Load local data files to Colaboratory</a></p>