title: Sharepoint excel data take into Pandas data frame without downloading
body: <p>I need to take my SharePoint excel file in to pandas data frame because I need to do analysis using python for that excel file. to access the SharePoint I use bellow code and it works. From bellow code I can access my excel file which located in SharePoint. Now I want take my excel file in to pandas data frame.so how I can modify bellow code?</p>
  <pre><code>from office365.sharepoint.client_context import ClientContext
  
  SP_SITE_URL ='https://asdfgh.sharepoint.com/sites/ABC/'
  SP_DOC_LIBRARY ='Publications'
  USERNAME ='asd@fgh.onmicrosoft.com'
  PASSWORD ='******' 
  
  # 1. Create a ClientContext object and use the user’s credentials for authentication 
  ctx =ClientContext(SP_SITE_URL).with_user_credentials(USERNAME, PASSWORD) 
  
  # 2. Read file entities from the SharePoint document library 
  files = ctx.web.lists.get_by_title(SP_DOC_LIBRARY).root_folder.files 
  ctx.load(files)
  ctx.execute_query()
  
  # 3. loop through file entities
  for filein files: 
    # 4. Access the file object properties 
    print(file.properties['Name'], file.properties['UniqueId'])
    # 5. Access list item object through the file object 
    item = file.listItemAllFields
    ctx.load(item) 
    ctx.execute_query() 
    print('Access metadata - Category: {0}, Status: {1}'.format(item.properties['Category'], item.properties['Status']))
  
  # 4. The Output: 
  # File Handling in SharePoint Document Library Using Python.docx 77819f08-5fbe-450f-9f9b-d3ae2862cbb5
  # Access metadata - Category: Python, Status: Submitted 
  </code></pre>