home / github

Menu
  • Search all tables
  • GraphQL API

issue_comments

Table actions
  • GraphQL API for issue_comments

2 rows where issue = 894498459 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

user 1

  • max-sixty 2

issue 1

  • Progressbar for groupby operations? · 2 ✖

author_association 1

  • MEMBER 2
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
843676222 https://github.com/pydata/xarray/issues/5332#issuecomment-843676222 https://api.github.com/repos/pydata/xarray/issues/5332 MDEyOklzc3VlQ29tbWVudDg0MzY3NjIyMg== max-sixty 5635139 2021-05-19T01:27:55Z 2021-05-19T01:27:55Z MEMBER

NB: the example linked only operates on .apply in pandas, which runs in python, and so is slow. We want to do that as little as possible. Notably, there is no way of a progressbar with groupby in pandas.

{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Progressbar for groupby operations? 894498459
843675815 https://github.com/pydata/xarray/issues/5332#issuecomment-843675815 https://api.github.com/repos/pydata/xarray/issues/5332 MDEyOklzc3VlQ29tbWVudDg0MzY3NTgxNQ== max-sixty 5635139 2021-05-19T01:26:46Z 2021-05-19T01:26:46Z MEMBER

The main issue with these is that we don't generally get callbacks so we can render progress, because we're trying to keep as much of the operation out of python as possible.

We actually do with groupby at the moment, but we're hopefully moving to numpy_groupies, which will mean we don't run the loop in python.

I'd be interested if there are approaches to this — which would be a very useful feature — for functions that don't return to python before the end of the operation.

{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Progressbar for groupby operations? 894498459

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [issue_comments] (
   [html_url] TEXT,
   [issue_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [updated_at] TEXT,
   [author_association] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [performed_via_github_app] TEXT,
   [issue] INTEGER REFERENCES [issues]([id])
);
CREATE INDEX [idx_issue_comments_issue]
    ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
    ON [issue_comments] ([user]);
Powered by Datasette · Queries took 12.875ms · About: xarray-datasette