home / github

Menu
  • Search all tables
  • GraphQL API

issue_comments

Table actions
  • GraphQL API for issue_comments

10 rows where user = 44284270 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

issue 5

  • selecting only october to march from monthly data using xarray 3
  • applying ufunc over lon and lat 3
  • rolling count not working 2
  • Error when oppening netcdf file with open_mfdataset 1
  • apply rolling window on function 1

user 1

  • mada0007 · 10 ✖

author_association 1

  • NONE 10
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
570034606 https://github.com/pydata/xarray/issues/3656#issuecomment-570034606 https://api.github.com/repos/pydata/xarray/issues/3656 MDEyOklzc3VlQ29tbWVudDU3MDAzNDYwNg== mada0007 44284270 2020-01-01T08:44:22Z 2020-01-01T08:44:22Z NONE

@ Kewis I tried to look into the numpy mean function to no avail. Could you please provide further guidance?

Cheers,

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  apply rolling window on function 543825272
566392514 https://github.com/pydata/xarray/issues/3632#issuecomment-566392514 https://api.github.com/repos/pydata/xarray/issues/3632 MDEyOklzc3VlQ29tbWVudDU2NjM5MjUxNA== mada0007 44284270 2019-12-17T05:51:07Z 2019-12-17T05:51:07Z NONE

I found the solution, apparent results is stored as a list event thought its just a single number and then the program interprets this as having more than one element which cant be store in output.

Solution was to convert results into numpy array in the original code and then it works.

The code is still not as fast as I would wish though.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  applying ufunc over lon and lat  538809911
566374680 https://github.com/pydata/xarray/issues/3632#issuecomment-566374680 https://api.github.com/repos/pydata/xarray/issues/3632 MDEyOklzc3VlQ29tbWVudDU2NjM3NDY4MA== mada0007 44284270 2019-12-17T04:24:25Z 2019-12-17T04:24:25Z NONE

I just check the shape of the output is 180 x 360 and results is [0]

output.shape = (180, 360) result = [0]

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  applying ufunc over lon and lat  538809911
566372152 https://github.com/pydata/xarray/issues/3632#issuecomment-566372152 https://api.github.com/repos/pydata/xarray/issues/3632 MDEyOklzc3VlQ29tbWVudDU2NjM3MjE1Mg== mada0007 44284270 2019-12-17T04:11:54Z 2019-12-17T04:11:54Z NONE

hi dcherian, I have tried that without any success. I was how to really apply the unfunc on a function to work over time for a 3D gridded dataset?

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  applying ufunc over lon and lat  538809911
511258189 https://github.com/pydata/xarray/issues/3124#issuecomment-511258189 https://api.github.com/repos/pydata/xarray/issues/3124 MDEyOklzc3VlQ29tbWVudDUxMTI1ODE4OQ== mada0007 44284270 2019-07-15T02:25:27Z 2019-07-15T02:25:27Z NONE

Thanks to all, it works!

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  selecting only october to march from monthly data using xarray 467814673
511208032 https://github.com/pydata/xarray/issues/3124#issuecomment-511208032 https://api.github.com/repos/pydata/xarray/issues/3124 MDEyOklzc3VlQ29tbWVudDUxMTIwODAzMg== mada0007 44284270 2019-07-14T14:35:39Z 2019-07-14T14:35:39Z NONE

Hi, the problem here is that I have multiple netcd files and the dats vary accros time.

is there any other way to do this ?

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  selecting only october to march from monthly data using xarray 467814673
511203557 https://github.com/pydata/xarray/issues/3124#issuecomment-511203557 https://api.github.com/repos/pydata/xarray/issues/3124 MDEyOklzc3VlQ29tbWVudDUxMTIwMzU1Nw== mada0007 44284270 2019-07-14T13:36:50Z 2019-07-14T13:36:50Z NONE

Hi yes except that selected series start are ordered from 1,2,3,10,11,12, 1, 2, 3, 10,11, 12 in that order. what I really want is 10,11,12, 1,2,3 10,11,12,1,2,3 the first 1,2,3 in the data must be igored so from 10,11,12 the next 1,2,3 should start from the following year

Thanks

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  selecting only october to march from monthly data using xarray 467814673
470315634 https://github.com/pydata/xarray/issues/2804#issuecomment-470315634 https://api.github.com/repos/pydata/xarray/issues/2804 MDEyOklzc3VlQ29tbWVudDQ3MDMxNTYzNA== mada0007 44284270 2019-03-06T23:14:26Z 2019-03-06T23:14:26Z NONE

Hi all it worked when I set decode time to False. Thanks for the help

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Error when oppening netcdf file with open_mfdataset 417666040
461717329 https://github.com/pydata/xarray/issues/2755#issuecomment-461717329 https://api.github.com/repos/pydata/xarray/issues/2755 MDEyOklzc3VlQ29tbWVudDQ2MTcxNzMyOQ== mada0007 44284270 2019-02-08T07:42:34Z 2019-02-08T07:52:22Z NONE

Hi all so finally it worked, just for the benefit of others this is how it wents aa = dset.where(dset.precip<50).rolling(time=59).count() this works but brings up a dataset which i then convert to xarray dataset with aa = aa.to_array() Thanks to all for the guidance.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  rolling count not working 408010761
461707837 https://github.com/pydata/xarray/issues/2755#issuecomment-461707837 https://api.github.com/repos/pydata/xarray/issues/2755 MDEyOklzc3VlQ29tbWVudDQ2MTcwNzgzNw== mada0007 44284270 2019-02-08T06:48:24Z 2019-02-08T06:48:24Z NONE

Hi thanks but yes I want something like you have written I tried it and got the following error aa = dset.where(dset.precip<50).rolling(time=59).count('time')

Traceback (most recent call last): File "/Users/mada0007/anaconda3/envs/RAWORK/lib/python3.6/site-packages/IPython/core/interactiveshell.py", line 3267, in run_code exec(code_obj, self.user_global_ns, self.user_ns) File "<ipython-input-102-681874095ab1>", line 1, in <module> aa = dset.where(dset.precip<50).rolling(time=59).count('time') TypeError: rolling_count() takes 1 positional argument but 2 were given

{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  rolling count not working 408010761

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 879.934ms · About: xarray-datasette