4teamwork / ftw.linkchecker

0 stars 0 forks source link

Implement data extractor for excel reports. #100

Closed busykoala closed 4 years ago

busykoala commented 4 years ago

The change lets one extract the excel report data from within a report in the file listing block configured.

I chose to import the data into a pandas data frame because that makes the data filterable in powerful ways.

Also, the dfs can easily be extracted to lists of dicts which is fantastic for storing the data in more primitive data types in the annotations later on. This simply can be archived by calling df.to_dict('records') and voila, there is your list of dicts 🥰