did you know... that you can query the PyPI downlo...
# random
j
did you know... that you can query the PyPI download stats in BigQuery? https://packaging.python.org/en/latest/guides/analyzing-pypi-package-downloads/ for example, here I extracted the download counts of Kedro by Python version and week (excuse my SQL skills, I'm a Python person python)
n
Do you still have the query? I would like to check something or maybe I just need OCR to copy the text from the screenshotlolsob
j
hahaha I still have the query, one sec
Copy code
SELECT
  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
👍🏼 1
n
Seems like majority of the users are using 3.8, and a significant portion are still using 3.6👀 ( Python 3.7 is running out of support next week!)
👀 2
i
3.5 :OOO
😂 1