issue_comments

Table actions

1 row where issue = 297560256 and user = 5635139 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 · 1 ✖

issue 1

  • cartesian product of coordinates and using it to index / fill empty dataset · 1 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
366791162 https://github.com/pydata/xarray/issues/1914#issuecomment-366791162 https://api.github.com/repos/pydata/xarray/issues/1914 MDEyOklzc3VlQ29tbWVudDM2Njc5MTE2Mg== max-sixty 5635139 2018-02-19T20:05:53Z 2018-02-19T20:05:53Z MEMBER

I think that this shouldn't be too hard to 'get done' but also that xarray may not give you much help natively. (I'm not sure though, so take this as hopefully helpful contribution rather than a definitive answer)

Specifically, can you do (2) by generating a product of the coords? Either using numpy, stacking, or some simple python:

```python

In [3]: list(product(*((data[x].values) for x in data.dims))) Out[3]: [(0.287706062977495, 0.065327131503921), (0.287706062977495, 0.17398282388217068), (0.287706062977495, 0.1455022501442349), (0.42398126102299216, 0.065327131503921), (0.42398126102299216, 0.17398282388217068), (0.42398126102299216, 0.1455022501442349), (0.13357153947234057, 0.065327131503921), (0.13357153947234057, 0.17398282388217068), (0.13357153947234057, 0.1455022501442349), (0.42347765161572537, 0.065327131503921), (0.42347765161572537, 0.17398282388217068), (0.42347765161572537, 0.1455022501442349)] ```

then distribute those out to a cluster if you need, and then unstack them back into a dataset?

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   cartesian product of coordinates and using it to index / fill empty dataset 297560256

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