Quantitative analysis: merging the data with meta-data from brigades - Githubissues

hackforla / BOP

A repo for tracking work regarding the Brigade Organizer's Playbook

10 stars 6 forks source link

Quantitative analysis: merging the data with meta-data from brigades #146

Closed jkropko closed 2 years ago

jkropko commented 3 years ago

Overview

We need a have a total dataframe encompassing all data from priority ranking sheet, meet up data sheet, and brigade size & length sheet, so we can correlate responses with other features such as size of the brigade, activity level, and other things we can get from scraping Meetup, Github, or from C4A's data if they are willing to share.

Dependencies

Knowledge of the tidyverse

Action Items

[x] Find as many brigade-level datasets as possible
- [x] Priority ranking sheet
- [x] Meet up data sheet
- [x] Brigade size & length sheets
[x] Merge using dplyr with the interview response data
[x] Create two data set
- [x] 1. With each ranking per row, questions in one column
- [x] 2. with each interview per row, each question per column

Resources/Instructions

tan-zhou commented 3 years ago

I merged brigade size and leadership length with the total data, and calculate the quantiles. Blocker: count the number of values in each quantile

tan-zhou commented 3 years ago

Updated the action items to reflect the change in priority.

tan-zhou commented 3 years ago

add MSA data into the total data set

tan-zhou commented 3 years ago

Add preparedness values once GRM is finished

thadk commented 3 years ago

Hi @tan-zhou , I added the MSA data that I had previously generated for late 2020 brigades to the Tracking spreadsheet as the "MSAData" sheet. Please ignore all the columns data with "lookup_ignore" in the column name: https://docs.google.com/spreadsheets/d/10uZjjrXpZH-y6wZBHZvhKgWNUBj7Xvyh9yoiqL4F_9I/edit#gid=1158009600

tan-zhou commented 3 years ago

Blocker: The section of code that loads data from Google sheets is highly dependent on the formatting of the original sheet. If changes happen in the original sheet (sheet order, new column added), the code couldn't load data as desired.

tan-zhou commented 3 years ago

Blocker: The section of code that loads data from Google sheets is highly dependent on the formatting of the original sheet. If changes happen in the original sheet (sheet order, new column added), the code couldn't load data as desired.

To solve this, refer to data sheet by name instead of order