R client: Add option to display more columns in h2o frame for head/tail

[exalate-issue-sync]

Request: add ncols argument to R's head and tail

Customer would like to view many (1000+) columns for h2o frames. [Support Ticket|https://support.h2o.ai/a/tickets/96103].

In Python, can specify number of columns in head/tail and can scroll through wide table:

{code:python}frame.head(cols=1000){code}

!image-20191211-233323.png|width=1015,height=116!

In R, can display many columns with h2o_frame[:3, 0:1000] but does not pretty visually appealing table.

{noformat}C1 C2 C3 C4 C5 C6 C7 C8 C9 C10 C11 C12 C13 C14 C15 C16 C17 C18 C19 C20 C21
1 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
C22 C23 C24 C25 C26 C27 C28 C29 C30 C31 C32 C33 C34 C35 C36 C37 C38 C39 C40
1 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
C41 C42 C43 C44 C45 C46 C47 C48 C49 C50 C51 C52 C53 C54 C55 C56 C57 C58 C59
1 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
C60 C61 C62 C63 C64 C65 C66 C67 C68 C69 C70 C71 C72 C73 C74 C75 C76 C77 C78
1 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
C79 C80 C81 C82 C83 C84 C85 C86 C87 C88 C89 C90 C91 C92 C93 C94 C95 C96 C97
1 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96
.........{noformat}

h2o.head does not have ncols argument and limits number of cols to display (by omitting with “…”):

!image-20191211-233706.png|width=743,height=89!

[exalate-issue-sync]

Neema Mashayekhi commented: Jan G proposed where the format could be n argument is a vector: {{head(hf, n=c(6, 1000))}}

[exalate-issue-sync]

Zuzana Olajcová commented: All rows of a data frame in a Jupyter notebook with an R kernel can be seen by setting up options repr.matrix.max.rows and repr.matrix.max.cols

i.e. like this:

options(repr.matrix.max.rows=600, repr.matrix.max.cols=200)

The defaults are 60 and 20.

[exalate-issue-sync]

Zuzana Olajcová commented: Resolved in [#4298|https://github.com//pull/4298]

[exalate-issue-sync]

Neema Mashayekhi commented: Created an issue to add new feature to docs: [https://0xdata.atlassian.net/browse/PUBDEV-7328|https://0xdata.atlassian.net/browse/PUBDEV-7328|smart-link]

[h2o-ops]

JIRA Issue Migration Info

Jira Issue: PUBDEV-7136
Assignee: Zuzana Olajcová
Reporter: Neema Mashayekhi
State: Resolved
Fix Version: 3.28.0.4
Attachments: Available (Count: 2)
Development PRs: Available

Linked PRs from JIRA

#4298

Attachments From Jira

Attachment Name: image-20191211-233323.png
Attached By: Neema Mashayekhi
File Link:https://h2o-3-jira-github-migration.s3.amazonaws.com/PUBDEV-7136/image-20191211-233323.png

Attachment Name: image-20191211-233706.png
Attached By: Neema Mashayekhi
File Link:https://h2o-3-jira-github-migration.s3.amazonaws.com/PUBDEV-7136/image-20191211-233706.png