Hacker News on BigQuery: Now with daily updates — So what are the top domains?
Author’s note: I left Google in 2020, hence these posts haven’t been updated to the latest features. But I’m still having fun with Hacker News’ data — this time with Snowflake. Thanks to the BigQuery Public Datasets Program, we now update Hacker News in BigQuery daily. Nothing better than having fresh data to analyze every day. To celebrate the occasion, I want to look at the top domains that Hack
The top GitHub projects per country
Step 1: The most popular GitHub project per country — naive countThe first pass results are somehow monotone, and not surprising: FreeCodeCamp was the most starred GitHub project by far in 2016: The most starred project per country on GitHub during 2016 — naive count.Step 2: What about the 2nd most popular project for each country? The 2nd most starred project per country on GitHub during 2016 — n
400,000 GitHub repositories, 1 billion files, 14 terabytes of code: Spaces or Tabs?
The rules:Data source: GitHub files stored in BigQuery.Stars matter: We’ll only consider the top 400,000 repositories — by number of stars they got on GitHub during the period Jan-May 2016.No small files: Files need to have at least 10 lines that start with a space or a tab.No duplicates: Duplicate files only have one vote, regardless of how many repos they live in.One vote per file: Some files us
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
処理を実行中です
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
