Juan Luis
06/21/2023, 8:41 AMNok Lam Chan
06/21/2023, 10:58 AMJuan Luis
06/21/2023, 11:15 AMSELECT
REGEXP_EXTRACT(details.python, r"[0-9]+\.[0-9]+") AS python_version,
EXTRACT(WEEK FROM DATE(timestamp)) AS week_number,
COUNT(*) AS num_downloads,
FROM `bigquery-public-data.pypi.file_downloads`
WHERE file.project = 'kedro'
AND DATE(timestamp)
BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
AND CURRENT_DATE()
GROUP BY `week_number`, `python_version`
ORDER BY `num_downloads` DESC
Nok Lam Chan
06/21/2023, 11:28 AMIñigo Hidalgo
06/21/2023, 1:23 PM