issue_comments

Table actions

3 rows where issue = 778863478 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

  • Conversions to Pandas objects fail when mixtures of Index and MultiIndex are present · 3 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
869042934 https://github.com/pydata/xarray/issues/4765#issuecomment-869042934 https://api.github.com/repos/pydata/xarray/issues/4765 MDEyOklzc3VlQ29tbWVudDg2OTA0MjkzNA== max-sixty 5635139 2021-06-26T18:24:46Z 2021-06-26T18:24:46Z MEMBER

I think this does work now?

```python

In [3]: da.stack(xy=['x', 'y']).to_series() Out[3]: z x y z1 x1 y1 2 y2 5 y3 6 x2 y1 0 y2 7 y3 1 x3 y1 4 ```

@carlos-rpg you may have also been looking for to_pandas or to_dataframe.

Closing but please reopen if I'm mistaken!

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Conversions to Pandas objects fail when mixtures of Index and MultiIndex are present 778863478
755190063 https://github.com/pydata/xarray/issues/4765#issuecomment-755190063 https://api.github.com/repos/pydata/xarray/issues/4765 MDEyOklzc3VlQ29tbWVudDc1NTE5MDA2Mw== carlos-rpg 34008825 2021-01-06T09:33:11Z 2021-01-06T13:45:01Z NONE

I think that works as intended, although the error message could definitely be better.

Series is limited to 1D arrays, so we have to convert DataArray objects with more than one dimension using stack. If the object already has a MultiIndex this fails because we don't support da.stack(xy=['x', 'y']).stack(xyz=['xy', 'z']).

It's a pity because having a partial MultiIndex DataArray helps a lot if there are lots of combinations of x and y with NA values. My reason to transfort into a pandas object is that I need to groupby by 3 dimensions.

EDIT: I have found a strange workaround: da.stack(xy=['x', 'y']).to_dask_dataframe().compute()

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Conversions to Pandas objects fail when mixtures of Index and MultiIndex are present 778863478
754781227 https://github.com/pydata/xarray/issues/4765#issuecomment-754781227 https://api.github.com/repos/pydata/xarray/issues/4765 MDEyOklzc3VlQ29tbWVudDc1NDc4MTIyNw== keewis 14808389 2021-01-05T17:29:10Z 2021-01-05T17:29:10Z MEMBER

I think that works as intended, although the error message could definitely be better.

Series is limited to 1D arrays, so we have to convert DataArray objects with more than one dimension using stack. If the object already has a MultiIndex this fails because we don't support da.stack(xy=['x', 'y']).stack(xyz=['xy', 'z']).

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Conversions to Pandas objects fail when mixtures of Index and MultiIndex are present 778863478

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