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', '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 2023-11-07 20:49:40 2023-11-07 11:26:44 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 40000 40000 Jupyter Notebook True True True True True False 17403 None False False 206 {'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 17403 206 40000 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', '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 2023-11-07 21:28:15 2023-11-07 09:56:23 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 5987 26170 26170 Python True True True True True True 1340 None False False 477 {'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 1340 477 26170 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', '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 2023-11-07 21:46:25 2023-05-03 06:17:25 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 25879 25879 Jupyter Notebook True True True True False False 12223 None False False 209 {'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 12223 209 25879 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', '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 2023-11-07 12:50:00 2023-07-21 18:08:26 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 14834 21927 21927 Jupyter Notebook True False True False False False 4006 None False False 23 {'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 4006 23 21927 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', '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 2023-11-07 21:19:37 2023-11-01 00:25:25 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 153495 19582 19582 Python True True True False False False 2001 None False False 795 {'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', 'julia', 'jupyter', 'modeling', 'plotly', 'plotly-dash', 'productivity', 'python', 'r', 'react', 'rstats', 'technical-computing', 'web-app'] public 2001 795 19582 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', '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 2023-11-07 17:36:00 2023-10-26 13:48:39 git://github.com/fastai/fastbook.git git@github.com:fastai/fastbook.git https://github.com/fastai/fastbook.git https://github.com/fastai/fastbook 80408 19535 19535 Jupyter Notebook True True True True False False 7525 None False False 141 {'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 7525 141 19535 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', '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 2023-11-07 19:28:10 2023-11-07 21:09:03 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 333209 18266 18266 Python True True True True False True 4172 None False False 770 {'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 4172 770 18266 branch-3.4 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', '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 2023-11-07 11:09:12 2023-05-05 14:15:38 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 6990 17341 17341 Jupyter Notebook True True True True False False 8360 None False False 170 {'key': 'mit', 'name': 'MIT License', 'spdx_id': 'MIT', 'url': 'https://api.github.com/licenses/mit', 'node_id': 'MDc6TGljZW5zZTEz'} True False False [] public 8360 170 17341 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', '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 2023-11-07 12:33:43 2023-11-06 09:31:51 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 78207 15988 15988 Python True True True True False False 4477 None False False 1646 {'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 4477 1646 15988 main 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', '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 2023-11-07 21:48:51 2023-09-06 20:45:12 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 601390 14832 14832 Jupyter Notebook True True True True True False 3918 None False False 108 {'key': 'other', 'name': 'Other', 'spdx_id': 'NOASSERTION', 'url': None, 'node_id': 'MDc6TGljZW5zZTA='} True False False [] public 3918 108 14832 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 40000
tqdm tqdm :zap: A Fast, Extensible Progress Bar for Python and CLI https://github.com/tqdm/tqdm 26170
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 25879
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 21927
dash plotly Data Apps & Dashboards for Python. No JavaScript Required. https://github.com/plotly/dash 19582

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
Kalman-and-Bayesian-Filters-in-Python rlabbe 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. https://github.com/rlabbe/Kalman-and-Bayesian-Filters-in-Python 14832
jupyter jupyter Jupyter metapackage for installation, docs and chat https://github.com/jupyter/jupyter 14538
Screenshot-to-code emilwallner A neural network that transforms a design mock-up into a static website. https://github.com/emilwallner/Screenshot-to-code 14134
jupyterlab jupyterlab JupyterLab computational environment. https://github.com/jupyterlab/jupyterlab 13378
kubeflow kubeflow Machine Learning Toolkit for Kubernetes https://github.com/kubeflow/kubeflow 13124
ds-cheatsheets FavioVazquez List of Data Science Cheatsheets to rule the world https://github.com/FavioVazquez/ds-cheatsheets 12453
ydata-profiling ydataai 1 Line of code data quality profiling & exploratory data analysis for Pandas and Spark DataFrames. https://github.com/ydataai/ydata-profiling 11342
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 11198
PRML ctgk PRML algorithms implemented in Python https://github.com/ctgk/PRML 11179
notebook jupyter Jupyter Interactive Notebook https://github.com/jupyter/notebook 10649
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
Kalman-and-Bayesian-Filters-in-Python rlabbe 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. https://github.com/rlabbe/Kalman-and-Bayesian-Filters-in-Python 14832
jupyter jupyter Jupyter metapackage for installation, docs and chat https://github.com/jupyter/jupyter 14538
Screenshot-to-code emilwallner A neural network that transforms a design mock-up into a static website. https://github.com/emilwallner/Screenshot-to-code 14134
jupyterlab jupyterlab JupyterLab computational environment. https://github.com/jupyterlab/jupyterlab 13378
kubeflow kubeflow Machine Learning Toolkit for Kubernetes https://github.com/kubeflow/kubeflow 13124
ds-cheatsheets FavioVazquez List of Data Science Cheatsheets to rule the world https://github.com/FavioVazquez/ds-cheatsheets 12453
ydata-profiling ydataai 1 Line of code data quality profiling & exploratory data analysis for Pandas and Spark DataFrames. https://github.com/ydataai/ydata-profiling 11342
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 11198
PRML ctgk PRML algorithms implemented in Python https://github.com/ctgk/PRML 11179
notebook jupyter Jupyter Interactive Notebook https://github.com/jupyter/notebook 10649
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!