issue_comments

Table actions

5 rows where issue = 666880880 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

author_association 3

issue 1

  • Skipna not working in DataArray.rolling.mean · 5 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
1237976138 https://github.com/pydata/xarray/issues/4278#issuecomment-1237976138 https://api.github.com/repos/pydata/xarray/issues/4278 IC_kwDOAMm_X85JygRK salonisheth-1 104776745 2022-09-06T10:39:02Z 2022-09-06T10:39:02Z NONE

I basically want to implement min_periods=1, but I don't want to ignore NAs. If even one of the values is NAN, I want the rolling mean to give me NAN as the result. 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Skipna not working in DataArray.rolling.mean  666880880
1237974853 https://github.com/pydata/xarray/issues/4278#issuecomment-1237974853 https://api.github.com/repos/pydata/xarray/issues/4278 IC_kwDOAMm_X85Jyf9F salonisheth-1 104776745 2022-09-06T10:37:41Z 2022-09-06T10:37:41Z NONE

What if I wanted to keep skipna=False, is there a workaround for that? 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Skipna not working in DataArray.rolling.mean  666880880
665604427 https://github.com/pydata/xarray/issues/4278#issuecomment-665604427 https://api.github.com/repos/pydata/xarray/issues/4278 MDEyOklzc3VlQ29tbWVudDY2NTYwNDQyNw== mark-boer 12862013 2020-07-29T11:17:23Z 2020-07-29T11:17:23Z CONTRIBUTOR

I'll close this issue. Thank you @dcherian. I will have another look at the docs and if anything remains unclear, I'll have a look at adding a note or example.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Skipna not working in DataArray.rolling.mean  666880880
665312413 https://github.com/pydata/xarray/issues/4278#issuecomment-665312413 https://api.github.com/repos/pydata/xarray/issues/4278 MDEyOklzc3VlQ29tbWVudDY2NTMxMjQxMw== mark-boer 12862013 2020-07-28T22:17:34Z 2020-07-28T22:17:34Z CONTRIBUTOR

Oh good point, after reading the docs, I thought that the min_periods was only related to the edges of the array. 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Skipna not working in DataArray.rolling.mean  666880880
665084013 https://github.com/pydata/xarray/issues/4278#issuecomment-665084013 https://api.github.com/repos/pydata/xarray/issues/4278 MDEyOklzc3VlQ29tbWVudDY2NTA4NDAxMw== dcherian 2448579 2020-07-28T14:46:10Z 2020-07-28T14:46:10Z MEMBER

the answer is to specify min_periods in rolling(): https://xarray.pydata.org/en/stable/generated/xarray.core.rolling.DataArrayRolling.html

It would be nice to allow skipna if min_periods is None but that might be become confusing.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Skipna not working in DataArray.rolling.mean  666880880

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