Track development velocity
Ruby Shell HTML PLpgSQL
Switch branches/tags
Nothing to show
Clone or download
lukaszgryglicki Updated LF projects data with CNCF projects specific run
Signed-off-by: Lukasz Gryglicki <>
Latest commit 01bc5d0 Aug 9, 2018
Failed to load latest commit information.
BigQuery FreeBSD BigQ Aug 7, 2018
agl AGL case, authors and commits for all time and last year Oct 19, 2017
charts charts screenshots Aug 8, 2018
cloudfoundry CF analysis Jun 12, 2018
data Updated LF projects data with CNCF projects specific run Aug 9, 2018
docs Updated LF projects data with CNCF projects specific run Aug 9, 2018
map Version K8s vs Non-K8s Aug 8, 2018
motion luakszgryglicki-after-regenerated-motion-charts May 18, 2017
openstack Added OpenStack data using DevStats instance Aug 7, 2018
projects Updated LF projects data with CNCF projects specific run Aug 9, 2018
reports Updated LF projects data with CNCF projects specific run Aug 9, 2018
res updated LF chart readme, run data for chart on 2017 Jan 3, 2018
shells Generated projects ranks reports Aug 7, 2018
.gitignore Igtnore log files Jun 12, 2018
Gemfile lukaszgryglicki-support-regexp-in-projects-ranks-report May 29, 2017
Gemfile.lock lukaszgryglicki-support-regexp-in-projects-ranks-report May 29, 2017
LICENSE Initial commit Apr 26, 2017 readme work Jan 8, 2018
add_external.rb lukaszgryglicki-webkit-chrome-chromium-analysis-wip May 25, 2017
add_linux.rb lukaszgryglicki-finished-linux-case Jun 1, 2017
analysis.rb New CNCF projects config Jun 11, 2018
chart_creator.rb added bubble count limit handling Jan 10, 2018
comment.rb lukaszgryglicki-splitted-cf-and-updated-comments May 29, 2017
commits_analysis.rb lukaszgryglicki-updated-chromium-case May 31, 2017
count_issues.rb lukaszgryglicki-1st-attempt-finished-top-30-2016-06-01-2017-06-01 Jun 2, 2017
database.dump lukaszgryglicki-update-file-list May 12, 2017
datelc.csv lukaszgryglicki-update-file-list May 12, 2017 generating various projects stats text files Jun 12, 2018
generate_motion.rb lukaszgryglicki-webkit-chrome-chromium-analysis-wip May 25, 2017
hintgen.rb lukaszgryglicki-webkit-chrome-chromium-analysis-wip May 25, 2017
merger.rb lukaszgryglicki-updated-cf-case-skipped-more-bots May 31, 2017
orgs.txt various projects fixes and add new CNCF projects to project ranks config Jun 12, 2018
report_projects_ranks.rb generating various projects stats text files Jun 12, 2018
report_top_projects.rb Added tool to calculate top projects by various metrics Mar 2, 2018 Added tool to calculate top projects by various metrics Mar 2, 2018
repos.txt various projects fixes and add new CNCF projects to project ranks config Jun 12, 2018
update_projects.rb lukaszgryglicki-updated-merge-tools-to-skip-updating-to-lower-values May 30, 2017


Track development velocity

This tool set generates data for a Bubble/Motion Google Sheet Chart.
The main script is analysis.rb. The input is a csv file created from BigQuery results.

This tool is being used for periodical chars update as described in the following documents:
Guide to the CNCF projects chart creation
Guide to the LinuxFoundation projects chart creation
Guide to the Top-30 projects chart creation
Links to various charts and videos generated using this project

Example use:

ruby analysis.rb data/data_yyyymm.csv projects/projects_yyyymm.csv map/hints.csv map/urls.csv map/defmaps.csv skip.csv ranges.csv

Depending on data, the script will stop execution and present a command line.

[1] pry(main)>

To continue, type 'quit' and hit enter/return.

Arguments list:

  • data file, points to the results of running an sql statement designed for Google BigQuery. The query generates a standardized (in terms of velocity) header. The .sql files are stored in BigQuery/ folder
  • output file, typically a new file in the projects/ folder
  • a "hints" file with additional mapping: repo name -> project. (N repos --> 1 Project), so a given project name may be listed be in many lines
  • a "urls" file which defines URLs for the listed projects (a separate file is used because otherwise, in hints file we would have to duplicate data for each project ) (1 Project --> 1 URL)
  • a "default" map file which defines non standard names for projects generated automatically via grouping by org (like aspnet --> or to group multiple orgs and/or repos into a single project. It is the last step of project name mapping This tool outputs a data file into the 'projects/' directory
  • a "skip" file that lists repos and/or orgs and/or projects to be skipped
  • a "ranges" file that contains ranges of repos properties which makes repo included in calculations

File formats

input.csv data/data_yyyymm.csv from BigQuery, like the following:


output.csv to be imported via Google Sheet (File -> Import) and then chart created from this data. It looks like this:


hints.csv a csv file with hints for repo --> project mapping, it has this format:

Microsoft/TypeScript,Microsoft TypeScript

urls.csv a csv file with project --> url mapping with the following format:


defmaps.csv a csv file with proper names for projects generated as default groupping within org:


The special flag '=SKIP' for a project means that this org should NOT be groupped

skip.csv a csv file that contains lists of repos and/or orgs and/or projects to be skipped in the analysis:

"enkidevs,csu2017sp314,thoughtbot,illacceptanything,RubySteps,RainbowEngineer",Microsoft/techcasestudies,"Apache (other),OpenStack (other)"

ranges.csv a csv file that contains ranges of repos properties which makes repo included in calculations. It can constrain any of "commits, prs, comments, issues, authors" to be within range n1 .. n2 (if n1 or n2 < 0 then this value is skipped, so -1..-1 means unlimited There can be also be exception repos/orgs that do not use those ranges:


The generated output file contains all the input data (so it can be 600 rows for 1000 input rows for example). You should manually review generated output and choose how many rocords you need.

hintgen.rb is a tool that takes data already processed for various created charts and creates distinct projects hint file from it. Example usage:

hintgen.rb data.csv map/hints.csv Use multiple times putting a different data file (1st parameter) and generate final hints.csv.

Input and Output

Data files existing in the repository:

  • data/data_YYYYMM.csv --> data for given YYYYMM from BigQuery.
  • projects/projects_YYYYMM.csv --> data generated by analysis.rb based on data_YYYYMM.csv with map/: hints.csv, urls.csv, defmaps.csv, skip.csv, ranges.csv parameters

Motion charts

generate_motion.rb a tool that merges data from multiple files into one to be used for motion chart. Usage:

ruby generate_motion.rb projects/files.csv motion/motion.csv motion/motion_sums.csv [projects/summaries.csv]

File files.csv contains a list of data files to be merged. It has the following format:


This tool generates 2 output files:

  • 1st is a motion data from each file with a given label
  • 2nd is cumulative sum of data, so 1st label contains data from 1st label, 2nd contains 1st+2nd, 3rd=1st+2nd+3rd ... last = sum of all data. Labels are summed-up in alphabetical order. When input data is divided by months, "YYYYMM" or "YYYY-MM" format must be used to receive correct results. "MM/YYYY" will, for example, swap "2/2016" and "1/2017".
    Output formats of 1st and 2nd files are identical.
    The first column is a data file generated by analysis.rb. The following column is a label that will be used as "time" for google sheets motion chart.

Output format:

VS Code,,2016-01,7526,5278,381,804,1063,112,155621,104386,9501,17650,24084,198
VS Code,,2016-02,17139,11638,986,1899,2616,133,155621,104386,9501,17650,24084,198
VS Code,,2017-04,155621,104386,9501,17650,24084,198,155621,104386,9501,17650,24084,198

Each row contains its label data (separate or cumulative) whereas columns with starting with max_ contain cumulative data for all labels. This is to make the data ready for google sheet motion chart without complex cell indexing.

The final (optional) file summaries.csv is used to read the number of authors. This is because the number of authors is computed differently. Without the summaries file (or if a given project is not in the summaries file), we have a number of distinct authors in each period. Summary value is a sum of all periods max. This is obviously not a real count of all distinct authors in all periods. Number of authors would be computed if another file is supplied, one which contains summary data for a longer period that is equal to sum of all periods.

Project ranks

Tool to create ranks per project (for all project's numeric properties) report_projects_ranks.rb & shells/ Shell script projects from projects/unlimited_both.csv and uses: reports/cncf_projects_config.csv file to get a list of projects that needs to be included in the rank statistics. File format is:


It outputs a rank statistics file reports/cncf_projects_ranks.txt

More info

Guide to non-GitHub project processing

Other useful notes