home / github

Menu
  • Search all tables
  • GraphQL API

issue_comments

Table actions
  • GraphQL API for issue_comments

5 rows where issue = 211323643 and user = 6815844 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

  • fujiisoup · 5 ✖

issue 1

  • Added a support for Dataset.rolling. · 5 ✖

author_association 1

  • MEMBER 5
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
289036993 https://github.com/pydata/xarray/pull/1289#issuecomment-289036993 https://api.github.com/repos/pydata/xarray/issues/1289 MDEyOklzc3VlQ29tbWVudDI4OTAzNjk5Mw== fujiisoup 6815844 2017-03-24T14:26:16Z 2017-03-24T14:26:16Z MEMBER

@shoyer Thank you for the reply. I did not yet think of smarter solution. I hope the current implementation is acceptable. If I come up with cleaner script, I will send another PR.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Added a support for Dataset.rolling. 211323643
284367479 https://github.com/pydata/xarray/pull/1289#issuecomment-284367479 https://api.github.com/repos/pydata/xarray/issues/1289 MDEyOklzc3VlQ29tbWVudDI4NDM2NzQ3OQ== fujiisoup 6815844 2017-03-06T11:08:09Z 2017-03-06T11:08:09Z MEMBER

we try to do it when possible because it leads to more predictable results.

OK. I totally agree with this. (Today I experienced a bug caused by unexpectedly aligned data_vars in other project. I realized predictable behavior is really important :) )

I think this PR is ready for review. If anyone has comments about the following behavior, I'm happy to update the code. + Only data_vars depending on the given rolling-dim are reduced. The others remain unchanged but are still stored in the reduced dataset (not dropped). + If rolling-dim is not included in Dataset.dims, this class raises KeyErrror. + The order of data_vars remain unchanged even after reduce(). + All the attrs are dropped.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Added a support for Dataset.rolling. 211323643
284226244 https://github.com/pydata/xarray/pull/1289#issuecomment-284226244 https://api.github.com/repos/pydata/xarray/issues/1289 MDEyOklzc3VlQ29tbWVudDI4NDIyNjI0NA== fujiisoup 6815844 2017-03-05T13:00:02Z 2017-03-05T13:02:00Z MEMBER
  • Now DatasetRolling.reduce() keeps its original data_vars order.
  • Dataset.rolling is added to api.rst.

I updated DatasetRolling so that its reduce method relies mostly on DataArrayRolling.reduce rather than window.reduce. This change makes not only the reduced-Dataset keep its original order of data_var, but also makes the code much cleaner. I moved many methods from Rolling to DataArrayRolling because DatasetRolling does not use them anymore.

However, I guess Rolling class is originally designed to be used also for Dataset, as discussed in #859. If someone has any requests, I will reconsider the class structure.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Added a support for Dataset.rolling. 211323643
284217037 https://github.com/pydata/xarray/pull/1289#issuecomment-284217037 https://api.github.com/repos/pydata/xarray/issues/1289 MDEyOklzc3VlQ29tbWVudDI4NDIxNzAzNw== fujiisoup 6815844 2017-03-05T09:48:55Z 2017-03-05T09:48:55Z MEMBER

@shoyer Thanks for the review.

I didn't notice Dataset keeps the order of data_vars. I think I should change the direction, because the data_var's order is destroyed after the final merge call.

Maybe DatasetRolling should not be a child of Rolling, but an independent class that has an OrderedDict of Rolling for each data_var to preserve the variable order.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Added a support for Dataset.rolling. 211323643
283931660 https://github.com/pydata/xarray/pull/1289#issuecomment-283931660 https://api.github.com/repos/pydata/xarray/issues/1289 MDEyOklzc3VlQ29tbWVudDI4MzkzMTY2MA== fujiisoup 6815844 2017-03-03T11:30:45Z 2017-03-03T11:30:45Z MEMBER

@MaximilianR

Thanks for the review. I made rolling_cls and groupby_cls private, and added some docstrings.

Also, I removed _axis_num property in Rolling class to make it compatible with Dataset. It can be replaced by da.get_axis_num(self.dim).

{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Added a support for Dataset.rolling. 211323643

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