Maniphest T306624

Population output rank metrics
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	KCVelaga_WMF
	Apr 21 2022, 2:04 PM

Tags

Referenced Files

None

Subscribers

Description

SQL / Python code to transform input data in to Output Rank Metrics

dependent on T306622

Input Metrics	Output Rank Metrics
Population (in thousands)	Population Presence and Growth
wikipedia editors Population Growth Rate	WP Editor-Population Penetration
Average Monthly Global Editors (Calandar Year) (SUM of ALL PROJECTS & LANGUAGES)	Percent of Global Active Editors
Average Monthly Global Editors - Active or Very Active Editors (Calandar Year) (SUM of ALL PROJECTS & LANGUAGES)	Percent of Global Editors
Overall Engagement (Percentile), Total Population Presence*Growth Percentile	Rank in Population Underrepresentaion

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Open		None	T305468 Deploy the GDI Equity Landscape Dashboard
		Open		None	T305475 Milestone: Ingest and Transform Input Data
		Resolved		• ntsako	T306624 Population output rank metrics

Event Timeline

KCVelaga_WMF created this task.Apr 21 2022, 2:04 PM

KCVelaga_WMF edited parent tasks, added: T305475: Milestone: Ingest and Transform Input Data; removed: T306622: Overall Engagement output rank metric.

KCVelaga_WMF updated the task description. (Show Details)Apr 21 2022, 2:26 PM

• EChetty moved this task from Incoming (new tickets) to DaaS Work on the Data-Engineering board.Apr 24 2022, 7:00 AM

• ntsako moved this task from Backlog to In Development on the Equity-Landscape board.May 27 2022, 2:43 PM

• ntsako moved this task from In Development to Backlog on the Equity-Landscape board.

KCVelaga_WMF moved this task from Backlog to Up Next on the Equity-Landscape board.Jun 17 2022, 1:14 PM

KCVelaga_WMF moved this task from Up Next to In Development on the Equity-Landscape board.Jun 20 2022, 4:14 PM

KCVelaga_WMF added a comment.Jun 20 2022, 4:25 PM

This comment was removed by KCVelaga_WMF.

KCVelaga_WMF moved this task from In Development to In Code Review on the Equity-Landscape board.Jul 5 2022, 2:07 PM

KCVelaga_WMF closed this task as Resolved.Jul 21 2022, 9:22 AM

re-opening for QA review

KCVelaga_WMF renamed this task from Population Metrics Transformation to Population output rank metrics.Nov 14 2022, 10:32 AM

KCVelaga_WMF moved this task from In Code Review to In QA Review on the Equity-Landscape board.

Looking good for labels and the transformations with the exception of two adjustments for column labels in the outputs:

FROM:   	population_presence	        TO:	population
FROM:   	population_underrepresentation_rank	        TO:	population_underrepresentation

@KCVelaga_WMF - With the caveat of the column name changes, signing off on the QA for the data

KCVelaga_WMF reassigned this task from KCVelaga_WMF to • ntsako.Feb 8 2023, 3:36 PM

• ntsako moved this task from In QA Review to In Code Review on the Equity-Landscape board.Feb 28 2023, 4:02 PM

• ntsako moved this task from In Code Review to Pending Deploy on the Equity-Landscape board.Mar 8 2023, 3:46 PM

• ntsako moved this task from Pending Deploy to In QA Review on the Equity-Landscape board.May 24 2023, 2:43 PM

• ntsako moved this task from In QA Review to Pending Deploy on the Equity-Landscape board.May 29 2023, 1:19 PM

• ntsako removed a project: Data-Engineering.Jun 21 2023, 2:12 PM

Done

• ntsako closed this task as Resolved.Jul 18 2023, 4:51 PM