Background
In T177354, we calculated how many files are uploaded by bots vs users on Commons as of Oct 2017, using user_groups, user_former_groups, user, page, categorylinks, image table in commonswiki database. The codebase for this analysis is on GitHub.
Objective
Your task is to reproduce the analysis. If you can use different data or presentation to answer the question, or figure out additional insights that were not in the original report, great!
Create a repository on Github to store your code and report in.