title | author | date | output | ||||
---|---|---|---|---|---|---|---|
Reprex: rendering fails or incomplete for list of pointblank tables in rmarkdown documents |
Elliot Gould |
08/03/2021 |
|
data("small_table")df <- tibble(id = c(1,2), data = list(small_table))validate_small_table <- function(data){ al <- action_levels(warn_at = 0.1, stop_at = 0.2)
agent <- create_agent( tbl = small_table, tbl_name = "small_table", label = "VALID-I Example No. 2", actions = al ) %>% col_is_posix(vars(date_time),label = "check that date_time col is posix") %>% col_vals_in_set(vars(f), set = c("low", "mid")) %>% col_vals_lt(vars(a), value = 7) %>% col_vals_regex(vars(b), regex = "^[0-9]-[a-w]{3}-[2-9]{3}$") %>% col_vals_between(vars(d), left = 0, right = 4000) %>% interrogate()
return(agent) }validate_small_table(small_table)<style>@import url("https://fonts.googleapis.com/css2?family=IBM+Plex+Sans:ital,wght@0,100;0,200;0,300;0,400;0,500;0,600;0,700;0,800;0,900;1,100;1,200;1,300;1,400;1,500;1,600;1,700;1,800;1,900&display=swap"); @import url("https://unpkg.com/balloon-css/balloon.min.css"); html { font-family: 'IBM Plex Sans', -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, 'Helvetica Neue', 'Fira Sans', 'Droid Sans', Arial, sans-serif; }
#pb_agent .gt_table { display: table; border-collapse: collapse; margin-left: auto; margin-right: auto; color: #333333; font-size: 90%; font-weight: normal; font-style: normal; background-color: #FFFFFF; width: auto; border-top-style: solid; border-top-width: 2px; border-top-color: #A8A8A8; border-right-style: none; border-right-width: 2px; border-right-color: #D3D3D3; border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #A8A8A8; border-left-style: none; border-left-width: 2px; border-left-color: #D3D3D3; }
#pb_agent .gt_heading { background-color: #FFFFFF; text-align: center; border-bottom-color: #FFFFFF; border-left-style: none; border-left-width: 1px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 1px; border-right-color: #D3D3D3; }
#pb_agent .gt_title { color: #333333; font-size: 125%; font-weight: initial; padding-top: 4px; padding-bottom: 4px; border-bottom-color: #FFFFFF; border-bottom-width: 0; }
#pb_agent .gt_subtitle { color: #333333; font-size: 85%; font-weight: initial; padding-top: 0; padding-bottom: 4px; border-top-color: #FFFFFF; border-top-width: 0; }
#pb_agent .gt_bottom_border { border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #D3D3D3; }
#pb_agent .gt_col_headings { border-top-style: solid; border-top-width: 2px; border-top-color: #D3D3D3; border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #D3D3D3; border-left-style: none; border-left-width: 1px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 1px; border-right-color: #D3D3D3; }
#pb_agent .gt_col_heading { color: #333333; background-color: #FFFFFF; font-size: 100%; font-weight: normal; text-transform: inherit; border-left-style: none; border-left-width: 1px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 1px; border-right-color: #D3D3D3; vertical-align: bottom; padding-top: 5px; padding-bottom: 6px; padding-left: 5px; padding-right: 5px; overflow-x: hidden; }
#pb_agent .gt_column_spanner_outer { color: #333333; background-color: #FFFFFF; font-size: 100%; font-weight: normal; text-transform: inherit; padding-top: 0; padding-bottom: 0; padding-left: 4px; padding-right: 4px; }
#pb_agent .gt_column_spanner_outer:first-child { padding-left: 0; }
#pb_agent .gt_column_spanner_outer:last-child { padding-right: 0; }
#pb_agent .gt_column_spanner { border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #D3D3D3; vertical-align: bottom; padding-top: 5px; padding-bottom: 6px; overflow-x: hidden; display: inline-block; width: 100%; }
#pb_agent .gt_group_heading { padding: 8px; color: #333333; background-color: #FFFFFF; font-size: 100%; font-weight: initial; text-transform: inherit; border-top-style: solid; border-top-width: 2px; border-top-color: #D3D3D3; border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #D3D3D3; border-left-style: none; border-left-width: 1px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 1px; border-right-color: #D3D3D3; vertical-align: middle; }
#pb_agent .gt_empty_group_heading { padding: 0.5px; color: #333333; background-color: #FFFFFF; font-size: 100%; font-weight: initial; border-top-style: solid; border-top-width: 2px; border-top-color: #D3D3D3; border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #D3D3D3; vertical-align: middle; }
#pb_agent .gt_from_md > :first-child { margin-top: 0; }
#pb_agent .gt_from_md > :last-child { margin-bottom: 0; }
#pb_agent .gt_row { padding-top: 8px; padding-bottom: 8px; padding-left: 5px; padding-right: 5px; margin: 10px; border-top-style: solid; border-top-width: 1px; border-top-color: #D3D3D3; border-left-style: none; border-left-width: 1px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 1px; border-right-color: #D3D3D3; vertical-align: middle; overflow-x: hidden; }
#pb_agent .gt_stub { color: #333333; background-color: #FFFFFF; font-size: 100%; font-weight: initial; text-transform: inherit; border-right-style: solid; border-right-width: 2px; border-right-color: #D3D3D3; padding-left: 12px; }
#pb_agent .gt_summary_row { color: #333333; background-color: #FFFFFF; text-transform: inherit; padding-top: 8px; padding-bottom: 8px; padding-left: 5px; padding-right: 5px; }
#pb_agent .gt_first_summary_row { padding-top: 8px; padding-bottom: 8px; padding-left: 5px; padding-right: 5px; border-top-style: solid; border-top-width: 2px; border-top-color: #D3D3D3; }
#pb_agent .gt_grand_summary_row { color: #333333; background-color: #FFFFFF; text-transform: inherit; padding-top: 8px; padding-bottom: 8px; padding-left: 5px; padding-right: 5px; }
#pb_agent .gt_first_grand_summary_row { padding-top: 8px; padding-bottom: 8px; padding-left: 5px; padding-right: 5px; border-top-style: double; border-top-width: 6px; border-top-color: #D3D3D3; }
#pb_agent .gt_striped { background-color: rgba(128, 128, 128, 0.05); }
#pb_agent .gt_table_body { border-top-style: solid; border-top-width: 2px; border-top-color: #D3D3D3; border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #D3D3D3; }
#pb_agent .gt_footnotes { color: #333333; background-color: #FFFFFF; border-bottom-style: none; border-bottom-width: 2px; border-bottom-color: #D3D3D3; border-left-style: none; border-left-width: 2px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 2px; border-right-color: #D3D3D3; }
#pb_agent .gt_footnote { margin: 0px; font-size: 90%; padding: 4px; }
#pb_agent .gt_sourcenotes { color: #333333; background-color: #FFFFFF; border-bottom-style: none; border-bottom-width: 2px; border-bottom-color: #D3D3D3; border-left-style: none; border-left-width: 2px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 2px; border-right-color: #D3D3D3; }
#pb_agent .gt_sourcenote { font-size: 90%; padding: 4px; }
#pb_agent .gt_left { text-align: left; }
#pb_agent .gt_center { text-align: center; }
#pb_agent .gt_right { text-align: right; font-variant-numeric: tabular-nums; }
#pb_agent .gt_font_normal { font-weight: normal; }
#pb_agent .gt_font_bold { font-weight: bold; }
#pb_agent .gt_font_italic { font-style: italic; }
#pb_agent .gt_super { font-size: 65%; }
#pb_agent .gt_footnote_marks { font-style: italic; font-size: 65%; }
#pb_agent { -webkit-font-smoothing: antialiased; }
#pb_agent .gt_row { overflow: visible; }
#pb_agent .gt_sourcenote { height: 35px; padding: 0; }
#pb_agent code { font-family: 'IBM Plex Mono', monospace, courier; background-color: transparent; padding: 0; } </style>
Pointblank Validation | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
VALID-I Example No. 2
tibble
small_tableWARN
0.10
STOP
0.20
NOTIFY
—
|
|||||||||||||
STEP | COLUMNS | VALUES | TBL | EVAL | ⋅ ⋅ ⋅ | PASS | FAIL | W | S | N | EXT | ||
1 | T check that date_time col is posix
|
|
— | → |
✓ |
1 |
1 1.00 |
0 0.00 |
○ |
○ |
— |
— |
|
2 | col_vals_in_set()
|
|
|
→ |
✓ |
13 |
7 0.54 |
6 0.46 |
● |
● |
— |
CSV
|
|
3 | col_vals_lt()
|
|
|
→ |
✓ |
13 |
11 0.85 |
2 0.15 |
● |
○ |
— |
CSV
|
|
4 | col_vals_regex()
|
|
|
→ |
✓ |
13 |
6 0.46 |
7 0.54 |
● |
● |
— |
CSV
|
|
5 | col_vals_between()
|
|
|
→ |
✓ |
13 |
12 0.92 |
1 0.08 |
● |
○ |
— |
CSV
|
|
2021-03-08 19:24:20 AEDT< 1 s2021-03-08 19:24:20 AEDT |
#pb_agent .gt_table { display: table; border-collapse: collapse; margin-left: auto; margin-right: auto; color: #333333; font-size: 90%; font-weight: normal; font-style: normal; background-color: #FFFFFF; width: auto; border-top-style: solid; border-top-width: 2px; border-top-color: #A8A8A8; border-right-style: none; border-right-width: 2px; border-right-color: #D3D3D3; border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #A8A8A8; border-left-style: none; border-left-width: 2px; border-left-color: #D3D3D3; }
#pb_agent .gt_heading { background-color: #FFFFFF; text-align: center; border-bottom-color: #FFFFFF; border-left-style: none; border-left-width: 1px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 1px; border-right-color: #D3D3D3; }
#pb_agent .gt_title { color: #333333; font-size: 125%; font-weight: initial; padding-top: 4px; padding-bottom: 4px; border-bottom-color: #FFFFFF; border-bottom-width: 0; }
#pb_agent .gt_subtitle { color: #333333; font-size: 85%; font-weight: initial; padding-top: 0; padding-bottom: 4px; border-top-color: #FFFFFF; border-top-width: 0; }
#pb_agent .gt_bottom_border { border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #D3D3D3; }
#pb_agent .gt_col_headings { border-top-style: solid; border-top-width: 2px; border-top-color: #D3D3D3; border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #D3D3D3; border-left-style: none; border-left-width: 1px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 1px; border-right-color: #D3D3D3; }
#pb_agent .gt_col_heading { color: #333333; background-color: #FFFFFF; font-size: 100%; font-weight: normal; text-transform: inherit; border-left-style: none; border-left-width: 1px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 1px; border-right-color: #D3D3D3; vertical-align: bottom; padding-top: 5px; padding-bottom: 6px; padding-left: 5px; padding-right: 5px; overflow-x: hidden; }
#pb_agent .gt_column_spanner_outer { color: #333333; background-color: #FFFFFF; font-size: 100%; font-weight: normal; text-transform: inherit; padding-top: 0; padding-bottom: 0; padding-left: 4px; padding-right: 4px; }
#pb_agent .gt_column_spanner_outer:first-child { padding-left: 0; }
#pb_agent .gt_column_spanner_outer:last-child { padding-right: 0; }
#pb_agent .gt_column_spanner { border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #D3D3D3; vertical-align: bottom; padding-top: 5px; padding-bottom: 6px; overflow-x: hidden; display: inline-block; width: 100%; }
#pb_agent .gt_group_heading { padding: 8px; color: #333333; background-color: #FFFFFF; font-size: 100%; font-weight: initial; text-transform: inherit; border-top-style: solid; border-top-width: 2px; border-top-color: #D3D3D3; border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #D3D3D3; border-left-style: none; border-left-width: 1px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 1px; border-right-color: #D3D3D3; vertical-align: middle; }
#pb_agent .gt_empty_group_heading { padding: 0.5px; color: #333333; background-color: #FFFFFF; font-size: 100%; font-weight: initial; border-top-style: solid; border-top-width: 2px; border-top-color: #D3D3D3; border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #D3D3D3; vertical-align: middle; }
#pb_agent .gt_from_md > :first-child { margin-top: 0; }
#pb_agent .gt_from_md > :last-child { margin-bottom: 0; }
#pb_agent .gt_row { padding-top: 8px; padding-bottom: 8px; padding-left: 5px; padding-right: 5px; margin: 10px; border-top-style: solid; border-top-width: 1px; border-top-color: #D3D3D3; border-left-style: none; border-left-width: 1px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 1px; border-right-color: #D3D3D3; vertical-align: middle; overflow-x: hidden; }
#pb_agent .gt_stub { color: #333333; background-color: #FFFFFF; font-size: 100%; font-weight: initial; text-transform: inherit; border-right-style: solid; border-right-width: 2px; border-right-color: #D3D3D3; padding-left: 12px; }
#pb_agent .gt_summary_row { color: #333333; background-color: #FFFFFF; text-transform: inherit; padding-top: 8px; padding-bottom: 8px; padding-left: 5px; padding-right: 5px; }
#pb_agent .gt_first_summary_row { padding-top: 8px; padding-bottom: 8px; padding-left: 5px; padding-right: 5px; border-top-style: solid; border-top-width: 2px; border-top-color: #D3D3D3; }
#pb_agent .gt_grand_summary_row { color: #333333; background-color: #FFFFFF; text-transform: inherit; padding-top: 8px; padding-bottom: 8px; padding-left: 5px; padding-right: 5px; }
#pb_agent .gt_first_grand_summary_row { padding-top: 8px; padding-bottom: 8px; padding-left: 5px; padding-right: 5px; border-top-style: double; border-top-width: 6px; border-top-color: #D3D3D3; }
#pb_agent .gt_striped { background-color: rgba(128, 128, 128, 0.05); }
#pb_agent .gt_table_body { border-top-style: solid; border-top-width: 2px; border-top-color: #D3D3D3; border-bottom-style: solid; border-bottom-width: 2px; border-bottom-color: #D3D3D3; }
#pb_agent .gt_footnotes { color: #333333; background-color: #FFFFFF; border-bottom-style: none; border-bottom-width: 2px; border-bottom-color: #D3D3D3; border-left-style: none; border-left-width: 2px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 2px; border-right-color: #D3D3D3; }
#pb_agent .gt_footnote { margin: 0px; font-size: 90%; padding: 4px; }
#pb_agent .gt_sourcenotes { color: #333333; background-color: #FFFFFF; border-bottom-style: none; border-bottom-width: 2px; border-bottom-color: #D3D3D3; border-left-style: none; border-left-width: 2px; border-left-color: #D3D3D3; border-right-style: none; border-right-width: 2px; border-right-color: #D3D3D3; }
#pb_agent .gt_sourcenote { font-size: 90%; padding: 4px; }
#pb_agent .gt_left { text-align: left; }
#pb_agent .gt_center { text-align: center; }
#pb_agent .gt_right { text-align: right; font-variant-numeric: tabular-nums; }
#pb_agent .gt_font_normal { font-weight: normal; }
#pb_agent .gt_font_bold { font-weight: bold; }
#pb_agent .gt_font_italic { font-style: italic; }
#pb_agent .gt_super { font-size: 65%; }
#pb_agent .gt_footnote_marks { font-style: italic; font-size: 65%; }
#pb_agent { -webkit-font-smoothing: antialiased; }
#pb_agent .gt_row { overflow: visible; }
#pb_agent .gt_sourcenote { height: 35px; padding: 0; }
#pb_agent code { font-family: 'IBM Plex Mono', monospace, courier; background-color: transparent; padding: 0; } </style>
Pointblank Validation | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
VALID-I Example No. 2
tibble
small_tableWARN
0.10
STOP
0.20
NOTIFY
—
|
|||||||||||||
STEP | COLUMNS | VALUES | TBL | EVAL | ⋅ ⋅ ⋅ | PASS | FAIL | W | S | N | EXT | ||
1 | T check that date_time col is posix
|
|
— | → |
✓ |
1 |
1 1.00 |
0 0.00 |
○ |
○ |
— |
— |
|
2 | col_vals_in_set()
|
|
|
→ |
✓ |
13 |
7 0.54 |
6 0.46 |
● |
● |
— |
CSV
|
|
3 | col_vals_lt()
|
|
|
→ |
✓ |
13 |
11 0.85 |
2 0.15 |
● |
○ |
— |
CSV
|
|
4 | col_vals_regex()
|
|
|
→ |
✓ |
13 |
6 0.46 |
7 0.54 |
● |
● |
— |
CSV
|
|
5 | col_vals_between()
|
|
|
→ |
✓ |
13 |
12 0.92 |
1 0.08 |
● |
○ |
— |
CSV
|
|
2021-03-08 19:24:22 AEDT< 1 s2021-03-08 19:24:22 AEDT |
In the next chunk below, I've set the chunk opt for results
to asis
:
df$result %>% map(get_agent_report) # renders, but not completely[[1]]
[[2]]
Created on 2021-03-08 by the reprex package (v1.0.0)