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://

[JupySQL] Initializing providers...
[JupySQL] JUPYSQL_CNPG_ENABLED=NOT SET
[JupySQL] JUPYSQL_CNPG_NAMESPACE=NOT SET
[CNPG] Provider __init__ called, enabled=False
[JupySQL] CNPG provider registered, enabled=True
[JupySQL] CNPG discovered 0 database(s)
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 has_pull_requests pull_request_creation_policy 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-04-01 17:29:34 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 47173 47173 Jupyter Notebook True True True True True False 18805 None False False 230 {'key': 'mit', 'name': 'MIT License', 'spdx_id': 'MIT', 'url': 'https://api.github.com/licenses/mit', 'node_id': 'MDc6TGljZW5zZTEz'} True False False True all ['jupyter-notebook', 'matplotlib', 'numpy', 'pandas', 'python', 'scikit-learn'] public 18805 230 47173 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-04-01 13:45:19 2026-02-14 00:27:00 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 6053 31078 31078 Python True True True True True True 1442 None False False 601 {'key': 'other', 'name': 'Other', 'spdx_id': 'NOASSERTION', 'url': None, 'node_id': 'MDc6TGljZW5zZTA='} True False False True all ['cli', 'closember', 'console', 'discord', 'gui', 'jupyter', 'keras', 'meter', 'pandas', 'parallel', 'progress', 'progress-bar', 'progressbar', 'progressmeter', 'python', 'rate', 'telegram', 'terminal', 'time', 'utilities'] public 1442 601 31078 master 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-04-01 17:57:48 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 24829 24829 Jupyter Notebook True True True True False False 9452 None False False 179 {'key': 'other', 'name': 'Other', 'spdx_id': 'NOASSERTION', 'url': None, 'node_id': 'MDc6TGljZW5zZTA='} True False False True all ['book', 'data-science', 'deep-learning', 'fastai', 'machine-learning', 'notebooks', 'python'] public 9452 179 24829 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-04-01 18:13:46 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 24432 24432 Jupyter Notebook True False True False False False 4170 None False False 29 {'key': 'mit', 'name': 'MIT License', 'spdx_id': 'MIT', 'url': 'https://api.github.com/licenses/mit', 'node_id': 'MDc6TGljZW5zZTEz'} True False False True all ['algorithm', 'jupyter', 'jupyter-notebook', 'machine-learning', 'machine-learning-algorithms', 'machinelearning', 'python'] public 4170 29 24432 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-04-01 17:20:13 2026-04-01 16:02:37 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 205649 24431 24431 Python True True True False False False 2269 None False False 602 {'key': 'mit', 'name': 'MIT License', 'spdx_id': 'MIT', 'url': 'https://api.github.com/licenses/mit', 'node_id': 'MDc6TGljZW5zZTEz'} True False False True all ['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 2269 602 24431 dev 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-04-01 17:35:20 2026-04-01 17:35:10 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 383389 20385 20385 TypeScript True True True True False True 4252 None False False 861 {'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 True all ['bokeh', 'data-visualisation', 'interactive-plots', 'javascript', 'jupyter', 'notebooks', 'numfocus', 'plots', 'plotting', 'python', 'visualisation', 'visualization'] public 4252 861 20385 branch-3.10 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-04-01 13:14:17 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 20018 20018 Jupyter Notebook True True True True False False 9050 None False False 207 {'key': 'mit', 'name': 'MIT License', 'spdx_id': 'MIT', 'url': 'https://api.github.com/licenses/mit', 'node_id': 'MDc6TGljZW5zZTEz'} True False False True all [] public 9050 207 20018 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-04-01 13:13:39 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 18862 18862 Jupyter Notebook True True True False True False 4474 None False False 140 {'key': 'other', 'name': 'Other', 'spdx_id': 'NOASSERTION', 'url': None, 'node_id': 'MDc6TGljZW5zZTA='} True False False True all [] public 4474 140 18862 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-04-01 11:50:19 2026-04-01 04:19:42 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 81525 16692 16692 Python True True True True False False 4465 None False False 1580 {'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 True all ['closember', 'data-science', 'hacktoberfest', 'ipython', 'jupyter', 'notebook', 'python', 'repl', 'spec-0'] public 4465 1580 16692 main 1.0
107119649 MDEwOlJlcG9zaXRvcnkxMDcxMTk2NDk= Screenshot-to-code emilwallner/Screenshot-to-code False {'login': 'emilwallner', 'id': 12543699, 'node_id': 'MDQ6VXNlcjEyNTQzNjk5', 'avatar_url': 'https://avatars.githubusercontent.com/u/12543699?v=4', 'gravatar_id': '', 'url': 'https://api.github.com/users/emilwallner', 'html_url': 'https://github.com/emilwallner', 'followers_url': 'https://api.github.com/users/emilwallner/followers', 'following_url': 'https://api.github.com/users/emilwallner/following{/other_user}', 'gists_url': 'https://api.github.com/users/emilwallner/gists{/gist_id}', 'starred_url': 'https://api.github.com/users/emilwallner/starred{/owner}{/repo}', 'subscriptions_url': 'https://api.github.com/users/emilwallner/subscriptions', 'organizations_url': 'https://api.github.com/users/emilwallner/orgs', 'repos_url': 'https://api.github.com/users/emilwallner/repos', 'events_url': 'https://api.github.com/users/emilwallner/events{/privacy}', 'received_events_url': 'https://api.github.com/users/emilwallner/received_events', 'type': 'User', 'user_view_type': 'public', 'site_admin': False} https://github.com/emilwallner/Screenshot-to-code A neural network that transforms a design mock-up into a static website. False https://api.github.com/repos/emilwallner/Screenshot-to-code https://api.github.com/repos/emilwallner/Screenshot-to-code/forks https://api.github.com/repos/emilwallner/Screenshot-to-code/keys{/key_id} https://api.github.com/repos/emilwallner/Screenshot-to-code/collaborators{/collaborator} https://api.github.com/repos/emilwallner/Screenshot-to-code/teams https://api.github.com/repos/emilwallner/Screenshot-to-code/hooks https://api.github.com/repos/emilwallner/Screenshot-to-code/issues/events{/number} https://api.github.com/repos/emilwallner/Screenshot-to-code/events https://api.github.com/repos/emilwallner/Screenshot-to-code/assignees{/user} https://api.github.com/repos/emilwallner/Screenshot-to-code/branches{/branch} https://api.github.com/repos/emilwallner/Screenshot-to-code/tags https://api.github.com/repos/emilwallner/Screenshot-to-code/git/blobs{/sha} https://api.github.com/repos/emilwallner/Screenshot-to-code/git/tags{/sha} https://api.github.com/repos/emilwallner/Screenshot-to-code/git/refs{/sha} https://api.github.com/repos/emilwallner/Screenshot-to-code/git/trees{/sha} https://api.github.com/repos/emilwallner/Screenshot-to-code/statuses/{sha} https://api.github.com/repos/emilwallner/Screenshot-to-code/languages https://api.github.com/repos/emilwallner/Screenshot-to-code/stargazers https://api.github.com/repos/emilwallner/Screenshot-to-code/contributors https://api.github.com/repos/emilwallner/Screenshot-to-code/subscribers https://api.github.com/repos/emilwallner/Screenshot-to-code/subscription https://api.github.com/repos/emilwallner/Screenshot-to-code/commits{/sha} https://api.github.com/repos/emilwallner/Screenshot-to-code/git/commits{/sha} https://api.github.com/repos/emilwallner/Screenshot-to-code/comments{/number} https://api.github.com/repos/emilwallner/Screenshot-to-code/issues/comments{/number} https://api.github.com/repos/emilwallner/Screenshot-to-code/contents/{+path} https://api.github.com/repos/emilwallner/Screenshot-to-code/compare/{base}...{head} https://api.github.com/repos/emilwallner/Screenshot-to-code/merges https://api.github.com/repos/emilwallner/Screenshot-to-code/{archive_format}{/ref} https://api.github.com/repos/emilwallner/Screenshot-to-code/downloads https://api.github.com/repos/emilwallner/Screenshot-to-code/issues{/number} https://api.github.com/repos/emilwallner/Screenshot-to-code/pulls{/number} https://api.github.com/repos/emilwallner/Screenshot-to-code/milestones{/number} https://api.github.com/repos/emilwallner/Screenshot-to-code/notifications{?since,all,participating} https://api.github.com/repos/emilwallner/Screenshot-to-code/labels{/name} https://api.github.com/repos/emilwallner/Screenshot-to-code/releases{/id} https://api.github.com/repos/emilwallner/Screenshot-to-code/deployments 2017-10-16 11:41:48 2026-04-01 17:09:52 2024-08-16 22:05:07 git://github.com/emilwallner/Screenshot-to-code.git git@github.com:emilwallner/Screenshot-to-code.git https://github.com/emilwallner/Screenshot-to-code.git https://github.com/emilwallner/Screenshot-to-code 51643 16504 16504 HTML True True True True False False 1546 None False False 22 {'key': 'other', 'name': 'Other', 'spdx_id': 'NOASSERTION', 'url': None, 'node_id': 'MDc6TGljZW5zZTA='} True False False True all ['cnn', 'cnn-keras', 'deep-learning', 'encoder-decoder', 'floydhub', 'jupyter', 'jupyter-notebook', 'keras', 'lstm', 'machine-learning', 'seq2seq'] public 1546 22 16504 master 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 47173
tqdm tqdm :zap: A Fast, Extensible Progress Bar for Python and CLI https://github.com/tqdm/tqdm 31078
fastbook fastai The fastai book, published as Jupyter Notebooks https://github.com/fastai/fastbook 24829
homemade-machine-learning trekhleb 🤖 Python examples of popular machine learning algorithms with interactive Jupyter demos and math being explained https://github.com/trekhleb/homemade-machine-learning 24432
dash plotly Data Apps & Dashboards for Python. No JavaScript Required. https://github.com/plotly/dash 24431

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
ydata-profiling Data-Centric-AI-Community 1 Line of code data quality profiling & exploratory data analysis for Pandas and Spark DataFrames. https://github.com/Data-Centric-AI-Community/ydata-profiling 13458
notebook jupyter Jupyter Interactive Notebook https://github.com/jupyter/notebook 13046
python-training jpmorganchase Python training for business analysts and traders https://github.com/jpmorganchase/python-training 12933
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 12780
PRML ctgk PRML algorithms implemented in Python https://github.com/ctgk/PRML 11724
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 11398
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 10901
numerical-linear-algebra fastai Free online textbook of Jupyter notebooks for fast.ai Computational Linear Algebra course https://github.com/fastai/numerical-linear-algebra 10776
perspective perspective-dev A data visualization and analytics component, especially well-suited for large and/or streaming datasets. https://github.com/perspective-dev/perspective 10413

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
ydata-profiling Data-Centric-AI-Community 1 Line of code data quality profiling & exploratory data analysis for Pandas and Spark DataFrames. https://github.com/Data-Centric-AI-Community/ydata-profiling 13458
notebook jupyter Jupyter Interactive Notebook https://github.com/jupyter/notebook 13046
python-training jpmorganchase Python training for business analysts and traders https://github.com/jpmorganchase/python-training 12933
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 12780
PRML ctgk PRML algorithms implemented in Python https://github.com/ctgk/PRML 11724
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 11398
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 10901
numerical-linear-algebra fastai Free online textbook of Jupyter notebooks for fast.ai Computational Linear Algebra course https://github.com/fastai/numerical-linear-algebra 10776
perspective perspective-dev A data visualization and analytics component, especially well-suited for large and/or streaming datasets. https://github.com/perspective-dev/perspective 10413

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!