Check if angular have more issues than kubernetes (angular and kubernetes repos combined, from all time, statistics got manually from each separate github repo - manually)

README.txt

For each repo in angular and kubernetes (from those that were in Top 50) go to the github site manually and:
Click Issues and get opened and closed
Click Pull Requests and get opened and closed
Click code and get: commits,authors,branches,releases,watch,star,fork
Repeat for all kubernetes and angular repos.
Save this data manually in `all_time.csv`
Created tool `manual.rb` in ruby which:
-Sums data per org (kubernetes and angular)
-Groping by org, summary row have "repo1+repo2+...+repoN" name
-Sum all values except "authors" (can be the same in repos), for authors use max from all repos.
-Create issues and PRs entry (issues = open issues + closed issues, PRs = open PRs + closed PRs)
-Create output array containing separate repos and summary repos.
-Sort it by # of issues desc. Save into `all_time_combined.csv`

See:
angualar (sum of all repos): 29077 issues.
kubernetes (sum of all repos): 21424 issues.

So angular have more issues than kubernetes (for all time data).

Files: all_time.csv - manually created input, manual.rb (tool to generate combines summary), all_time_combined.csv - output of ruby tool

all_time.csv

all_time_combined.csv

manual.rb

require 'csv'
require 'pry'

max_cols = ['authors']
sort_by_col = 'issues'

orgs = {}
CSV.foreach('./all_time.csv', headers: true) do |row|
  h = row.to_h
  org = h['org']
  orgs[org] = {items: [], sum: {}} unless orgs.key? org
  orgs[org][:items] << h
  h.each do |k, v|
    v = v.to_i.to_s == v ? v.to_i : v
    zero_v = v.class == String ? '' : 0
    orgs[org][:sum][k] = zero_v unless orgs[org][:sum].key? k
    if max_cols.include? k
      orgs[org][:sum][k] = [orgs[org][:sum][k], v].max
    else
      orgs[org][:sum][k] += v.class == String ? '+'+v : v
    end
    orgs[org][:items].last[k] = v unless v.class == String
  end
end

orgs.each do |_, data|
  data[:sum]['issues'] = data[:sum]['issues open'] + data[:sum]['issues closed']
  data[:sum]['PRs']    = data[:sum]['PRs open'] + data[:sum]['PRs closed']
  data[:items].each do |item|
    item['issues'] = item['issues open'] + item['issues closed']
    item['PRs']    = item['PRs open'] + item['PRs closed']
  end
end

orgs.each do |_, data|
  data[:sum].each do |col, val|
    next unless val.class == String
    data[:sum][col] = val[1..-1].split('+').uniq.join('+')
  end
end

ary = []
orgs.each do |_, data|
  ary << data[:sum]
  data[:items].each { |item| ary << item }
end

ary = ary.sort_by { |row| -row[sort_by_col] }

binding.pry

CSV.open("all_time_combined.csv", "w", headers: ary[0].keys) do |csv|
  csv << ary[0].keys
  ary.each do |row|
    csv << row.values
  end
end