issue_comments

Table actions

2 rows where author_association = "MEMBER", issue = 1631491844 and user = 5821660 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

  • kmuehlbauer · 2 ✖

issue 1

  • merge · 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
1527544656 https://github.com/pydata/xarray/issues/7647#issuecomment-1527544656 https://api.github.com/repos/pydata/xarray/issues/7647 IC_kwDOAMm_X85bDHtQ kmuehlbauer 5821660 2023-04-28T13:12:08Z 2023-04-28T13:12:08Z MEMBER

@wangshuaicumt Did you get along with this issue? If this is still unresolved it would be great if you could provide the data or a MCVE.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   merge 1631491844
1475743002 https://github.com/pydata/xarray/issues/7647#issuecomment-1475743002 https://api.github.com/repos/pydata/xarray/issues/7647 IC_kwDOAMm_X85X9g0a kmuehlbauer 5821660 2023-03-20T07:27:08Z 2023-03-20T07:27:08Z MEMBER

@wangshuaicumt To see what's going on this might be sufficient. It looks like the grids (or dimensions) of your two input datasets do not really match each other.

In consequence the merge-algorithm aligns the two inputs and introduces NaN at the places where the data is not defined at the resulting points, leaving you with these gaps in the output. (You can observe this in the dimension-sizes).

As this doesn't happen in my workflows I have no immediate help at hand and hope others will chime with some more guidance.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   merge 1631491844

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