issue_comments

Table actions

3 rows where user = 761677 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

user 1

  • jorgsk · 3 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
1283649453 https://github.com/pydata/xarray/issues/7180#issuecomment-1283649453 https://api.github.com/repos/pydata/xarray/issues/7180 IC_kwDOAMm_X85Mgu-t jorgsk 761677 2022-10-19T08:46:39Z 2022-10-19T08:47:22Z NONE

Thanks @kmuehlbauer! That does give me the same dataset structure as before which can go directly into my pipeline.

However, I'd like to note that the previous method offloaded more of the work to xarray through the API which made the code more clear to understand. It was more explicit since one could specify that concatenation should happen for the time-coordinate, and the post-processor was just one short operation.

If this API will be changed again in the future it's something that could be kept in mind.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   open_mfdataset for merging of netCDF files with different time values 1412846601
329422489 https://github.com/pydata/xarray/issues/1559#issuecomment-329422489 https://api.github.com/repos/pydata/xarray/issues/1559 MDEyOklzc3VlQ29tbWVudDMyOTQyMjQ4OQ== jorgsk 761677 2017-09-14T09:11:50Z 2017-09-14T09:11:50Z NONE

I found that dask was version 0.11 on Windows but 0.15 on Linux. Upgrading the Windows version to 0.15 fixed the issue, indicating that the problem was the version of dask.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Subsetting not reducing memory consumption with mfdataset on Windows 255897797
328008560 https://github.com/pydata/xarray/issues/1559#issuecomment-328008560 https://api.github.com/repos/pydata/xarray/issues/1559 MDEyOklzc3VlQ29tbWVudDMyODAwODU2MA== jorgsk 761677 2017-09-08T06:11:48Z 2017-09-08T06:11:48Z NONE

Sorry about that, I've updated the second snippet. Also added more information in case it helps.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Subsetting not reducing memory consumption with mfdataset on Windows 255897797

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