Selectively colouring cells in gt::gt()

100%

Selectively colouring cells in gt::gt()

✓ Published0🌍 Public

Last edited Jan 7, 2020

Created on Jan 7, 2020

This example uses the R package `gt()` to display a data table where individual cells are selectively colored grey, and then a second table where cells are filled with colors from a predefined palette based on a comparison. The code first identifies cells containing "<" characters using `grepl` and applies a uniform grey fill via `tab_style` and `cell_fill`. A more complex workflow melts data frames with `data.table::melt`, merges them with guideline thresholds, and determines which numeric results exceed those thresholds, assigning a color from `RColorBrewer` to each qualifying cell. The `mapply` function iterates over row and column indices to apply the styling individually, producing a table where colored cells highlight values that meet specific criteria. The data is created inline as sample data frames, and the rendering approach relies on the `gt` package's HTML table output.

AI-generated description

Similar vizzes

Loading thumbnail…

Plots in Tables

This example demonstrates how to embed small, arrow-based line charts directly within the cells of a LaTeX table, creating an integrated display of data and its visual summary. The R code uses `ggplot2` to generate four separate horizontal arrow segments (each representing a different x-range on a common scale), saving each as a PNG file with `ggsave`. The `dplyr` and `kableExtra` libraries then build a table where the second column contains LaTeX `\includegraphics` commands, referencing those saved images. The `kbl` function formats the table with `escape = F` to allow the raw LaTeX code, and `column_spec` sets the plot column's width. Overall, it shows a workflow for combining statistical graphics and tabular text in a single rendered document.

JJustinCally

60% match

Loading thumbnail…

TEST - Cell_Table_Integration

This interactive visualization integrates a color-coded model of a cell with a filterable data table. It shows the locations of gene expression within cellular compartments, such as the plasma membrane and cytosol, by mapping the cumulative net differential expression (net_DEG) of user-selected genes to a red-blue color scale. Users can hover over the cell diagram to select specific locations, and the linked table displays gene information, including the number of associated level1 and level2 cellular locations. The application is built with React and uses d3 for SVG rendering, path generation, and data processing, sourcing its data from a provided JSON database and a text file containing the gene list.

PParkhwahwa

60% match

Loading thumbnail…

Table_Cell Integration Trial12_EH

This interactive visualization maps gene expression data onto a stylized diagram of a cell, showing which subcellular locations (e.g., plasma membrane, cytosol) have up- or down-regulated genes. It integrates a treemap of gene ontology categories, a color-coded cell diagram drawn with `d3.line` and `curveCardinal`, and a filterable HTML table. The code uses `d3.scaleSequential` with `interpolateBlues` and `interpolateReds` to color cell regions based on net differential expression values, and transitions animate table row updates.

PParkhwahwa

60% match

Loading thumbnail…

d3v4 - Selective Table

This example presents an interactive table for exploring job-category data across several months, with the data loaded from a TSV file using `d3.queue` and `d3.tsv`. It shows how users can selectively highlight rows and columns by clicking items in two separate lists (jobs and dates), which toggle a `__checked` class and reorder the table’s headers based on click order using `d3.selectAll` and `classed`. The table is rendered with plain HTML elements, and a `__selected` class marks the most recently clicked header.

HHirosaji

59% match

Loading thumbnail…

Theme for publication quality graphs. Modified from https://rpubs.com/Koundy/71792!

This example demonstrates a publication-quality ggplot2 theme with custom fill and color palettes. It shows how to apply a consistent, clean aesthetic—featuring bold axis titles, light gray gridlines, and a horizontal legend—to any plot. The code defines a `theme_Publication_custom` function using `theme_foundation` from `ggthemes` and custom `scale_fill_Publication` and `scale_colour_Publication` functions built on `discrete_scale` and `manual_pal` from `scales`. The theme and palettes are intended for reproducible, polished figures from data frames.

FFloWuenne

59% match

Loading thumbnail…

Gist a5a48620f47ddaa0208a2b226e4ca111

This example shows a deeply nested, table-like data structure where sensory attributes such as “Aparencia” and “Color” are repeatedly wrapped in layers of “No aplica” headers, ultimately ending in the accessor fields `aparencia` and `color`. The visualization presents this hierarchical arrangement as a column-oriented table, using the `columns.json` configuration to define multi-level grouping. The code relies on a generic table-rendering API, likely from a React-based library like `react-table`, which consumes the `columns` array to generate headers and cells. The rendering approach emphasizes the recursive nesting of metadata rather than a direct visual encoding, with no additional JavaScript libraries such as `d3` or animation shown.

EErnestoR

59% match

Loading thumbnail…

Colours Page

This example displays a grid of named CSS colors, each rendered as a rounded rectangle with its name printed in bold text. The visualization uses a static CSV file (`colours2.csv`) containing color names, and the D3.js library to create an SVG element for each entry. The code places each color swatch and label sequentially, using D3’s `select`, `append`, and `attr` methods to build the layout. It also applies a text-shadow class to improve label legibility, and the resulting page is a reference guide for color names usable in web contexts.

Dd3noob

58% match

Loading thumbnail…

Gist 5475820

This example shows a small grid of colored cells tracking how country rankings change over time. The visualization uses a dataset with six countries and seven years (2003–2009), where each cell’s color encodes a rank value from 1 to 6. The code reshapes the data into a flat array of year–country–value triples, then draws SVG rectangles with `d3.select` and `.enter()`. It uses `d3.scale.quantize` for the color scale and `d3.scale.ordinal` for positioning. Hovering turns a cell white, and clicking logs the selected element to the console.

11wheel

58% match