issue_comments

Table actions

1 row where author_association = "MEMBER", issue = 309686915 and user = 1217238 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: author_association

user 1

  • shoyer · 1 ✖

issue 1

  • square-bracket slice a Dataset with a DataArray · 1 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
377314912 https://github.com/pydata/xarray/issues/2027#issuecomment-377314912 https://api.github.com/repos/pydata/xarray/issues/2027 MDEyOklzc3VlQ29tbWVudDM3NzMxNDkxMg== shoyer 1217238 2018-03-29T17:40:30Z 2018-03-29T17:40:30Z MEMBER

I think the short answer why we don't support this is that with __getitem__ on Dataset it's potentially ambiguous which dimensions you are slicing along. This is why we require you to specify the dimensions using sel().

This might be clearer with integer indexing. We support indexing like ds.vote[np.array([1, 2])] or ds.vote[xarray.DataArray([1, 2], dims='new_dim')] because it's clear what the first dimension of ds.vote is. (Recall that the dimensions of the indexing key only determine how data in the result is arranged, not what is indexed.) But we don't support ds[np.array([1, 2])], because axis-order dependent indexing on a Dataset is potentially ambiguous.

However, we could potentially support this as a form of "multi-dimensional boolean indexing" (https://github.com/pydata/xarray/issues/1887). Basically, ds[key] where key is a single indexer with boolean dtype could be interpreted as equivalent to ds.where(key, drop=True).

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   square-bracket slice a Dataset with a DataArray 309686915

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]);