issue_comments

Table actions

4 rows where author_association = "MEMBER" and issue = 106581329 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

user 3

issue 1

  • define fill value for where · 4 ✖

author_association 1

  • MEMBER · 4 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
276489774 https://github.com/pydata/xarray/issues/576#issuecomment-276489774 https://api.github.com/repos/pydata/xarray/issues/576 MDEyOklzc3VlQ29tbWVudDI3NjQ4OTc3NA== shoyer 1217238 2017-01-31T20:57:54Z 2017-01-31T20:57:54Z MEMBER

It should already work with apply_ufunc -- we just need to adjust where to use it. Take a look at the latest version of fillna for an example. On Tue, Jan 31, 2017 at 12:35 PM Joe Hamman notifications@github.com wrote:

@shoyer https://github.com/shoyer - what do we need in order to get the 3-argument broadcasting working. I'd really like to get this into xarray.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/pydata/xarray/issues/576#issuecomment-276483988, or mute the thread https://github.com/notifications/unsubscribe-auth/ABKS1l3x4bNqrxkH0X1Ag4kI-T1Yq_Lrks5rX5sUgaJpZM4F9tqJ . 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   define fill value for where 106581329
276483988 https://github.com/pydata/xarray/issues/576#issuecomment-276483988 https://api.github.com/repos/pydata/xarray/issues/576 MDEyOklzc3VlQ29tbWVudDI3NjQ4Mzk4OA== jhamman 2443309 2017-01-31T20:35:31Z 2017-01-31T20:35:31Z MEMBER

@shoyer - what do we need in order to get the 3-argument broadcasting working. I'd really like to get this into xarray.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   define fill value for where 106581329
199381694 https://github.com/pydata/xarray/issues/576#issuecomment-199381694 https://api.github.com/repos/pydata/xarray/issues/576 MDEyOklzc3VlQ29tbWVudDE5OTM4MTY5NA== max-sixty 5635139 2016-03-21T17:03:29Z 2016-03-21T17:03:29Z MEMBER

This would be great to add - we just hit this (CC @justinkuosixty).

For now, a work around (at a slight cost in efficiency) is to use where followed by fillna.

This works, although if there are already NaNs, it requires another where to add those back

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   define fill value for where 106581329
140466092 https://github.com/pydata/xarray/issues/576#issuecomment-140466092 https://api.github.com/repos/pydata/xarray/issues/576 MDEyOklzc3VlQ29tbWVudDE0MDQ2NjA5Mg== shoyer 1217238 2015-09-15T17:09:24Z 2015-09-15T17:09:24Z MEMBER

Agreed. I didn't add this only because we don't yet have three-argument broadcasting operations working yet.

For now, a work around (at a slight cost in efficiency) is to use where followed by fillna.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   define fill value for where 106581329

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