Create Python script(s) to collate Support Request data

[andyrogers1973]

Currently the Support Request stats are tracked via Google Sheets and reported manually in stand up. This ticket is to create the same functionality using GitHub and enable automatic reporting to Slack.

I am testing this functionality because:

• we cannot get a license for the Google Sheets API and this blocks us from reading the stats sheet via GitHub
• processes already exist to report the support data from GitHub into a Slack channel
• anyone on the team will be able to update the .csv in GitHub

The repo operations-engineering-support-metadata exists and support_requests.csv file exists. I now need to collate data from this sheet using python. To replicate the functionality of the current sheet I need to be able to:

• extract yesterdays support requests information by request_type and amount

Once collated I will need the script to report this data in a readable format to a Slack channel.

Considered done when:

• data is collated as expected
• data is published automatically into a Slack channel

[andyrogers1973]

Script started and able to read the test.csv file.

Currently unable to edit this file in table format so investigating how to fix that.

[andyrogers1973]

Reduced the size of the .csv for testing

[andyrogers1973]

Can now edit csv file via GitHUb developer web using VSCode web.

Basic script now able to total daily requests via date.

[andyrogers1973]

Script is now able to:

• create a dataframe from .csv file
• find yesterdays date based upon column header
• count the total number of requests for yesterday
• extract rows to show the Request Types and amount

[andyrogers1973]

Script updated and workflow created. Testing to OPS_ENG_SR_TEST channel.

Dataframe is working and generating:

• Yesterdays total support requests
• Breakdown of yesterdays support requests

Message is successfully sent to the test channel:

Operations Engineering Notification APP Good morning, Yesterday we received 10.0 Support Requests Here's a breakdown of yesterdays Support Requests: Request Type 2024-03-26 0 GitHub – add user to org 2.0 1 GitHub – remove user from org 1.0 4 GitHub – remove user from team/repo 1.0 13 GitHub - add Renovate to repo 2.0 15 GitHub - information/help 1.0 20 1Password - information/help 1.0 30 Sonarcloud 1.0 33 General infomation/help 1.0

[andyrogers1973]

Considered done as:

• data is collated as expected: yesterdays total requests and a breakdown of these requests
• message containing this data is successfully sent to the test channel (OPS_ENG_SR_TEST)