How to get specific file version from git repository using python

Question

I have a local git repo and I'm trying to find a way to get a specific version of my xlsx file into my Python code so I can process it using pandas.

I found gitpython lib; but I'm not sure how to use it correctly.

repo = Repo(path_to_repo)
commit = repo.commit(sha)
targetfile = commit.tree / 'dataset.xlsx'

I don't know what to do next. I tried to load it to pandas using path; but, of course, it just loads my last version.

How to load previous version of xlsx to pandas?

Answer 1

When you ask for commit.tree / 'dataset.xlsx', you get back a git.Blob object:

>>> targetfile
<git.Blob "3137d9443f54325b8ad8a263b13053fee47fbff2">

If you want to read the contents of the object, you can extract the content using data_stream method, which returns a file-like object:

>>> data = targetfile.data_stream.read()

Or you can use the stream_data method (don't look at me, I didn't name them), which writes data into a file-like object:

>>> import io
>>> buf = io.BytesIO()
>>> targetfile.stream_data(buf)
<git.Blob "3137d9443f54325b8ad8a263b13053fee47fbff2">
>>> buf.getvalue()
b'The contents of the file...'