issue_comments

Table actions

3 rows where author_association = "MEMBER", issue = 1120583442 and user = 1217238 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: author_association, issue

user 1

  • shoyer · 3 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
1032051447 https://github.com/pydata/xarray/issues/6230#issuecomment-1032051447 https://api.github.com/repos/pydata/xarray/issues/6230 IC_kwDOAMm_X849g9r3 shoyer 1217238 2022-02-07T23:40:48Z 2022-02-07T23:40:48Z MEMBER

In the long term (cc @benbovy) I think we would ideally split IndexVariable into two classes:

  1. FrozenVariable which is just an immutable Variable, and thus that can be safely used for coordinates that have indexes.
  2. PandasIndexArray which wraps pandas.Index objects to satisfy the np.ndarray interface. This is the object which could allow duck_array_ops.isin to use the pandas.Index.isin method.
 
{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   [PERFORMANCE]: `isin` on `CFTimeIndex`-backed `Coordinate` slow  1120583442
1031811347 https://github.com/pydata/xarray/issues/6230#issuecomment-1031811347 https://api.github.com/repos/pydata/xarray/issues/6230 IC_kwDOAMm_X849gDET shoyer 1217238 2022-02-07T19:01:54Z 2022-02-07T19:01:54Z MEMBER

Oh, I guess the challenge is that apply_ufunc operates on arrays, not indexes. I'm not entirely sure how to deal with this easily....

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   [PERFORMANCE]: `isin` on `CFTimeIndex`-backed `Coordinate` slow  1120583442
1031810590 https://github.com/pydata/xarray/issues/6230#issuecomment-1031810590 https://api.github.com/repos/pydata/xarray/issues/6230 IC_kwDOAMm_X849gC4e shoyer 1217238 2022-02-07T19:01:08Z 2022-02-07T19:01:08Z MEMBER

Yes, I think replacing this with something like lambda x, y: x.isin(y) if isinstance(x, pd.Index) else np.isin(x, y) could work

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   [PERFORMANCE]: `isin` on `CFTimeIndex`-backed `Coordinate` slow  1120583442

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