issue_comments

Table actions

4 rows where issue = 179969119 and user = 1197350 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

user 1

  • rabernat · 4 ✖

issue 1

  • groupby_bins: exclude bin or assign bin with nan when bin has no values · 4 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
250494742 https://github.com/pydata/xarray/issues/1019#issuecomment-250494742 https://api.github.com/repos/pydata/xarray/issues/1019 MDEyOklzc3VlQ29tbWVudDI1MDQ5NDc0Mg== rabernat 1197350 2016-09-29T15:09:08Z 2016-09-29T15:09:12Z MEMBER

For now, can you just confirm what version of xarray you are using (xarray.__version__)?

I'm not sure if #952 has been released yet, but if you are using the latest master, that should at least fix the sorting issue.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   groupby_bins: exclude bin or assign bin with nan when bin has no values 179969119
250490528 https://github.com/pydata/xarray/issues/1019#issuecomment-250490528 https://api.github.com/repos/pydata/xarray/issues/1019 MDEyOklzc3VlQ29tbWVudDI1MDQ5MDUyOA== rabernat 1197350 2016-09-29T14:55:05Z 2016-09-29T14:55:05Z MEMBER

As for the empty bins, I can see how this would be useful. I suppose it is a bug. Curious what @shoyer thinks about this case...

 
{
    "total_count": 2,
    "+1": 2,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   groupby_bins: exclude bin or assign bin with nan when bin has no values 179969119
250487659 https://github.com/pydata/xarray/issues/1019#issuecomment-250487659 https://api.github.com/repos/pydata/xarray/issues/1019 MDEyOklzc3VlQ29tbWVudDI1MDQ4NzY1OQ== rabernat 1197350 2016-09-29T14:45:46Z 2016-09-29T14:45:46Z MEMBER

The sorting of bins should have been fixed in #952.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   groupby_bins: exclude bin or assign bin with nan when bin has no values 179969119
250464887 https://github.com/pydata/xarray/issues/1019#issuecomment-250464887 https://api.github.com/repos/pydata/xarray/issues/1019 MDEyOklzc3VlQ29tbWVudDI1MDQ2NDg4Nw== rabernat 1197350 2016-09-29T13:25:10Z 2016-09-29T13:25:10Z MEMBER

Just to understand better, what is the advantage to having this empty bin? How would you use that feature?

As is, the resulting Dataset can still be aligned with other bin objects that have different coordinates (i.e. non empty final bin).

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   groupby_bins: exclude bin or assign bin with nan when bin has no values 179969119

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