hackforla / hackforla/data-science

CoP: Data Science: Open Source Projects Data Set for Climate projects

Open
#152 45 comments 0 reactions 1 assignee Claimed by @naveen3par View on GitHub
complexity: medium epic: GreenEarthOS feature: missing milestone: missing project: climate projects role: data analysis size: 1pt
Dominant language
Jupyter Notebook
Stars
33
Forks
22
PR merge metrics
No merged PRs in 30d

Description

### Overview
We want to monitor various open source projects and create a script that will keep our listing up-to-date with information such as last active.

### Action Items
- [x] Add each project's URL to the Project URL column (You can see that if you hover over the Project name and description cells. You can also try to pull it from the Project URLs link in Resources below)
- [x] Create a script that will visit each URL and update the following columns (Note that you may have to work around
API limits):
- [x] Project URL
- [x] Last Active Date (Date)
- [x] Number of contributors
- [x] scripts - to copy files over to Hack for LA repository. Code is [here](https://github.com/noneill256/Hack4LA-Project-Spreadsheet-Updater?tab=readme-ov-file).
- [x] Assess current script and make necessary edits so it can be automated to run and produce output periodically.
- [x] Develop a data dashboard to display information in a useful way

### Resources/Instructions
Spreadsheet of open source projects we want to monitor [here](https://docs.google.com/spreadsheets/d/1LFResU_pcP5IMwz92dmPQRoKJ4lNa3tvr-_COJiE_hc/edit#gid=0)
Original source for project URLs [here](https://opensustain.tech/)
[Info about getting URL from a Google Sheet cell](https://www.oksheets.com/extract-hyperlink-url/#:~:text=Extract%20the%20URL%20from%20a%20Hyperlink%20by%20Edit%20and%20Copy&text=You%20can%20right%2Dclick%20on,option%20from%20the%20Insert%20menu.)

OpenSustain.tech-Projects spreadsheet link: [here](https://docs.google.com/spreadsheets/d/1YbL1HG8649UnDdGCXwJRe4lFF8SmEwH31wadtYDiPfM/edit?gid=1365395029#gid=1365395029)

Dashboard Link (Edit):
https://lookerstudio.google.com/u/0/reporting/78668a41-f42f-4e27-886b-3d34fb2c1005/page/BnGnF/edit

Dashboard Link (View):
https://lookerstudio.google.com/u/0/reporting/78668a41-f42f-4e27-886b-3d34fb2c1005/page/BnGnF

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.