home / github

Menu
  • GraphQL API
  • Search all tables

issue_comments

Table actions
  • GraphQL API for issue_comments

1 row where issue = 310670696 and user = 1217238 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

  • shoyer · 1 ✖

issue 1

  • Manually subtracting two slices of DataArary always produces zero output · 1 ✖

author_association 1

  • MEMBER 1
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
378125383 https://github.com/pydata/xarray/issues/2035#issuecomment-378125383 https://api.github.com/repos/pydata/xarray/issues/2035 MDEyOklzc3VlQ29tbWVudDM3ODEyNTM4Mw== shoyer 1217238 2018-04-03T04:33:40Z 2018-04-03T04:33:40Z MEMBER

If you look at the coordinates, the first and last labels get removed in arithmetic (by default we use an inner join).

You might find it more informative to look at the result of doing arithmetic with an outer join, which does result in some NaNs: ``` In [5]: with xr.set_options(arithmetic_join='outer'): ...: print(da[...,1:]-da[...,:-1]) ...: <xarray.DataArray (x: 5, y: 5, z: 5)> array([[[nan, 0., 0., 0., nan], [nan, 0., 0., 0., nan], [nan, 0., 0., 0., nan], [nan, 0., 0., 0., nan], [nan, 0., 0., 0., nan]],

   [[nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan]],

   [[nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan]],

   [[nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan]],

   [[nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan],
    [nan,  0.,  0.,  0., nan]]])

Coordinates: * z (z) int64 0 1 2 3 4 * x (x) int64 0 1 2 3 4 * y (y) int64 0 1 2 3 4 ```

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Manually subtracting two slices of DataArary always produces zero output 310670696

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 255.639ms · About: xarray-datasette