Data tables in R

Basic

reactable::reactable(df,
                     defaultSorted = list(cut="asc",
                                          avg_price = "desc"
                                          ),
                     searchable = TRUE,
                     bordered = TRUE,
                     highlight = TRUE)

df %>% DT::datatable() %>% 
  formatCurrency(columns="avg_price",
                 currency = "$",
                 digits = 2)

Groupby in the table

reactable::reactable(df, groupBy = "cut",
                     columns = list(
                       avg_price = colDef(
                         aggregate = "mean", 
                         format=colFormat(prefix = "$", 
                                          separators = TRUE,
                                          digits = 2)
                         ),
                       color = colDef(aggregate = "frequency")
                     ),
                     defaultSortOrder = "desc",
                     searchable = TRUE,
                     bordered = TRUE,
                     highlight = TRUE)

data <- data.frame(
  States = state.name,
  Region = state.region,
  Area = state.area
)

reactable(data, groupBy = "Region", columns = list(
  States = colDef(
    aggregate = "count",
    format = list(
      aggregated = colFormat(suffix = " states")
    )
  ),
  Area = colDef(
    aggregate = "sum",
    format = colFormat(suffix = " mi²", separators = TRUE)
  )
))

Embedding HTML widgets

library(sparkline)

data <- chickwts %>%
  group_by(feed) %>%
  summarise(weight = list(weight)) %>%
  mutate(boxplot = NA, sparkline = NA)

## `summarise()` ungrouping output (override with `.groups` argument)

reactable(data, columns = list(
  weight = colDef(cell = function(values) {
    sparkline(values, type = "bar", chartRangeMin = 0, chartRangeMax = max(chickwts$weight))
  }),
  boxplot = colDef(cell = function(value, index) {
    sparkline(data$weight[[index]], type = "box")
  }),
  sparkline = colDef(cell = function(value, index) {
    sparkline(data$weight[[index]])
  })
))

gt tables

# How do I get info on `date_style`s?
info_date_style()

Preset Date Formats
Usable in the fmt_date() and fmt_datetime() functions
Date Formats		Formatted Date
Number	Name
1	iso	2000-02-29
2	wday_month_day_year	Tuesday, February 29, 2000
3	wd_m_day_year	Tue, Feb 29, 2000
4	wday_day_month_year	Tuesday 29 February 2000
5	month_day_year	February 29, 2000
6	m_day_year	Feb 29, 2000
7	day_m_year	29 Feb 2000
8	day_month_year	29 February 2000
9	day_month	29 February
10	year	2000
11	month	February
12	day	29
13	year.mn.day	2000/02/29
14	y.mn.day	00/02/29

# Are there other info tables? Yep:
info_currencies()

Currencies Supported in gt
Currency codes are used in the fmt_currency() function
Identifiers			Exp	Formatted Currency
Currency Name	Currency Code	Currency Number
United Arab Emirates dirham	AED	784	2	DH49.95
Afghan afghani	AFN	971	2	؋49.95
Albanian lek	ALL	8	2	Lek49.95
Armenian dram	AMD	51	2	AMD49.95
Netherlands Antillean guilder	ANG	532	2	NAƒ49.95
Angolan kwanza	AOA	973	2	Kz49.95
Argentine peso	ARS	32	2	$49.95
Australian dollar	AUD	36	2	$49.95
Aruban florin	AWG	533	2	ƒ49.95
Azerbaijani manat	AZN	944	2	₼49.95
Bosnia and Herzegovina convertible mark	BAM	977	2	KM49.95
Barbados dollar	BBD	52	2	$49.95
Bangladeshi taka	BDT	50	2	৳49.95
Bulgarian lev	BGN	975	2	‌лв49.95
Bahraini dinar	BHD	48	3	BD49.950
Burundian franc	BIF	108	0	FBu50
Bermudian dollar	BMD	60	2	$49.95
Brunei dollar	BND	96	2	B$49.95
Boliviano	BOB	68	2	$b49.95
Bolivian Mvdol	BOV	984	2	BOV49.95
Brazilian real	BRL	986	2	R$49.95
Bahamian dollar	BSD	44	2	$49.95
Bhutanese ngultrum	BTN	64	2	Nu.49.95
Botswana pula	BWP	72	2	P49.95
Belarusian ruble	BYR	974	0	p.50
Belize dollar	BZD	84	2	BZ$49.95
Canadian dollar	CAD	124	2	$49.95
Congolese franc	CDF	976	2	FC49.95
WIR Bank	CHE	947	2	CHE49.95
Swiss franc	CHF	756	2	SFr.49.95
WIR Bank	CHW	948	2	CHW49.95
Unidad de Fomento	CLF	990	4	UF49.9500
Chilean peso	CLP	152	0	$50
Renminbi	CNY	156	2	¥49.95
Colombian peso	COP	170	2	$49.95
Unidad de Valor Real	COU	970	2	COU49.95
Costa Rican colon	CRC	188	2	󋼕.95
Cuban convertible peso	CUC	931	2	₱49.95
Cuban peso	CUP	192	2	₱49.95
Cape Verde escudo	CVE	132	0	$50
Czech koruna	CZK	203	2	Kč49.95
Djiboutian franc	DJF	262	0	Fdj50
Danish krone	DKK	208	2	kr.49.95
Dominican peso	DOP	214	2	RD$49.95
Algerian dinar	DZD	12	2	DA49.95
Egyptian pound	EGP	818	2	E£49.95
Eritrean nakfa	ERN	232	2	Nfk49.95
Ethiopian birr	ETB	230	2	Br49.95
Euro	EUR	978	2	€49.95
Fiji dollar	FJD	242	2	FJ$49.95
Falkland Islands pound	FKP	238	2	FK£49.95
Pound sterling	GBP	826	2	£49.95
Georgian lari	GEL	981	2	GEL49.95
Ghanaian cedi	GHS	936	2	₵49.95
Gibraltar pound	GIP	292	2	£49.95
Gambian dalasi	GMD	270	2	D49.95
Guinean franc	GNF	324	0	FG50
Guatemalan quetzal	GTQ	320	2	Q49.95
Guyana dollar	GYD	328	2	GY$49.95
Hong Kong dollar	HKD	344	2	HK$49.95
Honduran lempira	HNL	340	2	L49.95
Croatian kuna	HRK	191	2	kn49.95
Haitian gourde	HTG	332	2	G49.95
Hungarian forint	HUF	348	2	Ft49.95
Indonesian rupiah	IDR	360	2	Rp49.95
Israeli new shekel	ILS	376	2	₪49.95
Isle of Man pound	IMP	NA	2	M£49.95
Indian rupee	INR	356	2	₹49.95
Iraqi dinar	IQD	368	3	ID49.950
Iranian rial	IRR	364	2	﷼49.95
Icelandic krona	ISK	352	0	kr50
Jamaican dollar	JMD	388	2	$49.95
Jordanian dinar	JOD	400	3	JD49.950
Japanese yen	JPY	392	0	¥50
Kenyan shilling	KES	404	2	KSh49.95
Kyrgyzstani som	KGS	417	2	K.S.49.95
Cambodian riel	KHR	116	2	៛49.95
Comoro franc	KMF	174	0	CF50
North Korean won	KPW	408	2	₩49.95
South Korean won	KRW	410	0	₩50
Kuwaiti dinar	KWD	414	3	K.D.49.950
Cayman Islands dollar	KYD	136	2	CI$49.95
Kazakhstani tenge	KZT	398	2	₸49.95
Lao kip	LAK	418	2	₭49.95
Lebanese pound	LBP	422	2	L£49.95
Sri Lankan rupee	LKR	144	2	Rs49.95
Liberian dollar	LRD	430	2	L$49.95
Lesotho loti	LSL	426	2	L49.95
Libyan dinar	LYD	434	3	LD49.950
Moroccan dirham	MAD	504	2	Dh49.95
Moldovan leu	MDL	498	2	MDL49.95
Malagasy ariary	MGA	969	1	Ar50.0
Macedonian denar	MKD	807	2	ден49.95
Myanmar kyat	MMK	104	2	K49.95
Mongolian togrog	MNT	496	2	₮49.95
Macanese pataca	MOP	446	1	MOP$50.0
Mauritanian ouguiya	MRO	478	1	UM50.0
Mauritian rupee	MUR	480	2	Rs49.95
Maldivian rufiyaa	MVR	462	2	Rf49.95
Malawian kwacha	MWK	454	2	MK49.95
Mexican peso	MXN	484	2	Mex$49.95
Mexican Unidad de Inversion	MXV	979	2	MXV49.95
Malaysian ringgit	MYR	458	2	RM49.95
Mozambican metical	MZN	943	2	MT49.95
Namibian dollar	NAD	516	2	N$49.95
Nigerian naira	NGN	566	2	₦49.95
Nicaraguan cordoba	NIO	558	2	C$49.95
Norwegian krone	NOK	578	2	kr49.95
Nepalese rupee	NPR	524	2	Rps49.95
New Zealand dollar	NZD	554	2	$49.95
Omani rial	OMR	512	3	RO49.950
Panamanian balboa	PAB	590	2	B/.49.95
Peruvian Sol	PEN	604	2	S/.49.95
Papua New Guinean kina	PGK	598	2	K49.95
Philippine peso	PHP	608	2	₱49.95
Pakistani rupee	PKR	586	2	Re.49.95
Polish zloty	PLN	985	2	zł49.95
Paraguayan guarani	PYG	600	0	₲50
Qatari riyal	QAR	634	2	QR49.95
Romanian Leu	RON	946	2	RON49.95
Serbian dinar	RSD	941	2	d.49.95
Russian ruble	RUB	643	2	₽49.95
Rwandan franc	RWF	646	0	FRw50
Saudi riyal	SAR	682	2	SR49.95
Solomon Islands dollar	SBD	90	2	SI$49.95
Seychelles rupee	SCR	690	2	SR49.95
Sudanese pound	SDG	938	2	SDG49.95
Swedish krona	SEK	752	2	kr49.95
Singapore dollar	SGD	702	2	S$49.95
Saint Helena pound	SHP	654	2	£49.95
Sierra Leonean leone	SLL	694	2	Le49.95
Somali shilling	SOS	706	2	Sh.So.49.95
Surinamese dollar	SRD	968	2	$49.95
South Sudanese pound	SSP	728	2	SSP49.95
Ṣo Tom̩ and Principe dobra	STD	678	2	Db49.95
Syrian pound	SYP	760	2	S£49.95
Swazi lilangeni	SZL	748	2	L49.95
Thai baht	THB	764	2	฿49.95
Tajikistani somoni	TJS	972	2	TJS49.95
Turkmenistani manat	TMT	934	2	T49.95
Tunisian dinar	TND	788	3	DT49.950
Tongan pa'anga	TOP	776	2	T$49.95
Turkish lira	TRY	949	2	₺49.95
Trinidad and Tobago dollar	TTD	780	2	TT$49.95
New Taiwan dollar	TWD	901	2	NT$49.95
Tanzanian shilling	TZS	834	2	TSh49.95
Ukrainian hryvnia	UAH	980	2	₴49.95
Ugandan shilling	UGX	800	0	USh50
United States dollar	USD	840	2	$49.95
United States dollar	USN	997	2	$49.95
United States dollar	USS	998	2	$49.95
Uruguay Peso en Unidades Indexadas	UYI	940	0	UYI50
Uruguayan peso	UYU	858	2	$U49.95
Uzbekistan som	UZS	860	2	лв49.95
Venezuelan bolivar	VEF	937	2	Bs.49.95
Vietnamese dong	VND	704	0	₫50
Vanuatu vatu	VUV	548	0	VT50
Samoan tala	WST	882	2	WS$49.95
Central African CFA franc	XAF	950	0	FCFA50
Silver	XAG	961	NA	Ag50
Gold	XAU	959	NA	Au50
East Caribbean dollar	XCD	951	2	$49.95
Special drawing rights	XDR	960	NA	XDR50
West African CFA franc	XOF	952	0	F50
Palladium	XPD	964	NA	Pd50
CFP franc	XPF	953	0	F50
Platinum	XPT	962	NA	Pt50
XSU	XSU	994	NA	XSU50
XUA	XUA	965	NA	XUA50
Yemeni rial	YER	886	2	﷼49.95
South African rand	ZAR	710	2	R49.95
Zambian kwacha	ZMW	967	2	K49.95

info_time_style()

Preset Time Formats
Usable in the fmt_time() and fmt_datetime() functions
Time Formats		Formatted Time
Number	Name
1	hms	14:35:00
2	hm	14:35
3	hms_p	2:35:00 PM
4	hm_p	2:35 PM
5	h_p	2 PM

info_paletteer()

Palettes Made Easily Available with paletteer
Palettes like these are useful with the data_color() function
Package and Palette Name		Color Count and Palette
awtools
a_palette	8
bpalette	16
gpalette	4
mpalette	9
spalette	6
dichromat
BrowntoBlue.10	10
BrowntoBlue.12	12
BluetoDarkOrange.12	12
BluetoDarkOrange.18	18
DarkRedtoBlue.12	12
DarkRedtoBlue.18	18
BluetoGreen.14	14
BluetoGray.8	8
BluetoOrangeRed.14	14
BluetoOrange.10	10
BluetoOrange.12	12
BluetoOrange.8	8
LightBluetoDarkBlue.10	10
LightBluetoDarkBlue.7	7
Categorical.12	12
GreentoMagenta.16	16
SteppedSequential.5	25
dutchmasters
milkmaid	13
pearl_earring	11
view_of_Delft	12
little_street	11
anatomy	7
staalmeesters	7
ggsci
nrc_npg	10
default_aaas	10
default_nejm	8
lanonc_lancet	9
default_jama	7
default_jco	10
default_ucscgb	26
category10_d3	10
category20_d3	20
category20b_d3	20
category20c_d3	20
default_igv	51
alternating_igv	2
default_locuszoom	7
default_uchicago	9
light_uchicago	9
dark_uchicago	9
hallmarks_dark_cosmic	10
hallmarks_light_cosmic	10
signature_substitutions_cosmic	6
springfield_simpsons	16
planetexpress_futurama	12
schwifty_rickandmorty	12
uniform_startrek	7
legacy_tron	7
default_gsea	12
red_material	10
pink_material	10
purple_material	10
deep-purple_material	10
indigo_material	10
blue_material	10
light-blue_material	10
cyan_material	10
teal_material	10
green_material	10
light-green_material	10
lime_material	10
yellow_material	10
amber_material	10
orange_material	10
deep-orange_material	10
brown_material	10
grey_material	10
blue-grey_material	10
ggpomological
pomological_base	7
pomological_palette	9
ggthemes
calc	12
manyeys	19
gdoc	10
fivethirtyeight	6
colorblind	8
Tableau 10	10
Tableau 20	20
Color Blind	10
Seattle Grays	5
Traffic	9
Miller Stone	11
Superfishel Stone	10
Nuriel Stone	9
Jewel Bright	9
Summer	8
Winter	10
Green-Orange-Teal	12
Red-Blue-Brown	12
Purple-Pink-Gray	12
Hue Circle	19
Classic 10	10
Classic 10 Medium	10
Classic 10 Light	10
Classic 20	20
Classic Gray 5	5
Classic Color Blind	10
Classic Traffic Light	9
Classic Purple-Gray 6	6
Classic Purple-Gray 12	12
Classic Green-Orange 6	6
Classic Green-Orange 12	12
Classic Blue-Red 6	6
Classic Blue-Red 12	12
Classic Cyclic	13
few_Light	9
few_Medium	9
few_Dark	9
excel_Atlas	6
excel_Badge	6
excel_Berlin	6
excel_Celestial	6
excel_Crop	6
excel_Depth	6
excel_Droplet	6
excel_Facet	6
excel_Feathered	6
excel_Gallery	6
excel_Headlines	6
excel_Integral	6
excel_Ion_Boardroom	6
excel_Ion	6
excel_Madison	6
excel_Main_Event	6
excel_Mesh	6
excel_Office_Theme	6
excel_Organic	6
excel_Parallax	6
excel_Parcel	6
excel_Retrospect	6
excel_Savon	6
excel_Slice	6
excel_Vapor_Trail	6
excel_View	6
excel_Wisp	6
excel_Wood_Type	6
excel_Aspect	6
excel_Blue_Green	6
excel_Blue_II	6
excel_Blue_Warm	6
excel_Blue	6
excel_Grayscale	6
excel_Green_Yellow	6
excel_Green	6
excel_Marquee	6
excel_Median	6
excel_Office_2007-2010	6
excel_Orange_Red	6
excel_Orange	6
excel_Paper	6
excel_Red_Orange	6
excel_Red_Violet	6
excel_Red	6
excel_Slipstream	6
excel_Violet_II	6
excel_Violet	6
excel_Yellow_Orange	6
excel_Yellow	6
wsj_rgby	4
wsj_red_green	2
wsj_black_green	4
wsj_dem_rep	3
wsj_colors6	6
stata_s2color	15
stata_s1rcolor	15
stata_s1color	15
stata_mono	15
stata_economist	15
hc_default	10
hc_darkunica	11
hc_bg	5
hc_fg	12
ghibli
MarnieLight1	7
MarnieMedium1	7
MarnieDark1	7
MarnieLight2	7
MarnieMedium2	7
MarnieDark2	7
PonyoLight	7
PonyoMedium	7
PonyoDark	7
LaputaLight	7
LaputaMedium	7
LaputaDark	7
MononokeLight	7
MononokeMedium	7
MononokeDark	7
SpiritedLight	7
SpiritedMedium	7
SpiritedDark	7
YesterdayLight	7
YesterdayMedium	7
YesterdayDark	7
KikiLight	7
KikiMedium	7
KikiDark	7
TotoroLight	7
TotoroMedium	7
TotoroDark	7
grDevices
blues9	9
jcolors
default	5
pal2	5
pal3	5
pal4	6
pal5	6
pal6	8
pal7	8
pal8	12
pal9	6
pal10	10
pal11	12
pal12	13
rainbow	9
LaCroixColoR
PassionFruit	6
Mango	6
Pure	6
Lime	6
Lemon	6
Orange	6
Berry	6
CranRaspberry	6
Pamplemousse	6
PeachPear	6
Coconut	6
Apricot	6
Tangerine	7
KeyLime	5
PommeBaya	5
CeriseLimon	6
PinaFraise	6
KiwiSandia	7
MelonPomelo	6
MurePepino	6
paired	14
NineteenEightyR
cobra	6
electronic_night	5
hotpink	5
malibu	5
miami1	5
miami2	5
seventies_aint_done_yet	5
sonny	5
sunset1	5
sunset2	5
sunset3	5
youngturqs	12
nord
polarnight	4
snowstorm	3
frost	4
aurora	5
lumina	5
mountain_forms	5
silver_mine	5
lake_superior	6
victory_bonds	5
halifax_harbor	6
moose_pond	8
algoma_forest	7
rocky_mountain	6
red_mountain	8
baie_mouton	7
afternoon_prarie	9
ochRe
namatjira_qual	8
namatjira_div	8
mccrea	11
parliament	8
tasmania	7
nolan_ned	5
winmar	7
olsen_qual	6
olsen_seq	14
williams_pilbara	7
healthy_reef	9
emu_woman_paired	18
galah	6
lorikeet	6
dead_reef	6
jumping_frog	5
palettetown
bulbasaur	13
ivysaur	13
venusaur	14
charmander	13
charmeleon	12
charizard	14
squirtle	14
wartortle	13
blastoise	14
caterpie	12
metapod	5
butterfree	13
weedle	11
kakuna	8
beedrill	14
pidgey	12
pidgeotto	13
pidgeot	14
rattata	13
raticate	13
spearow	15
fearow	12
ekans	12
arbok	10
pikachu	10
raichu	14
sandshrew	10
sandslash	13
nidoranf	11
nidorina	13
nidoqueen	13
nidoranm	10
nidorino	12
nidoking	11
clefairy	13
clefable	12
vulpix	13
ninetales	7
jigglypuff	11
wigglytuff	12
zubat	11
golbat	11
oddish	10
gloom	14
vileplume	13
paras	12
parasect	11
venonat	14
venomoth	11
diglett	4
dugtrio	12
meowth	13
persian	12
psyduck	10
golduck	13
mankey	14
primeape	15
growlithe	11
arcanine	14
poliwag	11
poliwhirl	9
poliwrath	9
abra	8
kadabra	14
alakazam	12
machop	13
machoke	13
machamp	13
bellsprout	13
weepinbell	14
victreebel	14
tentacool	14
tentacruel	14
geodude	6
graveler	6
golem	12
ponyta	11
rapidash	11
slowpoke	12
slowbro	13
magnemite	14
magneton	14
farfetch'd	14
doduo	9
dodrio	15
seel	11
dewgong	7
grimer	9
muk	8
shellder	9
cloyster	9
gastly	8
haunter	10
gengar	10
onix	6
drowzee	9
hypno	9
krabby	10
kingler	10
voltorb	9
electrode	10
exeggcute	9
exeggutor	14
cubone	13
marowak	14
hitmonlee	12
hitmonchan	13
lickitung	9
koffing	12
weezing	13
rhyhorn	8
rhydon	11
chansey	9
tangela	9
kangaskhan	14
horsea	10
seadra	10
goldeen	11
seaking	12
staryu	12
starmie	12
mr. mime	12
scyther	12
jynx	15
electabuzz	10
magmar	12
pinsir	9
tauros	13
magikarp	13
gyarados	15
lapras	15
ditto	6
eevee	9
vaporeon	15
jolteon	11
flareon	10
porygon	11
omanyte	12
omastar	12
kabuto	11
kabutops	9
aerodactyl	7
snorlax	14
articuno	12
zapdos	10
moltres	14
dratini	9
dragonair	12
dragonite	13
mewtwo	9
mew	6
chikorita	11
bayleef	14
meganium	14
cyndaquil	13
quilava	14
typhlosion	14
totodile	11
croconaw	13
feraligatr	14
sentret	12
furret	11
hoothoot	13
noctowl	13
ledyba	12
ledian	14
spinarak	14
ariados	14
crobat	9
chinchou	13
lanturn	14
pichu	11
cleffa	11
igglybuff	9
togepi	12
togetic	11
natu	14
xatu	15
mareep	14
flaaffy	13
ampharos	12
bellossom	13
marill	10
azumarill	10
sudowoodo	11
politoed	14
hoppip	10
skiploom	11
jumpluff	13
aipom	12
sunkern	13
sunflora	12
yanma	11
wooper	9
quagsire	9
espeon	9
umbreon	10
murkrow	12
slowking	13
misdreavus	13
unown	5
wobbuffet	8
girafarig	13
pineco	5
forretress	10
dunsparce	13
gligar	12
steelix	7
snubbull	12
granbull	11
qwilfish	12
scizor	11
shuckle	12
heracross	11
sneasel	14
teddiursa	12
ursaring	13
slugma	9
magcargo	12
swinub	9
piloswine	12
corsola	9
remoraid	9
octillery	12
delibird	13
mantine	13
skarmory	12
houndour	11
houndoom	12
kingdra	12
phanpy	9
donphan	13
porygon2	12
stantler	12
smeargle	12
tyrogue	12
hitmontop	12
smoochum	12
elekid	9
magby	10
miltank	15
blissey	9
raikou	13
entei	14
suicune	14
larvitar	9
pupitar	9
tyranitar	11
lugia	9
ho-oh	13
celebi	11
treecko	14
grovyle	14
sceptile	13
torchic	12
combusken	14
blaziken	14
mudkip	14
marshtomp	14
swampert	14
poochyena	14
mightyena	11
zigzagoon	14
linoone	11
wurmple	13
silcoon	9
beautifly	13
cascoon	8
dustox	14
lotad	13
lombre	12
ludicolo	15
seedot	11
nuzleaf	14
shiftry	13
taillow	15
swellow	15
wingull	14
pelipper	15
ralts	11
kirlia	13
gardevoir	12
surskit	12
masquerain	14
shroomish	11
breloom	15
slakoth	14
vigoroth	15
slaking	14
nincada	15
ninjask	13
shedinja	10
whismur	12
loudred	14
exploud	15
makuhita	12
hariyama	15
azurill	11
nosepass	11
skitty	11
delcatty	15
sableye	13
mawile	14
aron	9
lairon	12
aggron	12
meditite	13
medicham	13
electrike	10
manectric	13
plusle	10
minun	13
volbeat	15
illumise	15
roselia	15
gulpin	11
swalot	14
carvanha	13
sharpedo	14
wailmer	15
wailord	13
numel	15
camerupt	13
torkoal	12
spoink	13
grumpig	15
spinda	10
trapinch	10
vibrava	14
flygon	15
cacnea	14
cacturne	12
swablu	12
altaria	12
zangoose	15
seviper	14
lunatone	14
solrock	14
barboach	12
whiscash	15
corphish	13
crawdaunt	15
baltoy	7
claydol	12
lileep	12
cradily	12
anorith	14
armaldo	14
feebas	13
milotic	14
castform	9
kecleon	15
shuppet	12
banette	12
duskull	13
dusclops	11
tropius	15
chimecho	13
absol	11
wynaut	11
snorunt	15
glalie	13
spheal	12
sealeo	15
walrein	12
clamperl	14
huntail	14
gorebyss	12
relicanth	13
luvdisc	9
bagon	11
shelgon	12
salamence	13
beldum	10
metang	13
metagross	13
regirock	13
regice	10
registeel	13
latias	14
latios	14
kyogre	14
groudon	14
rayquaza	12
jirachi	12
deoxys	14
teamrocket	6
starterspairs	6
startersDark	6
pals
alphabet	26
alphabet2	26
glasbey	32
kelly	22
polychrome	36
stepped	24
tol	12
watlington	16
Polychrome
alphabet	26
dark	24
glasbey	32
green.armytage	26
kelly	22
light	24
palette36	36
rcartocolor
ag_Sunset	7
ag_GrnYl	7
Tropic	7
Temps	7
TealRose	7
Geyser	7
Fall	7
Earth	7
ArmyRose	7
Vivid	12
Safe	12
Prism	12
Pastel	12
Bold	12
Antique	12
TealGrn	7
Teal	7
SunsetDark	7
Sunset	7
RedOr	7
PurpOr	7
Purp	7
PinkYl	7
Peach	7
OrYel	7
Mint	7
Magenta	7
Emrld	7
DarkMint	7
BurgYl	7
Burg	7
BrwnYl	7
BluYl	7
BluGrn	7
RColorBrewer
BrBG	11
PiYG	11
PRGn	11
PuOr	11
RdBu	11
RdGy	11
RdYlBu	11
RdYlGn	11
Spectral	11
Accent	8
Dark2	8
Paired	12
Pastel1	9
Pastel2	8
Set1	9
Set2	8
Set3	12
Blues	9
BuGn	9
BuPu	9
GnBu	9
Greens	9
Greys	9
Oranges	9
OrRd	9
PuBu	9
PuBuGn	9
PuRd	9
Purples	9
RdPu	9
Reds	9
YlGn	9
YlGnBu	9
YlOrBr	9
YlOrRd	9
Redmonder
dPBIYlBu	11
dPBIYlPu	11
dPBIPuGn	11
dPBIPuOr	11
dPBIRdBu	11
dPBIRdGy	11
dPBIRdGn	11
qMSOStd	10
qMSO12	8
qMSO15	8
qMSOBuWarm	8
qMSOBu	8
qMSOBu2	8
qMSOBuGn	8
qMSOGn	8
qMSOGnYl	8
qMSOYl	8
qMSOYlOr	8
qMSOOr	8
qMSOOrRd	8
qMSORdOr	8
qMSORd	8
qMSORdPu	8
qMSOPu	8
qMSOPu2	8
qMSOMed	8
qMSOPap	8
qMSOMrq	8
qMSOSlp	8
qMSOAsp	8
qPBI	8
sPBIGn	9
sPBIGy1	9
sPBIRd	9
sPBIYl	9
sPBIGy2	9
sPBIBu	9
sPBIOr	9
sPBIPu	9
sPBIYlGn	9
sPBIRdPu	9
tidyquant
tq_light	12
tq_dark	12
tq_green	12
wesanderson
BottleRocket1	7
BottleRocket2	5
Rushmore1	5
Rushmore	5
Royal1	4
Royal2	5
Zissou1	5
Darjeeling1	5
Darjeeling2	5
Chevalier1	4
FantasticFox1	5
Moonrise1	4
Moonrise2	4
Moonrise3	5
Cavalcanti1	5
GrandBudapest1	4
GrandBudapest2	4
IsleofDogs1	6
IsleofDogs2	5
yarrr
basel	10
pony	9
xmen	8
decision	6
southpark	6
google	4
eternal	7
evildead	6
usualsuspects	7
ohbrother	7
appletv	6
brave	5
bugs	5
cars	5
nemo	5
rat	5
up	5
espresso	5
ipod	7
info	9
info2	14
The paletteer package is maintained by Emil Hvitfeldt. More information can be found on the paletteer site and on the CRAN info page.

# Create a stub (with row labels), and,
# include row groups (using the `row`
# and `group` columns)
tab <-
  exibble %>%
  gt(
    rowname_col = "row",
    groupname_col = "group"
  ) %>%
# Format the `num` column with gt's
# scientific notation
    fmt_scientific(
    columns = vars(num),
    decimals = 3) %>%


# Format the dates in `date` (but
# only those rows that satisfy a
# condition) with `date_style` 6

  fmt_date(
    columns = vars(date),
    rows = grepl("^[a-d]", char),
    date_style = 6
  )  %>%



# Anyway, let's get rid of some columns

  cols_hide(
    columns = vars(char, fctr, time, datetime))  %>%


# Format the currency column to have
# values in pounds

  fmt_currency(
    columns = vars(currency),
    currency = "GBP"
  ) %>%


# Add conditional footnotes to some of
# the `currency` values


  tab_footnote(
    footnote = "These are lower prices.",
    locations = cells_data(
      columns = vars(currency),
      rows = currency < 20
    )
  ) %>%


# Add a footnote to the `currency`
# column label itself

  tab_footnote(
    footnote = "All values are in GBP.",
    locations = cells_column_labels(
      columns = vars(currency)
    )
  )%>%


# Add a header to the table (with a
# title and a subtitle)
 
  tab_header(
    title = "An Exibble Example",
    subtitle = md("Uses the `exibble` dataset from **gt**")
  ) %>%

# Have the footnote glyphs be a
# sequence of lowercase letters
# (`tab_options()` has options galore)

# tab_options(footnote.glyph = letters) %>%


# Color the stub cells in blue; we just
# need to target `column_labels.background.color`
 
  tab_options(column_labels.background.color = "blue")

## Warning: The `cells_data()` function is deprecated and will soon be removed
##  * Use the `cells_body()` function instead

tab

An Exibble Example
Uses the exibble dataset from gt
	num	date	currency1
grp_a
row_1	1.111 × 10−1	Jan 15, 2015	£49.95
row_2	2.222	Feb 15, 2015	£17.952
row_3	3.333 × 101	Mar 15, 2015	£1.392
row_4	4.444 × 102	Apr 15, 2015	£65,100.00
grp_b
row_5	5.550 × 103	2015-05-15	£1,325.81
row_6	NA	2015-06-15	£13.262
row_7	7.770 × 105	NA	NA
row_8	8.880 × 106	2015-08-15	£0.442
1 All values are in GBP. 2 These are lower prices.