home / github

Menu
  • GraphQL API
  • Search all tables

issue_comments

Table actions
  • GraphQL API for issue_comments

2 rows where author_association = "CONTRIBUTOR", issue = 373449569 and user = 11750960 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

  • apatlpo · 2 ✖

issue 1

  • isel slows down computation significantly after open_dataset · 2 ✖

author_association 1

  • CONTRIBUTOR · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
432998937 https://github.com/pydata/xarray/issues/2504#issuecomment-432998937 https://api.github.com/repos/pydata/xarray/issues/2504 MDEyOklzc3VlQ29tbWVudDQzMjk5ODkzNw== apatlpo 11750960 2018-10-25T10:27:49Z 2018-10-25T10:27:49Z CONTRIBUTOR

ds = xr.open_dataset(grid_dir_nc+'Depth.nc', chunks={'face':1}, engine='h5netcdf') % time print(ds.Depth.mean().values) leads to: CPU times: user 824 ms, sys: 50.4 ms, total: 875 ms Wall time: 11.3 s and ds = xr.open_dataset(grid_dir_nc+'Depth.nc', chunks={'face':1}).load() % time print(ds.Depth.mean().values) to CPU times: user 61.9 ms, sys: 22.4 ms, total: 84.3 ms Wall time: 76.2 ms much better ... thanks a lot for these two solutions.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  isel slows down computation significantly after open_dataset 373449569
432672506 https://github.com/pydata/xarray/issues/2504#issuecomment-432672506 https://api.github.com/repos/pydata/xarray/issues/2504 MDEyOklzc3VlQ29tbWVudDQzMjY3MjUwNg== apatlpo 11750960 2018-10-24T14:08:07Z 2018-10-24T14:08:07Z CONTRIBUTOR

additional information about the file:

``` (equinox) [pontea@visu01 LLC4320]$ ncdump -sh grid_nc/Depth.nc netcdf Depth { dimensions: i = 4320 ; j = 4320 ; face = 13 ; variables: int64 i(i) ; i:standard_name = "x_grid_index" ; i:axis = "X" ; i:long_name = "x-dimension of the t grid" ; i:swap_dim = "XC" ; i:_Storage = "contiguous" ; i:_Endianness = "little" ; int64 j(j) ; j:standard_name = "y_grid_index" ; j:axis = "Y" ; j:long_name = "y-dimension of the t grid" ; j:swap_dim = "YC" ; j:_Storage = "contiguous" ; j:_Endianness = "little" ; int64 face(face) ; face:standard_name = "face_index" ; face:_Storage = "contiguous" ; face:_Endianness = "little" ; float Depth(face, j, i) ; Depth:_FillValue = NaNf ; Depth:standard_name = "ocean_depth" ; Depth:long_name = "ocean depth" ; Depth:units = "m" ; Depth:coordinate = "XC YC" ; Depth:_Storage = "chunked" ; Depth:_ChunkSizes = 1, 480, 480 ; Depth:_Endianness = "little" ;

// global attributes: :_SuperblockVersion = 0 ; :_IsNetcdf4 = 1 ; :_Format = "netCDF-4" ; } ```

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  isel slows down computation significantly after open_dataset 373449569

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