issue_comments

Table actions

4 rows where issue = 596115014 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

author_association 2

issue 1

  • series.to_xarray() fails when MultiIndex not sorted in xarray 0.15.1 · 4 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
610615886 https://github.com/pydata/xarray/issues/3951#issuecomment-610615886 https://api.github.com/repos/pydata/xarray/issues/3951 MDEyOklzc3VlQ29tbWVudDYxMDYxNTg4Ng== fujiisoup 6815844 2020-04-07T20:56:07Z 2020-04-07T20:56:07Z MEMBER

Thanks, @delgadom, for reporting this issue. Reproduced.

I'll take a look.

 
{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   series.to_xarray() fails when MultiIndex not sorted in xarray 0.15.1 596115014
610615488 https://github.com/pydata/xarray/issues/3951#issuecomment-610615488 https://api.github.com/repos/pydata/xarray/issues/3951 MDEyOklzc3VlQ29tbWVudDYxMDYxNTQ4OA== delgadom 3698640 2020-04-07T20:55:11Z 2020-04-07T20:55:11Z CONTRIBUTOR

Here's a test script I'm using for this:

```bash

echo '$ conda create -n py37xr14 -c conda-forge --yes python=3.7 xarray=0.14.1' conda create -n py37xr14 -c conda-forge --yes python=3.7 xarray=0.14.1 > /dev/null

echo '$ conda create -n py37xr15 -c conda-forge --yes python=3.7 xarray=0.15.1' conda create -n py37xr15 -c conda-forge --yes python=3.7 xarray=0.15.1 > /dev/null

echo '$ conda run -n py37xr14 python test.py' conda run -n py37xr14 python test.py

echo

echo '$ conda run -n py37xr15 python test.py' conda run -n py37xr15 python test.py

echo echo '$ conda list -n py37xr14' conda list -n py37xr14

echo echo '$ conda list -n py37xr15' conda list -n py37xr15

conda env remove -n py37xr14 > /dev/null 2>&1 conda env remove -n py37xr15 > /dev/null 2>&1 ```

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   series.to_xarray() fails when MultiIndex not sorted in xarray 0.15.1 596115014
610612332 https://github.com/pydata/xarray/issues/3951#issuecomment-610612332 https://api.github.com/repos/pydata/xarray/issues/3951 MDEyOklzc3VlQ29tbWVudDYxMDYxMjMzMg== delgadom 3698640 2020-04-07T20:47:51Z 2020-04-07T20:47:51Z CONTRIBUTOR

yeah I use this pattern all the time - df.stack().to_xarray() seems to now fail unless your columns were sorted alphabetically. not sure yet where this is happening but it does result in some pernicious bad data errors that can be hard to debug if you catch them at all.

 
{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   series.to_xarray() fails when MultiIndex not sorted in xarray 0.15.1 596115014
610598791 https://github.com/pydata/xarray/issues/3951#issuecomment-610598791 https://api.github.com/repos/pydata/xarray/issues/3951 MDEyOklzc3VlQ29tbWVudDYxMDU5ODc5MQ== max-sixty 5635139 2020-04-07T20:17:24Z 2020-04-07T20:17:24Z MEMBER

Thanks for the issue @delgadom . This looks like a fairly significant bug. I'll try and look more at it later; if anyone else can @pydata/xarray that would be great.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   series.to_xarray() fails when MultiIndex not sorted in xarray 0.15.1 596115014

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