issue_comments

Table actions

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

  • Choose time units in output netcdf · 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
322894648 https://github.com/pydata/xarray/issues/1324#issuecomment-322894648 https://api.github.com/repos/pydata/xarray/issues/1324 MDEyOklzc3VlQ29tbWVudDMyMjg5NDY0OA== shoyer 1217238 2017-08-16T20:48:13Z 2017-08-16T20:48:13Z MEMBER

@mmartini-usgs The here comes up because your time variables have dtype datetime64. There are two ways to handle this: - If you don't want xarray to convert from datetime64 to numbers when saving the netCDF file, you need to convert the data yourself to a float or integer array. - If you do want to make use of xarray's automated conversion, you need to specify units in encoding instead of attrs.

If something else seems to be going on, please share the result of calling .info() on your dataset.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Choose time units in output netcdf 216626776
288942654 https://github.com/pydata/xarray/issues/1324#issuecomment-288942654 https://api.github.com/repos/pydata/xarray/issues/1324 MDEyOklzc3VlQ29tbWVudDI4ODk0MjY1NA== shoyer 1217238 2017-03-24T06:17:36Z 2017-03-24T06:17:36Z MEMBER

Yes, you can control this by setting encoding, e.g., time.encoding['units'] = 'days since '1900-01-01' http://xarray.pydata.org/en/stable/io.html#time-units

It looks like this error message is not very helpful currently -- a PR to improve it would be appreciated!

 
{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Choose time units in output netcdf 216626776

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