issue_comments

Table actions

1 row where author_association = "MEMBER", issue = 243270042 and user = 1197350 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

  • rabernat · 1 ✖

issue 1

  • Time Dimension, Big problem with methods 'groupby' and 'to_netcdf' · 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
316810057 https://github.com/pydata/xarray/issues/1480#issuecomment-316810057 https://api.github.com/repos/pydata/xarray/issues/1480 MDEyOklzc3VlQ29tbWVudDMxNjgxMDA1Nw== rabernat 1197350 2017-07-20T19:46:15Z 2017-07-20T19:46:15Z MEMBER

As I understand he is getting monthly data out of groupby-method and in his example the "time" survives. It seems to be that the functionality of groupby-month changed during the years, because the groupby-method in Nicolas's example did not aggregate same calendar month to one time stamp.

There has been no change in xarray's groupby behavior. Nicolas' example would work with today's code. When you call datset.groupby('time.month').mean('time'), you remove the time dimension by aggregating over it. If you had applied a different (non-reducing) function to the group (e.g. datset.groupby('time.month').apply(lambda x : x**2), you would preserve the time dimension.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Time Dimension, Big problem with methods 'groupby' and 'to_netcdf' 243270042

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