issue_comments

Table actions

2 rows where author_association = "MEMBER" and issue = 167684282 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

issue 1

  • ValueError: encountered unexpected variable nbnds · 2 ✖

author_association 1

  • MEMBER · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
235743079 https://github.com/pydata/xarray/issues/919#issuecomment-235743079 https://api.github.com/repos/pydata/xarray/issues/919 MDEyOklzc3VlQ29tbWVudDIzNTc0MzA3OQ== shoyer 1217238 2016-07-27T22:37:01Z 2016-07-27T22:37:01Z MEMBER

There's already an issue for tracking this feature -- see https://github.com/pydata/xarray/issues/508

xarray should definitely make this easier for users. Blaming the data provider for something that is actually quite common is not really fair :).

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   ValueError: encountered unexpected variable nbnds 167684282
235443620 https://github.com/pydata/xarray/issues/919#issuecomment-235443620 https://api.github.com/repos/pydata/xarray/issues/919 MDEyOklzc3VlQ29tbWVudDIzNTQ0MzYyMA== shoyer 1217238 2016-07-27T00:06:31Z 2016-07-27T00:06:31Z MEMBER

The problem appears to be that these datasets are inconsistent: some have an nbnds variables, and some don't. Xarray doesn't know what to do in this situation, so it raises an error. You'll need to add some custom processing logic to make the datasets consistent before you merge them.

In principle, we could handle missing variables by adding NaNs, possibly by adding a flag allow_missing_variables to concat. But this doesn't exist yet.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   ValueError: encountered unexpected variable nbnds 167684282

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