Collect data using GitHub GraphQL API

Job ID: 35375913

Budget: $30 – $250 USD

I need a GraphQL expert who is familiar with GitHub GraphQL API and Python. This task should be completed urgently, so, don't make a bid if you are not familiar with GraphQL and Python.

The task is to develop a Jupyter notebook which takes a GitHub repository as an input (identified by organization name and repo name), collects user activity on the repo using GitHub's GraphQL API, and outputs two Pandas DataFrames as following:

1. "activity_stream" that captures activity on a given repo (e.g. when someone stars, forks, opens a PR or an issue - they should be in a row) with the following fields:
- occured_at (timestamp)
- activity_type (e.g. "starred", "opended_pr", "opened_issue", "forked")
- activity_url (e.g., for a PR, URL of the PR; for an issue, URL of an issue; NULL for star)
- github_username
2. "people" that acts as a dimension and provide lookup information for people in the "activity_stream" (below fields are GitHub API fields):
- github_username (login)
- email
- name
- bio
- company
- repositories (first: 100, isFork: false) totalCount
- isHireable
- avatarUrl
- createdAt
- updatedAt
- twitterUsername
- websiteUrl
- followers(first: 0) totalCount
- following(first: 0) totalCount