I wish we had more data — in average each African country only has 190.3 active GitHub users. Let’s take a look (or see the for context): original article Average number of GitHub stars and users per country in each continent 2016. These are the top countries in Africa by GitHub active users — and the stats from Stack Overflow on BigQuery too: On the left: Active GitHub users in African countries. On the right: Active Stack Overflow users. 2016 My main message: Don’t stop where I stopped. If there’s any area that’s interesting for you — please take these queries and tools, and dig deeper into the data. I’ll be happy to help. Queries Continent stats: #standardSQL
SELECT continent, SUM(stars) stars
  , ROUND(SUM(stars)/COUNT(DISTINCT country_code), 1) avg_stars_per_country
  , ROUND(SUM(users)/COUNT(DISTINCT country_code), 1) users_per_country
FROM (
      SELECT country_code, COUNT(*) stars
        , COUNT(DISTINCT actor.login) AS users
      FROM `githubarchive.year.2016` a
      JOIN `ghtorrent-bq.ght_2017_01_19.users` b  
      ON a.actor.login=b.login
      WHERE country_code IS NOT null 
      AND a.type='WatchEvent'
      GROUP BY 1
      HAVING stars>5
) a
JOIN `gdelt-bq.extra.countryinfo` c
ON a.country_code=LOWER(c.iso)
GROUP BY 1
ORDER BY stars DESC African countries stats: #standardSQL
SELECT country, users, stars, ROUND(stars/users, 1) stars_per_user
FROM (
      SELECT country_code, COUNT(*) stars
        , COUNT(DISTINCT actor.login) AS users
      FROM `githubarchive.year.2016` a
      JOIN `ghtorrent-bq.ght_2017_01_19.users` b  
      ON a.actor.login=b.login
      WHERE country_code IS NOT null 
      AND a.type='WatchEvent'
      GROUP BY 1
      HAVING stars>5
) a
JOIN `gdelt-bq.extra.countryinfo` c
ON a.country_code=LOWER(c.iso)
WHERE continent='AF'
ORDER BY users DESC African countries by Stack Overflow users SELECT country,SUM(users) stackoverflow_users
FROM (
  SELECT location, COUNT(*) users
  FROM `bigquery-public-data.stackoverflow.users` a
  WHERE EXTRACT(YEAR FROM last_access_date)>=2016
  GROUP BY 1
) a
CROSS JOIN (SELECT * FROM `gdelt-bq.extra.countryinfo` WHERE continent='AF') b
WHERE ENDS_WITH(LOWER(a.location), LOWER(b.country))
GROUP BY 1
ORDER BY 2 DESC The main article: The top GitHub projects per country See also: What countries have more open source developers per capita than the US? : In the GitHub queries we can only see the country of a GitHub user if GHTorrent has been able to parse it from each user’s profile. Check out yours on . Note https://github.com/settings/profile

The digital divide: Software developers in Africa through GitHub and Stack Overflow stats

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Some coders like it hot — but most prefer colder climates

10 Lessons I Learned as a First-time Tech Product Founder

10 Best African Language Datasets for Data Science Projects

3 technology lessons from Africa everyone should learn

The Noonification: Are Feature Branches the Ultimate Way to Go? (5/20/2023)

6 Lessons Learned Fundraising for Our Startup in Africa

Some coders like it hot — but most prefer colder climates

10 Lessons I Learned as a First-time Tech Product Founder

10 Best African Language Datasets for Data Science Projects

3 technology lessons from Africa everyone should learn

The Noonification: Are Feature Branches the Ultimate Way to Go? (5/20/2023)

6 Lessons Learned Fundraising for Our Startup in Africa

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps