home / github

Menu
  • Search all tables
  • GraphQL API

issue_comments

Table actions
  • GraphQL API for issue_comments

2 rows where author_association = "NONE", issue = 394625579 and user = 4179064 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

  • xylar · 2 ✖

issue 1

  • open_mfdataset change the attributes of Coordinates · 2 ✖

author_association 1

  • NONE · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
450455452 https://github.com/pydata/xarray/issues/2636#issuecomment-450455452 https://api.github.com/repos/pydata/xarray/issues/2636 MDEyOklzc3VlQ29tbWVudDQ1MDQ1NTQ1Mg== xylar 4179064 2018-12-29T02:07:54Z 2018-12-29T02:07:54Z NONE

@zxdawn, I was able to verify that, by adding decode_times=False to your code, I get: ``` keys of merge: odict_keys(['lon', 'lat', 'temperature', 'time'])

time of merge: <class 'netCDF4._netCDF4.Variable'> int64 time(time) units: hours since 2015-01-01 unlimited dimensions: current shape = (6,) filling on, default _FillValue of -9223372036854775806 used ```

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  open_mfdataset change the attributes of Coordinates 394625579
450400275 https://github.com/pydata/xarray/issues/2636#issuecomment-450400275 https://api.github.com/repos/pydata/xarray/issues/2636 MDEyOklzc3VlQ29tbWVudDQ1MDQwMDI3NQ== xylar 4179064 2018-12-28T17:54:19Z 2018-12-28T17:54:19Z NONE

Depending on your needs, you might be able to get away with calling open_mfdataset with decode_times=False. This should leave your time coordinate as it is (i.e. integer hours since 2015-01-01) but that will limit the types of operations you can do on the time dimension because it will not be converted to some kind of DateTime object. For example, it would be difficult to do time averaging that is aware of months, years, etc.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  open_mfdataset change the attributes of Coordinates 394625579

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