issue_comments

Table actions

2 rows where author_association = "NONE" and user = 5793360 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

  • karl-malakoff · 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
483610759 https://github.com/pydata/xarray/issues/2899#issuecomment-483610759 https://api.github.com/repos/pydata/xarray/issues/2899 MDEyOklzc3VlQ29tbWVudDQ4MzYxMDc1OQ== karl-malakoff 5793360 2019-04-16T10:51:26Z 2019-04-16T10:51:26Z NONE

Actually the work around I mentioned won't work as it's changing the variables type to string.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Explicit fixed width 'S1' arrays re-encoded creating extra dimension 433703713
460890400 https://github.com/pydata/xarray/issues/2742#issuecomment-460890400 https://api.github.com/repos/pydata/xarray/issues/2742 MDEyOklzc3VlQ29tbWVudDQ2MDg5MDQwMA== karl-malakoff 5793360 2019-02-06T03:36:13Z 2019-02-06T03:36:13Z NONE

Thanks for the response.

The file is now available here: http://www.marine.csiro.au/cgi-bin/marlin-dl/Investigator_NF/in2018_v06/data/in2018_v06_ADCP_nc.zip

I used the one titled 'in2018_v06_os150nb.nc' in my examples but both files display the same behaviour.

The output from xarray.show_versions() is below:

INSTALLED VERSIONS

commit: None python: 3.6.1 |Anaconda custom (64-bit)| (default, May 11 2017, 13:25:24) [MSC v.1900 64 bit (AMD64)] python-bits: 64 OS: Windows OS-release: 10 machine: AMD64 processor: Intel64 Family 6 Model 94 Stepping 3, GenuineIntel byteorder: little LC_ALL: None LANG: None LOCALE: None.None libhdf5: 1.10.3 libnetcdf: 4.6.1

xarray: 0.11.3 pandas: 0.23.0 numpy: 1.14.2 scipy: 0.19.0 netCDF4: 1.4.2 pydap: None h5netcdf: None h5py: None Nio: None zarr: None cftime: 1.0.0b1 PseudonetCDF: None rasterio: None cfgrib: None iris: None bottleneck: 1.2.1 cyordereddict: None dask: 0.17.2 distributed: 1.21.4 matplotlib: 2.0.2 cartopy: 0.16.0 seaborn: 0.7.1 setuptools: 40.6.3 pip: 19.0.1 conda: 4.5.11 pytest: 3.0.7 IPython: 7.2.0 sphinx: 1.5.6

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   handle default fill value 406612733

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