title: Convert Sharepoint List into Pandas Dataframe
body: <p>I have a table in Sharepoint that I'm wanting to convert into a Pandas Dataframe. I've largely used this question to try and frame a solution <a href="https://stackoverflow.com/questions/42903036/get-sharepoint-list-with-python">Get SharePoint List with Python</a>. I'm having issues however.</p>
  <p>Here is what I have so far...</p>
  <pre><code>import pandas as pd
  from shareplum import Site
  from requests_ntlm import HttpNtlmAuth
  
  url = 'https://share.corporation.com/sites/group/subgroup/'
  
  username = 'username'
  password = 'password'
  
  cred = HttpNtlmAuth(username, password)
  site = Site(url, auth=cred, verify_ssl=False)
  </code></pre>
  <p>Up to this point, I can run the code without an error being thrown. However, when I run this bit:</p>
  <pre><code>sp_list = site.List('Q22020') # this creates SharePlum object
  
  ShareplumRequestError: Shareplum HTTP Post Failed : 500 Server Error: Internal Server Error for url: https://share.corporation.com/sites/group/subgroup/_vti_bin/lists.asmx
  </code></pre>
  <p>I'm actually not entirely sure that my <code>site.List('Q22020')</code> is even correct.</p>
  <p>However, following the instructions from this video: <a href="https://www.youtube.com/watch?v=dvFbVPDQYyk" rel="nofollow noreferrer">https://www.youtube.com/watch?v=dvFbVPDQYyk</a></p>
  <p>When I manually enter the following url into my browser, it does generate an xml file, so I believe it's correct: <code>https://share.corporation.com/sites/group/subgroup/_vti_bin/ListData.svc/Q22020</code></p>