title: How to read an excel dataframe from a private GitHub repository using pandas?
body: <p>I have a working website made using django. I have a private GitHub repository, within it I have excel files which I want to read using <code>pandas read_excel</code> and use on the website. The reason I have made the repository private is because the data is company specific.</p>
  
  <p>1) How do I read an excel file using pandas from a private GitHub repository? Do I need to set up personal access token?</p>
  
  <p>2) After a user logs in to my website, is there then a way to require a further password when they navigate to try and view their company specific dataframe? For example, "User A" will only have access to "Dataframe A", and "User B" will only have access to "Data frame B".</p>
  
  <p>On my local system, the following code works to be able to read the dataframe:</p>
  
  <pre><code>file_path = 'C:/Users/james/Desktop/projects/path/to/excel/file
  df = pd.read_excel(file_path)
  </code></pre>
  
  <p>For my live website, my code which produces the problem is:</p>
  
  <pre><code>URL_path = 'https://github.com/path/to/excel/file/in/private/repository
  df = pd.read_excel(URL_path)
  </code></pre>
  
  <p>I am able to read the excel files on my local computer, but when I try to read in from my private github, I get the following error, even though I know I am using the correct url:</p>
  
  <p><code>urllib.error.HTTPError: HTTP Error 404: Not Found</code></p>
  
  <p>I verified this by signing out of my github account, and trying to access the github url with my excel in it, it takes me to a <code>404 not found</code> page since I am not logged in. When I login to my github account, the same URL takes me to the correct page.</p>