issue_comments

Table actions

1 row where author_association = "CONTRIBUTOR", issue = 585323675 and user = 3274 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

  • rpgoldman · 1 ✖

issue 1

  • Explanation of full DataFrame to Dataset translation · 1 ✖

author_association 1

  • CONTRIBUTOR · 1 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
601932932 https://github.com/pydata/xarray/issues/3873#issuecomment-601932932 https://api.github.com/repos/pydata/xarray/issues/3873 MDEyOklzc3VlQ29tbWVudDYwMTkzMjkzMg== rpgoldman 3274 2020-03-20T22:14:37Z 2020-03-20T22:14:37Z CONTRIBUTOR

@keewis -- Yes, that is what I ended up with: making a multi-indexed pandas data array first. But I still think it would be helpful to have this information in some of the tutorial for xarray.

Also, one thing that can happen that could be addressed in this process is a non-unique multi-index. I did this with a set of experimental data, and then .to_xarray() errored out because the multi index was non-unique, which is OK for pandas apparently, but not for xarray.

Note that this isn't necessarily pathological: This happened to me because there was oversampling of some data points in my data set.

So it would be very helpful for the tutorial to address this -- if you have multiple samples at the same point in the condition space, how do you add arbitrary indexing so that you can successfully translate from a data frame with non-unique indexing to an xarray. Is there some way to do this automatically, so we have the equivalent of lat x lon x 0, lat x lon x 1, and so on?

Even the diagnostic process is a bit of a nuisance: import numpy as np foo = filtered.index[np.where(filtered.index.duplicated(False))] foo.sort_values() so it would be nice to have a step-by-step translation guide.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Explanation of full DataFrame to Dataset translation 585323675

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