issue_comments

Table actions

2 rows where issue = 562075354 and user = 8419157 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

  • DancingQuanta · 2 ✖

issue 1

  • Suggestion: interpolation of non-numerical data · 2 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
583874997 https://github.com/pydata/xarray/issues/3763#issuecomment-583874997 https://api.github.com/repos/pydata/xarray/issues/3763 MDEyOklzc3VlQ29tbWVudDU4Mzg3NDk5Nw== DancingQuanta 8419157 2020-02-09T18:07:00Z 2020-02-09T18:07:00Z NONE

I suggest that in order to convince xarrsy developers to help you is to provide an example data and show what you have tried with your string encoding solution and describe applications for the method. You should check out pandas which xarrsy extends and is more widely used then xarray. Hopefully someone have a similar problem as you with pandas and you can write here how to apply their solutions. 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Suggestion: interpolation of non-numerical data 562075354
583840504 https://github.com/pydata/xarray/issues/3763#issuecomment-583840504 https://api.github.com/repos/pydata/xarray/issues/3763 MDEyOklzc3VlQ29tbWVudDU4Mzg0MDUwNA== DancingQuanta 8419157 2020-02-09T12:39:08Z 2020-02-09T12:39:08Z NONE

Sounds like a technique in data science, encoding strings, which is actually number of different techniques.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Suggestion: interpolation of non-numerical data 562075354

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