issue_comments

Table actions

2 rows where author_association = "MEMBER", issue = 257070215 and user = 5635139 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

  • max-sixty · 2 ✖

issue 1

  • Grouping with multiple levels · 2 ✖

author_association 1

  • MEMBER · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
1094066748 https://github.com/pydata/xarray/issues/1569#issuecomment-1094066748 https://api.github.com/repos/pydata/xarray/issues/1569 IC_kwDOAMm_X85BNiI8 max-sixty 5635139 2022-04-09T15:25:06Z 2022-04-09T15:25:06Z MEMBER

The example above is now fixed:

```python

In [1]: ds=xr.Dataset(dict(a=(('z',), np.ones(10))), coords=dict(b=(('z'),np.arange(2).repeat(5)), c=(('z'),np.arange(5).repeat(2)))) ...:

In [2]: ds.set_index(bc=['b','c']).groupby('bc').sum() Out[2]: <xarray.Dataset> Dimensions: (bc: 6, z: 10) Coordinates: * bc (bc) object MultiIndex * b (bc) int64 0 0 0 1 1 1 * c (bc) int64 0 1 2 2 3 4 Dimensions without coordinates: z Data variables: a (bc, z) float64 1.0 1.0 1.0 1.0 1.0 1.0 ... 1.0 1.0 1.0 1.0 1.0 1.0 # <- correct ```

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Grouping with multiple levels 257070215
393345152 https://github.com/pydata/xarray/issues/1569#issuecomment-393345152 https://api.github.com/repos/pydata/xarray/issues/1569 MDEyOklzc3VlQ29tbWVudDM5MzM0NTE1Mg== max-sixty 5635139 2018-05-30T22:52:38Z 2018-05-30T22:52:38Z MEMBER

Are we making silent mistakes at the moment?

```python

In [1]: import xarray as xr In [2]: import pandas as pd

In [4]: import numpy as np

In [5]: ds=xr.Dataset(dict(a=(('z',), np.ones(10))), coords=dict(b=(('z'),np.arange(2).repeat(5)), c=(('z'),np.arange(5).repeat(2))))

In [6]: ds Out[6]: <xarray.Dataset> Dimensions: (z: 10) Coordinates: b (z) int64 0 0 0 0 0 1 1 1 1 1 c (z) int64 0 0 1 1 2 2 3 3 4 4 Dimensions without coordinates: z Data variables: a (z) float64 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

In [7]: ds.set_index(bc=['b','c']).groupby('bc').sum() Out[7]: <xarray.Dataset> Dimensions: (bc: 6) Coordinates: * bc (bc) MultiIndex - bc_level_0 (bc) int64 0 0 0 1 1 1 - bc_level_1 (bc) int64 0 1 2 2 3 4 Data variables: a (bc) float64 10.0 10.0 10.0 10.0 10.0 10.0 # <--- this is wrong? ```

With a DataArray, we do raise:

```python In [19]: ds['a'].set_index(bc=['b','c']) Out[19]: <xarray.DataArray 'a' (z: 10)> array([1., 1., 1., 1., 1., 1., 1., 1., 1., 1.]) Coordinates: * bc (bc) MultiIndex - b (bc) int64 0 0 0 0 0 1 1 1 1 1 - c (bc) int64 0 0 1 1 2 2 3 3 4 4 Dimensions without coordinates: z

In [20]: ds['a'].set_index(bc=['b','c']).groupby('bc')

KeyError Traceback (most recent call last) <ipython-input-20-82bf6782525c> in <module>() ----> 1 ds['a'].set_index(bc=['b','c']).groupby('bc')

/usr/local/lib/python3.6/site-packages/xarray/core/common.py in groupby(self, group, squeeze) 472 core.groupby.DatasetGroupBy 473 """ --> 474 return self._groupby_cls(self, group, squeeze=squeeze) 475 476 def groupby_bins(self, group, bins, right=True, labels=None, precision=3,

/usr/local/lib/python3.6/site-packages/xarray/core/groupby.py in init(self, obj, group, squeeze, grouper, bins, cut_kwargs) 213 group_dim, = group.dims 214 --> 215 expected_size = obj.sizes[group_dim] 216 if group.size != expected_size: 217 raise ValueError('the group variable\'s length does not '

/usr/local/lib/python3.6/site-packages/xarray/core/utils.py in getitem(self, key) 306 307 def getitem(self, key): --> 308 return self.mapping[key] 309 310 def iter(self):

KeyError: 'bc' ```

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Grouping with multiple levels 257070215

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