Analyzing Github Data with JupySQL + DuckDB#

JupySQL and DuckDB have many use cases. Here, let’s query the Github REST API to run some analysis using these tools.

%pip install jupysql duckdb duckdb-engine rich --quiet
Hide code cell output 
Note: you may need to restart the kernel to use updated packages.

Pulling from Github API#

First, let’s pull information on repositories relating to ‘Jupyter’ from the Github API. Some operations may require a token, but accessing them is very simple if you have a Github account. More information on authentication can be found here. Our query will pull any repository relating to Jupyter, sorted by most to least stars.

import requests
import json
from pathlib import Path

res = requests.get(
    "https://api.github.com/search/repositories?q=jupyter&sort=stars&order=desc",
)

We then parse the information pulled from the API into a JSON format that we can run analysis on with JupySQL. We also need to save it locally as a .json file. Let’s make it easier by only dumping the ‘items’ array.

parsed = res.json()

_ = Path("jupyterdata.json").write_text(json.dumps(parsed["items"], indent=4))

Querying JSON File#

Let’s get some information on our first result. Load the extension and start a DuckDB in-memory database:

%load_ext sql
%sql duckdb://
Connecting to 'duckdb://'

Looking at our .json file, we have information on thousands of repositories. To start, let’s load information on our results.

%%sql
SELECT *
FROM read_json_auto('jupyterdata.json')
Hide code cell output
Running query in 'duckdb://'
id node_id name full_name private owner html_url description fork url forks_url keys_url collaborators_url teams_url hooks_url issue_events_url events_url assignees_url branches_url tags_url blobs_url git_tags_url git_refs_url trees_url statuses_url languages_url stargazers_url contributors_url subscribers_url subscription_url commits_url git_commits_url comments_url issue_comment_url contents_url compare_url merges_url archive_url downloads_url issues_url pulls_url milestones_url notifications_url labels_url releases_url deployments_url created_at updated_at pushed_at git_url ssh_url clone_url svn_url homepage size stargazers_count watchers_count language has_issues has_projects has_downloads has_wiki has_pages has_discussions forks_count mirror_url archived disabled open_issues_count license allow_forking is_template web_commit_signoff_required topics visibility forks open_issues watchers default_branch score
65388917 MDEwOlJlcG9zaXRvcnk2NTM4ODkxNw== PythonDataScienceHandbook jakevdp/PythonDataScienceHandbook False {'login': 'jakevdp', 'id': 781659, 'node_id': 'MDQ6VXNlcjc4MTY1OQ==', 'avatar_url': 'https://avatars.githubusercontent.com/u/781659?v=4', 'gravatar_id': '', 'url': 'https://api.github.com/users/jakevdp', 'html_url': 'https://github.com/jakevdp', 'followers_url': 'https://api.github.com/users/jakevdp/followers', 'following_url': 'https://api.github.com/users/jakevdp/following{/other_user}', 'gists_url': 'https://api.github.com/users/jakevdp/gists{/gist_id}', 'starred_url': 'https://api.github.com/users/jakevdp/starred{/owner}{/repo}', 'subscriptions_url': 'https://api.github.com/users/jakevdp/subscriptions', 'organizations_url': 'https://api.github.com/users/jakevdp/orgs', 'repos_url': 'https://api.github.com/users/jakevdp/repos', 'events_url': 'https://api.github.com/users/jakevdp/events{/privacy}', 'received_events_url': 'https://api.github.com/users/jakevdp/received_events', 'type': 'User', 'user_view_type': 'public', 'site_admin': False} https://github.com/jakevdp/PythonDataScienceHandbook Python Data Science Handbook: full text in Jupyter Notebooks False https://api.github.com/repos/jakevdp/PythonDataScienceHandbook https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/forks https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/keys{/key_id} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/collaborators{/collaborator} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/teams https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/hooks https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/issues/events{/number} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/events https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/assignees{/user} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/branches{/branch} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/tags https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/git/blobs{/sha} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/git/tags{/sha} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/git/refs{/sha} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/git/trees{/sha} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/statuses/{sha} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/languages https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/stargazers https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/contributors https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/subscribers https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/subscription https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/commits{/sha} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/git/commits{/sha} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/comments{/number} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/issues/comments{/number} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/contents/{+path} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/compare/{base}...{head} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/merges https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/{archive_format}{/ref} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/downloads https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/issues{/number} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/pulls{/number} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/milestones{/number} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/notifications{?since,all,participating} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/labels{/name} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/releases{/id} https://api.github.com/repos/jakevdp/PythonDataScienceHandbook/deployments 2016-08-10 14:24:36 2026-01-04 17:21:03 2024-06-26 19:17:33 git://github.com/jakevdp/PythonDataScienceHandbook.git git@github.com:jakevdp/PythonDataScienceHandbook.git https://github.com/jakevdp/PythonDataScienceHandbook.git https://github.com/jakevdp/PythonDataScienceHandbook http://jakevdp.github.io/PythonDataScienceHandbook 43642 46437 46437 Jupyter Notebook True True True True True False 18655 None False False 228 {'key': 'mit', 'name': 'MIT License', 'spdx_id': 'MIT', 'url': 'https://api.github.com/licenses/mit', 'node_id': 'MDc6TGljZW5zZTEz'} True False False ['jupyter-notebook', 'matplotlib', 'numpy', 'pandas', 'python', 'scikit-learn'] public 18655 228 46437 master 1.0
36804486 MDEwOlJlcG9zaXRvcnkzNjgwNDQ4Ng== tqdm tqdm/tqdm False {'login': 'tqdm', 'id': 12731565, 'node_id': 'MDEyOk9yZ2FuaXphdGlvbjEyNzMxNTY1', 'avatar_url': 'https://avatars.githubusercontent.com/u/12731565?v=4', 'gravatar_id': '', 'url': 'https://api.github.com/users/tqdm', 'html_url': 'https://github.com/tqdm', 'followers_url': 'https://api.github.com/users/tqdm/followers', 'following_url': 'https://api.github.com/users/tqdm/following{/other_user}', 'gists_url': 'https://api.github.com/users/tqdm/gists{/gist_id}', 'starred_url': 'https://api.github.com/users/tqdm/starred{/owner}{/repo}', 'subscriptions_url': 'https://api.github.com/users/tqdm/subscriptions', 'organizations_url': 'https://api.github.com/users/tqdm/orgs', 'repos_url': 'https://api.github.com/users/tqdm/repos', 'events_url': 'https://api.github.com/users/tqdm/events{/privacy}', 'received_events_url': 'https://api.github.com/users/tqdm/received_events', 'type': 'Organization', 'user_view_type': 'public', 'site_admin': False} https://github.com/tqdm/tqdm :zap: A Fast, Extensible Progress Bar for Python and CLI False https://api.github.com/repos/tqdm/tqdm https://api.github.com/repos/tqdm/tqdm/forks https://api.github.com/repos/tqdm/tqdm/keys{/key_id} https://api.github.com/repos/tqdm/tqdm/collaborators{/collaborator} https://api.github.com/repos/tqdm/tqdm/teams https://api.github.com/repos/tqdm/tqdm/hooks https://api.github.com/repos/tqdm/tqdm/issues/events{/number} https://api.github.com/repos/tqdm/tqdm/events https://api.github.com/repos/tqdm/tqdm/assignees{/user} https://api.github.com/repos/tqdm/tqdm/branches{/branch} https://api.github.com/repos/tqdm/tqdm/tags https://api.github.com/repos/tqdm/tqdm/git/blobs{/sha} https://api.github.com/repos/tqdm/tqdm/git/tags{/sha} https://api.github.com/repos/tqdm/tqdm/git/refs{/sha} https://api.github.com/repos/tqdm/tqdm/git/trees{/sha} https://api.github.com/repos/tqdm/tqdm/statuses/{sha} https://api.github.com/repos/tqdm/tqdm/languages https://api.github.com/repos/tqdm/tqdm/stargazers https://api.github.com/repos/tqdm/tqdm/contributors https://api.github.com/repos/tqdm/tqdm/subscribers https://api.github.com/repos/tqdm/tqdm/subscription https://api.github.com/repos/tqdm/tqdm/commits{/sha} https://api.github.com/repos/tqdm/tqdm/git/commits{/sha} https://api.github.com/repos/tqdm/tqdm/comments{/number} https://api.github.com/repos/tqdm/tqdm/issues/comments{/number} https://api.github.com/repos/tqdm/tqdm/contents/{+path} https://api.github.com/repos/tqdm/tqdm/compare/{base}...{head} https://api.github.com/repos/tqdm/tqdm/merges https://api.github.com/repos/tqdm/tqdm/{archive_format}{/ref} https://api.github.com/repos/tqdm/tqdm/downloads https://api.github.com/repos/tqdm/tqdm/issues{/number} https://api.github.com/repos/tqdm/tqdm/pulls{/number} https://api.github.com/repos/tqdm/tqdm/milestones{/number} https://api.github.com/repos/tqdm/tqdm/notifications{?since,all,participating} https://api.github.com/repos/tqdm/tqdm/labels{/name} https://api.github.com/repos/tqdm/tqdm/releases{/id} https://api.github.com/repos/tqdm/tqdm/deployments 2015-06-03 13:13:14 2026-01-04 15:32:09 2025-05-22 12:10:29 git://github.com/tqdm/tqdm.git git@github.com:tqdm/tqdm.git https://github.com/tqdm/tqdm.git https://github.com/tqdm/tqdm https://tqdm.github.io 6020 30824 30824 Python True True True True True True 1418 None False False 581 {'key': 'other', 'name': 'Other', 'spdx_id': 'NOASSERTION', 'url': None, 'node_id': 'MDc6TGljZW5zZTA='} True False False ['cli', 'closember', 'console', 'discord', 'gui', 'jupyter', 'keras', 'meter', 'pandas', 'parallel', 'progress', 'progress-bar', 'progressbar', 'progressmeter', 'python', 'rate', 'telegram', 'terminal', 'time', 'utilities'] public 1418 581 30824 master 1.0
164554832 MDEwOlJlcG9zaXRvcnkxNjQ1NTQ4MzI= handson-ml2 ageron/handson-ml2 False {'login': 'ageron', 'id': 76661, 'node_id': 'MDQ6VXNlcjc2NjYx', 'avatar_url': 'https://avatars.githubusercontent.com/u/76661?v=4', 'gravatar_id': '', 'url': 'https://api.github.com/users/ageron', 'html_url': 'https://github.com/ageron', 'followers_url': 'https://api.github.com/users/ageron/followers', 'following_url': 'https://api.github.com/users/ageron/following{/other_user}', 'gists_url': 'https://api.github.com/users/ageron/gists{/gist_id}', 'starred_url': 'https://api.github.com/users/ageron/starred{/owner}{/repo}', 'subscriptions_url': 'https://api.github.com/users/ageron/subscriptions', 'organizations_url': 'https://api.github.com/users/ageron/orgs', 'repos_url': 'https://api.github.com/users/ageron/repos', 'events_url': 'https://api.github.com/users/ageron/events{/privacy}', 'received_events_url': 'https://api.github.com/users/ageron/received_events', 'type': 'User', 'user_view_type': 'public', 'site_admin': False} https://github.com/ageron/handson-ml2 A series of Jupyter notebooks that walk you through the fundamentals of Machine Learning and Deep Learning in Python using Scikit-Learn, Keras and TensorFlow 2. False https://api.github.com/repos/ageron/handson-ml2 https://api.github.com/repos/ageron/handson-ml2/forks https://api.github.com/repos/ageron/handson-ml2/keys{/key_id} https://api.github.com/repos/ageron/handson-ml2/collaborators{/collaborator} https://api.github.com/repos/ageron/handson-ml2/teams https://api.github.com/repos/ageron/handson-ml2/hooks https://api.github.com/repos/ageron/handson-ml2/issues/events{/number} https://api.github.com/repos/ageron/handson-ml2/events https://api.github.com/repos/ageron/handson-ml2/assignees{/user} https://api.github.com/repos/ageron/handson-ml2/branches{/branch} https://api.github.com/repos/ageron/handson-ml2/tags https://api.github.com/repos/ageron/handson-ml2/git/blobs{/sha} https://api.github.com/repos/ageron/handson-ml2/git/tags{/sha} https://api.github.com/repos/ageron/handson-ml2/git/refs{/sha} https://api.github.com/repos/ageron/handson-ml2/git/trees{/sha} https://api.github.com/repos/ageron/handson-ml2/statuses/{sha} https://api.github.com/repos/ageron/handson-ml2/languages https://api.github.com/repos/ageron/handson-ml2/stargazers https://api.github.com/repos/ageron/handson-ml2/contributors https://api.github.com/repos/ageron/handson-ml2/subscribers https://api.github.com/repos/ageron/handson-ml2/subscription https://api.github.com/repos/ageron/handson-ml2/commits{/sha} https://api.github.com/repos/ageron/handson-ml2/git/commits{/sha} https://api.github.com/repos/ageron/handson-ml2/comments{/number} https://api.github.com/repos/ageron/handson-ml2/issues/comments{/number} https://api.github.com/repos/ageron/handson-ml2/contents/{+path} https://api.github.com/repos/ageron/handson-ml2/compare/{base}...{head} https://api.github.com/repos/ageron/handson-ml2/merges https://api.github.com/repos/ageron/handson-ml2/{archive_format}{/ref} https://api.github.com/repos/ageron/handson-ml2/downloads https://api.github.com/repos/ageron/handson-ml2/issues{/number} https://api.github.com/repos/ageron/handson-ml2/pulls{/number} https://api.github.com/repos/ageron/handson-ml2/milestones{/number} https://api.github.com/repos/ageron/handson-ml2/notifications{?since,all,participating} https://api.github.com/repos/ageron/handson-ml2/labels{/name} https://api.github.com/repos/ageron/handson-ml2/releases{/id} https://api.github.com/repos/ageron/handson-ml2/deployments 2019-01-08 03:49:07 2026-01-04 15:52:13 2024-06-13 08:10:24 git://github.com/ageron/handson-ml2.git git@github.com:ageron/handson-ml2.git https://github.com/ageron/handson-ml2.git https://github.com/ageron/handson-ml2 None 154110 29754 29754 Jupyter Notebook True True True True False False 13242 None False False 229 {'key': 'apache-2.0', 'name': 'Apache License 2.0', 'spdx_id': 'Apache-2.0', 'url': 'https://api.github.com/licenses/apache-2.0', 'node_id': 'MDc6TGljZW5zZTI='} True False False [] public 13242 229 29754 master 1.0
33702544 MDEwOlJlcG9zaXRvcnkzMzcwMjU0NA== dash plotly/dash False {'login': 'plotly', 'id': 5997976, 'node_id': 'MDEyOk9yZ2FuaXphdGlvbjU5OTc5NzY=', 'avatar_url': 'https://avatars.githubusercontent.com/u/5997976?v=4', 'gravatar_id': '', 'url': 'https://api.github.com/users/plotly', 'html_url': 'https://github.com/plotly', 'followers_url': 'https://api.github.com/users/plotly/followers', 'following_url': 'https://api.github.com/users/plotly/following{/other_user}', 'gists_url': 'https://api.github.com/users/plotly/gists{/gist_id}', 'starred_url': 'https://api.github.com/users/plotly/starred{/owner}{/repo}', 'subscriptions_url': 'https://api.github.com/users/plotly/subscriptions', 'organizations_url': 'https://api.github.com/users/plotly/orgs', 'repos_url': 'https://api.github.com/users/plotly/repos', 'events_url': 'https://api.github.com/users/plotly/events{/privacy}', 'received_events_url': 'https://api.github.com/users/plotly/received_events', 'type': 'Organization', 'user_view_type': 'public', 'site_admin': False} https://github.com/plotly/dash Data Apps & Dashboards for Python. No JavaScript Required. False https://api.github.com/repos/plotly/dash https://api.github.com/repos/plotly/dash/forks https://api.github.com/repos/plotly/dash/keys{/key_id} https://api.github.com/repos/plotly/dash/collaborators{/collaborator} https://api.github.com/repos/plotly/dash/teams https://api.github.com/repos/plotly/dash/hooks https://api.github.com/repos/plotly/dash/issues/events{/number} https://api.github.com/repos/plotly/dash/events https://api.github.com/repos/plotly/dash/assignees{/user} https://api.github.com/repos/plotly/dash/branches{/branch} https://api.github.com/repos/plotly/dash/tags https://api.github.com/repos/plotly/dash/git/blobs{/sha} https://api.github.com/repos/plotly/dash/git/tags{/sha} https://api.github.com/repos/plotly/dash/git/refs{/sha} https://api.github.com/repos/plotly/dash/git/trees{/sha} https://api.github.com/repos/plotly/dash/statuses/{sha} https://api.github.com/repos/plotly/dash/languages https://api.github.com/repos/plotly/dash/stargazers https://api.github.com/repos/plotly/dash/contributors https://api.github.com/repos/plotly/dash/subscribers https://api.github.com/repos/plotly/dash/subscription https://api.github.com/repos/plotly/dash/commits{/sha} https://api.github.com/repos/plotly/dash/git/commits{/sha} https://api.github.com/repos/plotly/dash/comments{/number} https://api.github.com/repos/plotly/dash/issues/comments{/number} https://api.github.com/repos/plotly/dash/contents/{+path} https://api.github.com/repos/plotly/dash/compare/{base}...{head} https://api.github.com/repos/plotly/dash/merges https://api.github.com/repos/plotly/dash/{archive_format}{/ref} https://api.github.com/repos/plotly/dash/downloads https://api.github.com/repos/plotly/dash/issues{/number} https://api.github.com/repos/plotly/dash/pulls{/number} https://api.github.com/repos/plotly/dash/milestones{/number} https://api.github.com/repos/plotly/dash/notifications{?since,all,participating} https://api.github.com/repos/plotly/dash/labels{/name} https://api.github.com/repos/plotly/dash/releases{/id} https://api.github.com/repos/plotly/dash/deployments 2015-04-10 01:53:08 2026-01-04 15:29:31 2026-01-01 21:48:35 git://github.com/plotly/dash.git git@github.com:plotly/dash.git https://github.com/plotly/dash.git https://github.com/plotly/dash https://plotly.com/dash 196190 24375 24375 Python True True True False False False 2245 None False False 557 {'key': 'mit', 'name': 'MIT License', 'spdx_id': 'MIT', 'url': 'https://api.github.com/licenses/mit', 'node_id': 'MDc6TGljZW5zZTEz'} True False False ['bioinformatics', 'charting', 'dash', 'data-science', 'data-visualization', 'finance', 'flask', 'gui-framework', 'jupyter', 'modeling', 'plotly', 'plotly-dash', 'productivity', 'python', 'react', 'rstats', 'technical-computing', 'web-app'] public 2245 557 24375 dev 1.0
243838973 MDEwOlJlcG9zaXRvcnkyNDM4Mzg5NzM= fastbook fastai/fastbook False {'login': 'fastai', 'id': 20547620, 'node_id': 'MDEyOk9yZ2FuaXphdGlvbjIwNTQ3NjIw', 'avatar_url': 'https://avatars.githubusercontent.com/u/20547620?v=4', 'gravatar_id': '', 'url': 'https://api.github.com/users/fastai', 'html_url': 'https://github.com/fastai', 'followers_url': 'https://api.github.com/users/fastai/followers', 'following_url': 'https://api.github.com/users/fastai/following{/other_user}', 'gists_url': 'https://api.github.com/users/fastai/gists{/gist_id}', 'starred_url': 'https://api.github.com/users/fastai/starred{/owner}{/repo}', 'subscriptions_url': 'https://api.github.com/users/fastai/subscriptions', 'organizations_url': 'https://api.github.com/users/fastai/orgs', 'repos_url': 'https://api.github.com/users/fastai/repos', 'events_url': 'https://api.github.com/users/fastai/events{/privacy}', 'received_events_url': 'https://api.github.com/users/fastai/received_events', 'type': 'Organization', 'user_view_type': 'public', 'site_admin': False} https://github.com/fastai/fastbook The fastai book, published as Jupyter Notebooks False https://api.github.com/repos/fastai/fastbook https://api.github.com/repos/fastai/fastbook/forks https://api.github.com/repos/fastai/fastbook/keys{/key_id} https://api.github.com/repos/fastai/fastbook/collaborators{/collaborator} https://api.github.com/repos/fastai/fastbook/teams https://api.github.com/repos/fastai/fastbook/hooks https://api.github.com/repos/fastai/fastbook/issues/events{/number} https://api.github.com/repos/fastai/fastbook/events https://api.github.com/repos/fastai/fastbook/assignees{/user} https://api.github.com/repos/fastai/fastbook/branches{/branch} https://api.github.com/repos/fastai/fastbook/tags https://api.github.com/repos/fastai/fastbook/git/blobs{/sha} https://api.github.com/repos/fastai/fastbook/git/tags{/sha} https://api.github.com/repos/fastai/fastbook/git/refs{/sha} https://api.github.com/repos/fastai/fastbook/git/trees{/sha} https://api.github.com/repos/fastai/fastbook/statuses/{sha} https://api.github.com/repos/fastai/fastbook/languages https://api.github.com/repos/fastai/fastbook/stargazers https://api.github.com/repos/fastai/fastbook/contributors https://api.github.com/repos/fastai/fastbook/subscribers https://api.github.com/repos/fastai/fastbook/subscription https://api.github.com/repos/fastai/fastbook/commits{/sha} https://api.github.com/repos/fastai/fastbook/git/commits{/sha} https://api.github.com/repos/fastai/fastbook/comments{/number} https://api.github.com/repos/fastai/fastbook/issues/comments{/number} https://api.github.com/repos/fastai/fastbook/contents/{+path} https://api.github.com/repos/fastai/fastbook/compare/{base}...{head} https://api.github.com/repos/fastai/fastbook/merges https://api.github.com/repos/fastai/fastbook/{archive_format}{/ref} https://api.github.com/repos/fastai/fastbook/downloads https://api.github.com/repos/fastai/fastbook/issues{/number} https://api.github.com/repos/fastai/fastbook/pulls{/number} https://api.github.com/repos/fastai/fastbook/milestones{/number} https://api.github.com/repos/fastai/fastbook/notifications{?since,all,participating} https://api.github.com/repos/fastai/fastbook/labels{/name} https://api.github.com/repos/fastai/fastbook/releases{/id} https://api.github.com/repos/fastai/fastbook/deployments 2020-02-28 19:26:47 2026-01-04 13:03:13 2024-08-16 14:38:24 git://github.com/fastai/fastbook.git git@github.com:fastai/fastbook.git https://github.com/fastai/fastbook.git https://github.com/fastai/fastbook 86034 24220 24220 Jupyter Notebook True True True True False False 9339 None False False 179 {'key': 'other', 'name': 'Other', 'spdx_id': 'NOASSERTION', 'url': None, 'node_id': 'MDc6TGljZW5zZTA='} True False False ['book', 'data-science', 'deep-learning', 'fastai', 'machine-learning', 'notebooks', 'python'] public 9339 179 24220 master 1.0
155662306 MDEwOlJlcG9zaXRvcnkxNTU2NjIzMDY= homemade-machine-learning trekhleb/homemade-machine-learning False {'login': 'trekhleb', 'id': 3000285, 'node_id': 'MDQ6VXNlcjMwMDAyODU=', 'avatar_url': 'https://avatars.githubusercontent.com/u/3000285?v=4', 'gravatar_id': '', 'url': 'https://api.github.com/users/trekhleb', 'html_url': 'https://github.com/trekhleb', 'followers_url': 'https://api.github.com/users/trekhleb/followers', 'following_url': 'https://api.github.com/users/trekhleb/following{/other_user}', 'gists_url': 'https://api.github.com/users/trekhleb/gists{/gist_id}', 'starred_url': 'https://api.github.com/users/trekhleb/starred{/owner}{/repo}', 'subscriptions_url': 'https://api.github.com/users/trekhleb/subscriptions', 'organizations_url': 'https://api.github.com/users/trekhleb/orgs', 'repos_url': 'https://api.github.com/users/trekhleb/repos', 'events_url': 'https://api.github.com/users/trekhleb/events{/privacy}', 'received_events_url': 'https://api.github.com/users/trekhleb/received_events', 'type': 'User', 'user_view_type': 'public', 'site_admin': False} https://github.com/trekhleb/homemade-machine-learning 🤖 Python examples of popular machine learning algorithms with interactive Jupyter demos and math being explained False https://api.github.com/repos/trekhleb/homemade-machine-learning https://api.github.com/repos/trekhleb/homemade-machine-learning/forks https://api.github.com/repos/trekhleb/homemade-machine-learning/keys{/key_id} https://api.github.com/repos/trekhleb/homemade-machine-learning/collaborators{/collaborator} https://api.github.com/repos/trekhleb/homemade-machine-learning/teams https://api.github.com/repos/trekhleb/homemade-machine-learning/hooks https://api.github.com/repos/trekhleb/homemade-machine-learning/issues/events{/number} https://api.github.com/repos/trekhleb/homemade-machine-learning/events https://api.github.com/repos/trekhleb/homemade-machine-learning/assignees{/user} https://api.github.com/repos/trekhleb/homemade-machine-learning/branches{/branch} https://api.github.com/repos/trekhleb/homemade-machine-learning/tags https://api.github.com/repos/trekhleb/homemade-machine-learning/git/blobs{/sha} https://api.github.com/repos/trekhleb/homemade-machine-learning/git/tags{/sha} https://api.github.com/repos/trekhleb/homemade-machine-learning/git/refs{/sha} https://api.github.com/repos/trekhleb/homemade-machine-learning/git/trees{/sha} https://api.github.com/repos/trekhleb/homemade-machine-learning/statuses/{sha} https://api.github.com/repos/trekhleb/homemade-machine-learning/languages https://api.github.com/repos/trekhleb/homemade-machine-learning/stargazers https://api.github.com/repos/trekhleb/homemade-machine-learning/contributors https://api.github.com/repos/trekhleb/homemade-machine-learning/subscribers https://api.github.com/repos/trekhleb/homemade-machine-learning/subscription https://api.github.com/repos/trekhleb/homemade-machine-learning/commits{/sha} https://api.github.com/repos/trekhleb/homemade-machine-learning/git/commits{/sha} https://api.github.com/repos/trekhleb/homemade-machine-learning/comments{/number} https://api.github.com/repos/trekhleb/homemade-machine-learning/issues/comments{/number} https://api.github.com/repos/trekhleb/homemade-machine-learning/contents/{+path} https://api.github.com/repos/trekhleb/homemade-machine-learning/compare/{base}...{head} https://api.github.com/repos/trekhleb/homemade-machine-learning/merges https://api.github.com/repos/trekhleb/homemade-machine-learning/{archive_format}{/ref} https://api.github.com/repos/trekhleb/homemade-machine-learning/downloads https://api.github.com/repos/trekhleb/homemade-machine-learning/issues{/number} https://api.github.com/repos/trekhleb/homemade-machine-learning/pulls{/number} https://api.github.com/repos/trekhleb/homemade-machine-learning/milestones{/number} https://api.github.com/repos/trekhleb/homemade-machine-learning/notifications{?since,all,participating} https://api.github.com/repos/trekhleb/homemade-machine-learning/labels{/name} https://api.github.com/repos/trekhleb/homemade-machine-learning/releases{/id} https://api.github.com/repos/trekhleb/homemade-machine-learning/deployments 2018-11-01 04:34:19 2026-01-04 02:48:07 2025-11-23 04:22:46 git://github.com/trekhleb/homemade-machine-learning.git git@github.com:trekhleb/homemade-machine-learning.git https://github.com/trekhleb/homemade-machine-learning.git https://github.com/trekhleb/homemade-machine-learning 14467 23825 23825 Jupyter Notebook True False True False False False 4119 None False False 27 {'key': 'mit', 'name': 'MIT License', 'spdx_id': 'MIT', 'url': 'https://api.github.com/licenses/mit', 'node_id': 'MDc6TGljZW5zZTEz'} True False False ['algorithm', 'jupyter', 'jupyter-notebook', 'machine-learning', 'machine-learning-algorithms', 'machinelearning', 'python'] public 4119 27 23825 master 1.0
3834332 MDEwOlJlcG9zaXRvcnkzODM0MzMy bokeh bokeh/bokeh False {'login': 'bokeh', 'id': 8440965, 'node_id': 'MDEyOk9yZ2FuaXphdGlvbjg0NDA5NjU=', 'avatar_url': 'https://avatars.githubusercontent.com/u/8440965?v=4', 'gravatar_id': '', 'url': 'https://api.github.com/users/bokeh', 'html_url': 'https://github.com/bokeh', 'followers_url': 'https://api.github.com/users/bokeh/followers', 'following_url': 'https://api.github.com/users/bokeh/following{/other_user}', 'gists_url': 'https://api.github.com/users/bokeh/gists{/gist_id}', 'starred_url': 'https://api.github.com/users/bokeh/starred{/owner}{/repo}', 'subscriptions_url': 'https://api.github.com/users/bokeh/subscriptions', 'organizations_url': 'https://api.github.com/users/bokeh/orgs', 'repos_url': 'https://api.github.com/users/bokeh/repos', 'events_url': 'https://api.github.com/users/bokeh/events{/privacy}', 'received_events_url': 'https://api.github.com/users/bokeh/received_events', 'type': 'Organization', 'user_view_type': 'public', 'site_admin': False} https://github.com/bokeh/bokeh Interactive Data Visualization in the browser, from Python False https://api.github.com/repos/bokeh/bokeh https://api.github.com/repos/bokeh/bokeh/forks https://api.github.com/repos/bokeh/bokeh/keys{/key_id} https://api.github.com/repos/bokeh/bokeh/collaborators{/collaborator} https://api.github.com/repos/bokeh/bokeh/teams https://api.github.com/repos/bokeh/bokeh/hooks https://api.github.com/repos/bokeh/bokeh/issues/events{/number} https://api.github.com/repos/bokeh/bokeh/events https://api.github.com/repos/bokeh/bokeh/assignees{/user} https://api.github.com/repos/bokeh/bokeh/branches{/branch} https://api.github.com/repos/bokeh/bokeh/tags https://api.github.com/repos/bokeh/bokeh/git/blobs{/sha} https://api.github.com/repos/bokeh/bokeh/git/tags{/sha} https://api.github.com/repos/bokeh/bokeh/git/refs{/sha} https://api.github.com/repos/bokeh/bokeh/git/trees{/sha} https://api.github.com/repos/bokeh/bokeh/statuses/{sha} https://api.github.com/repos/bokeh/bokeh/languages https://api.github.com/repos/bokeh/bokeh/stargazers https://api.github.com/repos/bokeh/bokeh/contributors https://api.github.com/repos/bokeh/bokeh/subscribers https://api.github.com/repos/bokeh/bokeh/subscription https://api.github.com/repos/bokeh/bokeh/commits{/sha} https://api.github.com/repos/bokeh/bokeh/git/commits{/sha} https://api.github.com/repos/bokeh/bokeh/comments{/number} https://api.github.com/repos/bokeh/bokeh/issues/comments{/number} https://api.github.com/repos/bokeh/bokeh/contents/{+path} https://api.github.com/repos/bokeh/bokeh/compare/{base}...{head} https://api.github.com/repos/bokeh/bokeh/merges https://api.github.com/repos/bokeh/bokeh/{archive_format}{/ref} https://api.github.com/repos/bokeh/bokeh/downloads https://api.github.com/repos/bokeh/bokeh/issues{/number} https://api.github.com/repos/bokeh/bokeh/pulls{/number} https://api.github.com/repos/bokeh/bokeh/milestones{/number} https://api.github.com/repos/bokeh/bokeh/notifications{?since,all,participating} https://api.github.com/repos/bokeh/bokeh/labels{/name} https://api.github.com/repos/bokeh/bokeh/releases{/id} https://api.github.com/repos/bokeh/bokeh/deployments 2012-03-26 15:40:01 2026-01-04 12:15:37 2026-01-03 18:59:39 git://github.com/bokeh/bokeh.git git@github.com:bokeh/bokeh.git https://github.com/bokeh/bokeh.git https://github.com/bokeh/bokeh https://bokeh.org 385410 20282 20282 TypeScript True True True True False True 4247 None False False 859 {'key': 'bsd-3-clause', 'name': 'BSD 3-Clause "New" or "Revised" License', 'spdx_id': 'BSD-3-Clause', 'url': 'https://api.github.com/licenses/bsd-3-clause', 'node_id': 'MDc6TGljZW5zZTU='} True False False ['bokeh', 'data-visualisation', 'interactive-plots', 'javascript', 'jupyter', 'notebooks', 'numfocus', 'plots', 'plotting', 'python', 'visualisation', 'visualization'] public 4247 859 20282 branch-3.9 1.0
102523304 MDEwOlJlcG9zaXRvcnkxMDI1MjMzMDQ= deep-learning-with-python-notebooks fchollet/deep-learning-with-python-notebooks False {'login': 'fchollet', 'id': 710255, 'node_id': 'MDQ6VXNlcjcxMDI1NQ==', 'avatar_url': 'https://avatars.githubusercontent.com/u/710255?v=4', 'gravatar_id': '', 'url': 'https://api.github.com/users/fchollet', 'html_url': 'https://github.com/fchollet', 'followers_url': 'https://api.github.com/users/fchollet/followers', 'following_url': 'https://api.github.com/users/fchollet/following{/other_user}', 'gists_url': 'https://api.github.com/users/fchollet/gists{/gist_id}', 'starred_url': 'https://api.github.com/users/fchollet/starred{/owner}{/repo}', 'subscriptions_url': 'https://api.github.com/users/fchollet/subscriptions', 'organizations_url': 'https://api.github.com/users/fchollet/orgs', 'repos_url': 'https://api.github.com/users/fchollet/repos', 'events_url': 'https://api.github.com/users/fchollet/events{/privacy}', 'received_events_url': 'https://api.github.com/users/fchollet/received_events', 'type': 'User', 'user_view_type': 'public', 'site_admin': False} https://github.com/fchollet/deep-learning-with-python-notebooks Jupyter notebooks for the code samples of the book "Deep Learning with Python" False https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/forks https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/keys{/key_id} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/collaborators{/collaborator} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/teams https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/hooks https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/issues/events{/number} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/events https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/assignees{/user} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/branches{/branch} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/tags https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/git/blobs{/sha} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/git/tags{/sha} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/git/refs{/sha} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/git/trees{/sha} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/statuses/{sha} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/languages https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/stargazers https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/contributors https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/subscribers https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/subscription https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/commits{/sha} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/git/commits{/sha} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/comments{/number} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/issues/comments{/number} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/contents/{+path} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/compare/{base}...{head} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/merges https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/{archive_format}{/ref} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/downloads https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/issues{/number} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/pulls{/number} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/milestones{/number} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/notifications{?since,all,participating} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/labels{/name} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/releases{/id} https://api.github.com/repos/fchollet/deep-learning-with-python-notebooks/deployments 2017-09-05 19:47:56 2026-01-04 03:58:12 2025-09-18 05:12:40 git://github.com/fchollet/deep-learning-with-python-notebooks.git git@github.com:fchollet/deep-learning-with-python-notebooks.git https://github.com/fchollet/deep-learning-with-python-notebooks.git https://github.com/fchollet/deep-learning-with-python-notebooks 7128 19826 19826 Jupyter Notebook True True True True False False 8990 None False False 200 {'key': 'mit', 'name': 'MIT License', 'spdx_id': 'MIT', 'url': 'https://api.github.com/licenses/mit', 'node_id': 'MDc6TGljZW5zZTEz'} True False False [] public 8990 200 19826 master 1.0
19868085 MDEwOlJlcG9zaXRvcnkxOTg2ODA4NQ== Kalman-and-Bayesian-Filters-in-Python rlabbe/Kalman-and-Bayesian-Filters-in-Python False {'login': 'rlabbe', 'id': 5308143, 'node_id': 'MDQ6VXNlcjUzMDgxNDM=', 'avatar_url': 'https://avatars.githubusercontent.com/u/5308143?v=4', 'gravatar_id': '', 'url': 'https://api.github.com/users/rlabbe', 'html_url': 'https://github.com/rlabbe', 'followers_url': 'https://api.github.com/users/rlabbe/followers', 'following_url': 'https://api.github.com/users/rlabbe/following{/other_user}', 'gists_url': 'https://api.github.com/users/rlabbe/gists{/gist_id}', 'starred_url': 'https://api.github.com/users/rlabbe/starred{/owner}{/repo}', 'subscriptions_url': 'https://api.github.com/users/rlabbe/subscriptions', 'organizations_url': 'https://api.github.com/users/rlabbe/orgs', 'repos_url': 'https://api.github.com/users/rlabbe/repos', 'events_url': 'https://api.github.com/users/rlabbe/events{/privacy}', 'received_events_url': 'https://api.github.com/users/rlabbe/received_events', 'type': 'User', 'user_view_type': 'public', 'site_admin': False} https://github.com/rlabbe/Kalman-and-Bayesian-Filters-in-Python Kalman Filter book using Jupyter Notebook. Focuses on building intuition and experience, not formal proofs. Includes Kalman filters,extended Kalman filters, unscented Kalman filters, particle filters, and more. All exercises include solutions. False https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/forks https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/keys{/key_id} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/collaborators{/collaborator} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/teams https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/hooks https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/issues/events{/number} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/events https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/assignees{/user} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/branches{/branch} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/tags https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/git/blobs{/sha} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/git/tags{/sha} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/git/refs{/sha} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/git/trees{/sha} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/statuses/{sha} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/languages https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/stargazers https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/contributors https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/subscribers https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/subscription https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/commits{/sha} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/git/commits{/sha} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/comments{/number} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/issues/comments{/number} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/contents/{+path} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/compare/{base}...{head} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/merges https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/{archive_format}{/ref} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/downloads https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/issues{/number} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/pulls{/number} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/milestones{/number} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/notifications{?since,all,participating} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/labels{/name} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/releases{/id} https://api.github.com/repos/rlabbe/Kalman-and-Bayesian-Filters-in-Python/deployments 2014-05-16 19:24:36 2026-01-04 13:41:56 2024-08-07 13:19:15 git://github.com/rlabbe/Kalman-and-Bayesian-Filters-in-Python.git git@github.com:rlabbe/Kalman-and-Bayesian-Filters-in-Python.git https://github.com/rlabbe/Kalman-and-Bayesian-Filters-in-Python.git https://github.com/rlabbe/Kalman-and-Bayesian-Filters-in-Python 590118 18573 18573 Jupyter Notebook True True True False True False 4439 None False False 136 {'key': 'other', 'name': 'Other', 'spdx_id': 'NOASSERTION', 'url': None, 'node_id': 'MDc6TGljZW5zZTA='} True False False [] public 4439 136 18573 master 1.0
658518 MDEwOlJlcG9zaXRvcnk2NTg1MTg= ipython ipython/ipython False {'login': 'ipython', 'id': 230453, 'node_id': 'MDEyOk9yZ2FuaXphdGlvbjIzMDQ1Mw==', 'avatar_url': 'https://avatars.githubusercontent.com/u/230453?v=4', 'gravatar_id': '', 'url': 'https://api.github.com/users/ipython', 'html_url': 'https://github.com/ipython', 'followers_url': 'https://api.github.com/users/ipython/followers', 'following_url': 'https://api.github.com/users/ipython/following{/other_user}', 'gists_url': 'https://api.github.com/users/ipython/gists{/gist_id}', 'starred_url': 'https://api.github.com/users/ipython/starred{/owner}{/repo}', 'subscriptions_url': 'https://api.github.com/users/ipython/subscriptions', 'organizations_url': 'https://api.github.com/users/ipython/orgs', 'repos_url': 'https://api.github.com/users/ipython/repos', 'events_url': 'https://api.github.com/users/ipython/events{/privacy}', 'received_events_url': 'https://api.github.com/users/ipython/received_events', 'type': 'Organization', 'user_view_type': 'public', 'site_admin': False} https://github.com/ipython/ipython Official repository for IPython itself. Other repos in the IPython organization contain things like the website, documentation builds, etc. False https://api.github.com/repos/ipython/ipython https://api.github.com/repos/ipython/ipython/forks https://api.github.com/repos/ipython/ipython/keys{/key_id} https://api.github.com/repos/ipython/ipython/collaborators{/collaborator} https://api.github.com/repos/ipython/ipython/teams https://api.github.com/repos/ipython/ipython/hooks https://api.github.com/repos/ipython/ipython/issues/events{/number} https://api.github.com/repos/ipython/ipython/events https://api.github.com/repos/ipython/ipython/assignees{/user} https://api.github.com/repos/ipython/ipython/branches{/branch} https://api.github.com/repos/ipython/ipython/tags https://api.github.com/repos/ipython/ipython/git/blobs{/sha} https://api.github.com/repos/ipython/ipython/git/tags{/sha} https://api.github.com/repos/ipython/ipython/git/refs{/sha} https://api.github.com/repos/ipython/ipython/git/trees{/sha} https://api.github.com/repos/ipython/ipython/statuses/{sha} https://api.github.com/repos/ipython/ipython/languages https://api.github.com/repos/ipython/ipython/stargazers https://api.github.com/repos/ipython/ipython/contributors https://api.github.com/repos/ipython/ipython/subscribers https://api.github.com/repos/ipython/ipython/subscription https://api.github.com/repos/ipython/ipython/commits{/sha} https://api.github.com/repos/ipython/ipython/git/commits{/sha} https://api.github.com/repos/ipython/ipython/comments{/number} https://api.github.com/repos/ipython/ipython/issues/comments{/number} https://api.github.com/repos/ipython/ipython/contents/{+path} https://api.github.com/repos/ipython/ipython/compare/{base}...{head} https://api.github.com/repos/ipython/ipython/merges https://api.github.com/repos/ipython/ipython/{archive_format}{/ref} https://api.github.com/repos/ipython/ipython/downloads https://api.github.com/repos/ipython/ipython/issues{/number} https://api.github.com/repos/ipython/ipython/pulls{/number} https://api.github.com/repos/ipython/ipython/milestones{/number} https://api.github.com/repos/ipython/ipython/notifications{?since,all,participating} https://api.github.com/repos/ipython/ipython/labels{/name} https://api.github.com/repos/ipython/ipython/releases{/id} https://api.github.com/repos/ipython/ipython/deployments 2010-05-10 04:46:06 2026-01-04 16:48:27 2026-01-03 10:31:40 git://github.com/ipython/ipython.git git@github.com:ipython/ipython.git https://github.com/ipython/ipython.git https://github.com/ipython/ipython https://ipython.readthedocs.org 81118 16640 16640 Python True True True True False False 4470 None False False 1574 {'key': 'bsd-3-clause', 'name': 'BSD 3-Clause "New" or "Revised" License', 'spdx_id': 'BSD-3-Clause', 'url': 'https://api.github.com/licenses/bsd-3-clause', 'node_id': 'MDc6TGljZW5zZTU='} True False False ['closember', 'data-science', 'hacktoberfest', 'ipython', 'jupyter', 'notebook', 'python', 'repl', 'spec-0'] public 4470 1574 16640 main 1.0
Truncated to displaylimit of 10.

However, this is a lot of information. After seeing what we’re working with, let’s pull the name of the repository, the author, the description, and the URL to make things cleaner. Let’s also limit our results to the top 5 starred repos.

%%sql
SELECT 
    name AS name,
    owner.login AS user,
    description AS description,
    html_url AS URL,
    stargazers_count AS stars
FROM read_json_auto('jupyterdata.json')
LIMIT 5
Running query in 'duckdb://'
name user description URL stars
PythonDataScienceHandbook jakevdp Python Data Science Handbook: full text in Jupyter Notebooks https://github.com/jakevdp/PythonDataScienceHandbook 46437
tqdm tqdm :zap: A Fast, Extensible Progress Bar for Python and CLI https://github.com/tqdm/tqdm 30824
handson-ml2 ageron A series of Jupyter notebooks that walk you through the fundamentals of Machine Learning and Deep Learning in Python using Scikit-Learn, Keras and TensorFlow 2. https://github.com/ageron/handson-ml2 29754
dash plotly Data Apps & Dashboards for Python. No JavaScript Required. https://github.com/plotly/dash 24375
fastbook fastai The fastai book, published as Jupyter Notebooks https://github.com/fastai/fastbook 24220

We can also load all of the pulled repositories that, say, have a certain range of stars:

%%sql
SELECT 
    name AS name,
    owner.login AS user,
    description AS description,
    html_url AS URL,
    stargazers_count AS stars
FROM read_json_auto('jupyterdata.json')
WHERE stargazers_count < 15000 AND stargazers_count > 10000
Running query in 'duckdb://'
name user description URL stars
jupyterlab jupyterlab JupyterLab computational environment. https://github.com/jupyterlab/jupyterlab 14961
ydata-profiling ydataai 1 Line of code data quality profiling & exploratory data analysis for Pandas and Spark DataFrames. https://github.com/ydataai/ydata-profiling 13328
notebook jupyter Jupyter Interactive Notebook https://github.com/jupyter/notebook 12863
python-training jpmorganchase Python training for business analysts and traders https://github.com/jpmorganchase/python-training 12436
handson-ml3 ageron A series of Jupyter notebooks that walk you through the fundamentals of Machine Learning and Deep Learning in Python using Scikit-Learn, Keras and TensorFlow 2. https://github.com/ageron/handson-ml3 12041
PRML ctgk PRML algorithms implemented in Python https://github.com/ctgk/PRML 11707
dive-into-machine-learning dive-into-machine-learning Free ways to dive into machine learning with Python and Jupyter Notebook. Notebooks, courses, and other links. (First posted in 2016.) https://github.com/dive-into-machine-learning/dive-into-machine-learning 11376
amazon-sagemaker-examples aws Example 📓 Jupyter notebooks that demonstrate how to build, train, and deploy machine learning models using 🧠 Amazon SageMaker. https://github.com/aws/amazon-sagemaker-examples 10838
numerical-linear-algebra fastai Free online textbook of Jupyter notebooks for fast.ai Computational Linear Algebra course https://github.com/fastai/numerical-linear-algebra 10682
perspective perspective-dev A data visualization and analytics component, especially well-suited for large and/or streaming datasets. https://github.com/perspective-dev/perspective 10080
Truncated to displaylimit of 10.

And save it to a .csv file:

%%sql
COPY (
    SELECT
    name AS name,
    owner.login AS user,
    description AS description,
    html_url AS URL,
    stargazers_count AS stars
    FROM read_json_auto('jupyterdata.json')
    WHERE stargazers_count < 15000 AND stargazers_count > 10000 
)

TO 'jupyterdata.csv' (HEADER, DELIMITER ',');
Running query in 'duckdb://'
Count 
%%sql
SELECT * FROM 'jupyterdata.csv'
Running query in 'duckdb://'
name user description URL stars
jupyterlab jupyterlab JupyterLab computational environment. https://github.com/jupyterlab/jupyterlab 14961
ydata-profiling ydataai 1 Line of code data quality profiling & exploratory data analysis for Pandas and Spark DataFrames. https://github.com/ydataai/ydata-profiling 13328
notebook jupyter Jupyter Interactive Notebook https://github.com/jupyter/notebook 12863
python-training jpmorganchase Python training for business analysts and traders https://github.com/jpmorganchase/python-training 12436
handson-ml3 ageron A series of Jupyter notebooks that walk you through the fundamentals of Machine Learning and Deep Learning in Python using Scikit-Learn, Keras and TensorFlow 2. https://github.com/ageron/handson-ml3 12041
PRML ctgk PRML algorithms implemented in Python https://github.com/ctgk/PRML 11707
dive-into-machine-learning dive-into-machine-learning Free ways to dive into machine learning with Python and Jupyter Notebook. Notebooks, courses, and other links. (First posted in 2016.) https://github.com/dive-into-machine-learning/dive-into-machine-learning 11376
amazon-sagemaker-examples aws Example 📓 Jupyter notebooks that demonstrate how to build, train, and deploy machine learning models using 🧠 Amazon SageMaker. https://github.com/aws/amazon-sagemaker-examples 10838
numerical-linear-algebra fastai Free online textbook of Jupyter notebooks for fast.ai Computational Linear Algebra course https://github.com/fastai/numerical-linear-algebra 10682
perspective perspective-dev A data visualization and analytics component, especially well-suited for large and/or streaming datasets. https://github.com/perspective-dev/perspective 10080
Truncated to displaylimit of 10.

There’s no shortage of information that we can pull from this API, so this is just one example. Feel free to give it a try yourself— or explore using JupySQL with another API or .json file!