home / github

Menu
  • Search all tables
  • GraphQL API

issue_comments

Table actions
  • GraphQL API for issue_comments

8 rows where user = 42118783 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

issue 2

  • Set one-dimensional data variable as dimension coordinate? 5
  • Subset from conditional coordinates 3

user 1

  • M-Harrington · 8 ✖

author_association 1

  • NONE 8
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
622006384 https://github.com/pydata/xarray/issues/4013#issuecomment-622006384 https://api.github.com/repos/pydata/xarray/issues/4013 MDEyOklzc3VlQ29tbWVudDYyMjAwNjM4NA== M-Harrington 42118783 2020-04-30T17:51:22Z 2020-04-30T17:51:22Z NONE

Very helpful resources, thank you all!

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Subset from conditional coordinates 608536405
621367736 https://github.com/pydata/xarray/issues/4013#issuecomment-621367736 https://api.github.com/repos/pydata/xarray/issues/4013 MDEyOklzc3VlQ29tbWVudDYyMTM2NzczNg== M-Harrington 42118783 2020-04-29T17:55:06Z 2020-04-29T17:55:54Z NONE

@jthielen is there a better place to ask these questions in the future? I like the the package quite a bit, but sometimes I struggle to answer basic questions like this from the documentation alone (ex: this page could maybe use a few words explaining the examples?). On the other hand I asked here because I wasn't sure how much traction my question would get on stack exchange.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Subset from conditional coordinates 608536405
620833480 https://github.com/pydata/xarray/issues/4013#issuecomment-620833480 https://api.github.com/repos/pydata/xarray/issues/4013 MDEyOklzc3VlQ29tbWVudDYyMDgzMzQ4MA== M-Harrington 42118783 2020-04-28T20:21:05Z 2020-04-28T20:21:05Z NONE

Sounds like this is what I’m looking for, I’ll try it out soon thank you! I wasn’t aware that where had a drop option

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Subset from conditional coordinates 608536405
557325914 https://github.com/pydata/xarray/issues/2461#issuecomment-557325914 https://api.github.com/repos/pydata/xarray/issues/2461 MDEyOklzc3VlQ29tbWVudDU1NzMyNTkxNA== M-Harrington 42118783 2019-11-21T23:57:15Z 2019-11-21T23:57:15Z NONE

Right that's actually desired behavior to begin with so this works out

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Set one-dimensional data variable as dimension coordinate? 366626025
557324294 https://github.com/pydata/xarray/issues/2461#issuecomment-557324294 https://api.github.com/repos/pydata/xarray/issues/2461 MDEyOklzc3VlQ29tbWVudDU1NzMyNDI5NA== M-Harrington 42118783 2019-11-21T23:50:01Z 2019-11-21T23:50:01Z NONE

This worked perfectly, thanks so much!

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Set one-dimensional data variable as dimension coordinate? 366626025
557321322 https://github.com/pydata/xarray/issues/2461#issuecomment-557321322 https://api.github.com/repos/pydata/xarray/issues/2461 MDEyOklzc3VlQ29tbWVudDU1NzMyMTMyMg== M-Harrington 42118783 2019-11-21T23:37:07Z 2019-11-21T23:41:09Z NONE

This also doesn't work feeding y and z as data.y.values and data.z.values which are 1d arrays.

Ultimately merge to another dataset with the same coordinates. Seems like there's something obvious I'm missing here but I haven't been able to figure out what it is.

Ah I see in this example I need a dataset that's 3x3, let me fix the example and see if it's still relevant to my issue

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Set one-dimensional data variable as dimension coordinate? 366626025
557319180 https://github.com/pydata/xarray/issues/2461#issuecomment-557319180 https://api.github.com/repos/pydata/xarray/issues/2461 MDEyOklzc3VlQ29tbWVudDU1NzMxOTE4MA== M-Harrington 42118783 2019-11-21T23:29:52Z 2019-11-21T23:30:31Z NONE

@dcherian not quite because I want z and y to both have the star next to them (or bolded in your screenshot) so that they're proper coordinates. I likewise thought that the answer would be as simple as:

data=pd.DataFrame({'x': [0, 1, 2], 'y': ['a', 'b', 'c'],'z': ['a', 'b', 'c']}) xr.DataArray(data.x, coords={'y': data.y, 'x':data.z})

But again, I haven't gotten anywhere this way either and getting the error ValueError: coordinate y has dimensions ('y',), but these are not a subset of the DataArray dimensions ('dim_0',)

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Set one-dimensional data variable as dimension coordinate? 366626025
557312857 https://github.com/pydata/xarray/issues/2461#issuecomment-557312857 https://api.github.com/repos/pydata/xarray/issues/2461 MDEyOklzc3VlQ29tbWVudDU1NzMxMjg1Nw== M-Harrington 42118783 2019-11-21T23:06:34Z 2019-11-21T23:07:32Z NONE

@fujiisoup This method works when trying to add a single coordinate, but what about when you're trying to add multiple coordinates? Example:

``` import xarray as xr ds = xr.Dataset({'x': ('i', [0, 1, 2]), 'y': ('i', ['a', 'b', 'c']),'z': ('i', ['a', 'b', 'c'])}) ds= ds.set_coords(['y','z']) ds.swap_dims({'i':'y','i':'z'}) #doesn't work

ds = xr.Dataset({'x': ('i', [0, 1, 2]), 'y': ('i', ['a', 'b', 'c']),'z': ('i', ['a', 'b', 'c'])}) ds= ds.set_coords('y') ds=ds.swap_dims({'i':'y'}) ds.set_coords('z') #doesn't work either ```

Is there any reason that this is the default behavior? This is a bit frustrating to work with after creating an xarray dataset from pandas.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Set one-dimensional data variable as dimension coordinate? 366626025

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]);
Powered by Datasette · Queries took 964.193ms · About: xarray-datasette