issue_comments

Table actions

3 rows where author_association = "MEMBER" and issue = 329066551 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

user 2

issue 1

  • xarray.Dataset.sel(time='2007-04-12') returns unexpected time dimension · 3 ✖

author_association 1

  • MEMBER · 3 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
394763540 https://github.com/pydata/xarray/issues/2213#issuecomment-394763540 https://api.github.com/repos/pydata/xarray/issues/2213 MDEyOklzc3VlQ29tbWVudDM5NDc2MzU0MA== shoyer 1217238 2018-06-05T15:55:41Z 2018-06-05T15:55:41Z MEMBER

@hans-permana your example shows a different issue: indexing with a date string yields a time dimension of length 1, rather than squeezing it out (as is the case for datetime strings). This behavior is actually expected/consistent with pandas, although I agree that it is surprising.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xarray.Dataset.sel(time='2007-04-12') returns unexpected time dimension 329066551
394441450 https://github.com/pydata/xarray/issues/2213#issuecomment-394441450 https://api.github.com/repos/pydata/xarray/issues/2213 MDEyOklzc3VlQ29tbWVudDM5NDQ0MTQ1MA== shoyer 1217238 2018-06-04T17:50:38Z 2018-06-04T17:50:38Z MEMBER

At first glance, this does look broken. Can you reproduce this with self-contained dummy data? see http://matthewrocklin.com/blog/work/2018/02/28/minimal-bug-reports

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xarray.Dataset.sel(time='2007-04-12') returns unexpected time dimension 329066551
394366104 https://github.com/pydata/xarray/issues/2213#issuecomment-394366104 https://api.github.com/repos/pydata/xarray/issues/2213 MDEyOklzc3VlQ29tbWVudDM5NDM2NjEwNA== jhamman 2443309 2018-06-04T14:03:58Z 2018-06-04T14:03:58Z MEMBER

@hans-permana - thank you for the report. Can you try to reproduce this behavior with xarray version 0.10.6 (released last week)?

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xarray.Dataset.sel(time='2007-04-12') returns unexpected time dimension 329066551

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