issue_comments

Table actions

5 rows where issue = 547680465 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

user 3

author_association 2

issue 1

  • Feature request: How Do I add a new variable to a data set? · 5 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
573108272 https://github.com/pydata/xarray/issues/3678#issuecomment-573108272 https://api.github.com/repos/pydata/xarray/issues/3678 MDEyOklzc3VlQ29tbWVudDU3MzEwODI3Mg== rpgoldman 3274 2020-01-10T16:34:02Z 2020-01-10T16:34:02Z CONTRIBUTOR

@mathause Thank you! That never occurred to me.

I thought it was something wrong with the way I was using conjunction, but now I believe it was just a matter of operator precedence.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Feature request: How Do I add a new variable to a data set? 547680465
572926797 https://github.com/pydata/xarray/issues/3678#issuecomment-572926797 https://api.github.com/repos/pydata/xarray/issues/3678 MDEyOklzc3VlQ29tbWVudDU3MjkyNjc5Nw== mathause 10194086 2020-01-10T08:27:10Z 2020-01-10T08:27:10Z MEMBER

You can shorthen this using parantheses and &:

python sel = (other_data_array['bar'] == 12) & (other_data_array['baz'] < 22) foo = data_array.where(sel)

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Feature request: How Do I add a new variable to a data set? 547680465
572744391 https://github.com/pydata/xarray/issues/3678#issuecomment-572744391 https://api.github.com/repos/pydata/xarray/issues/3678 MDEyOklzc3VlQ29tbWVudDU3Mjc0NDM5MQ== rpgoldman 3274 2020-01-09T20:38:35Z 2020-01-09T20:38:35Z CONTRIBUTOR

@dcherian I know it's kind of overloading this issue, but if you would also LMK if there's a clean way to do compound querying, the way one can in Pandas, I will also put in something about that.

foo = data_array.where(np.logical_and(other_data_array['bar'] == 12, other_data_array['baz'] < 22))

...is all I have come up with and this gets bloated and unreadable really quickly if there are multiple conjuncts. Infix conjunction seems not to work unless I take the .values of the data array subsets, which adds its own layer of bloat.

I figure this is something that lots of people will want to do, but it seems a lot harder than pd.DataFrame.query()

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Feature request: How Do I add a new variable to a data set? 547680465
572742682 https://github.com/pydata/xarray/issues/3678#issuecomment-572742682 https://api.github.com/repos/pydata/xarray/issues/3678 MDEyOklzc3VlQ29tbWVudDU3Mjc0MjY4Mg== rpgoldman 3274 2020-01-09T20:33:54Z 2020-01-09T20:33:54Z CONTRIBUTOR

OK, done. Per my comments, I don't have the ability to build and check the sphinx code, so please check before merging.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Feature request: How Do I add a new variable to a data set? 547680465
572723468 https://github.com/pydata/xarray/issues/3678#issuecomment-572723468 https://api.github.com/repos/pydata/xarray/issues/3678 MDEyOklzc3VlQ29tbWVudDU3MjcyMzQ2OA== dcherian 2448579 2020-01-09T19:44:15Z 2020-01-09T19:44:15Z MEMBER

ds["name"] = data_array Also see Dataset.assign

A pull request would be very welcome!

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Feature request: How Do I add a new variable to a data set? 547680465

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