I am developing the microData package to search, browse, and extract
metadata from microdata provided by the World Bank (WB), Food and
Agriculture Organization (FAO), International Household Survey (IHSN),
United Nations High Commissioner for Refugees (UNHCR), and International
Labor Organization (ILO) via the NADA API. Any researcher who has used
microdata from these organizations knows how difficult and
time-consuming it is to understand and import these data and variables
into R. If you are a user or plan to use micradata, then this is the
life-saving R package for you.
The purpose of microData is to simplify the process of extracting
complex metadata from data provided by various organizations, thereby
improving data preparation efficiency. At the moment, it supports five
international organizations, namely the World Bank, FAO, UNHCR, IHSN,
and ILO. It has the ability to search, filter, extract, and perform
other tasks that you can do on the web, but it cannot download the data
file itself. This is because, to my knowledge, there is currently no
available documentation for use with the API. I think it is due to data
license issue because there are few accessible datasets through the API.
Furthermore, this package has the ability to assist in obtaining the
names of variables from a specific survey, as well as their labels. It
also allows you to select only variables that you are interested in and
rename them, while assigning variable descriptions as label attributes.
You can set custom names and labels for the dataset. Labels play a
crucial role when exporting tables and graphs, as they save you from
setting long names in manuscripts manually. Therefore, this package is
available to alleviate all these difficulties.
Warning: Since this package is still under development, I don’t recommend you use it in reproducible code, as any changes can happen in the future.
You can install the development version of microData from GitHub with:
# install.packages("devtools")
devtools::install_github("GutUrago/microData")All organizations supported by this package use the NADA API to publish
micro-data, which makes use of similar terminologies. Collection simply
means gathering multiple related studies or data sets. To see all
available collections, you can use collections() function.
Note: I used customized gt table theme that I created in this blog.
library(microData)
collections(org = "wb") |>
head() |>
my_gt_theme()
<style>#jkwanvisai table {
font-family: system-ui, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol', 'Noto Color Emoji';
-webkit-font-smoothing: antialiased;
-moz-osx-font-smoothing: grayscale;
}
#jkwanvisai thead, #jkwanvisai tbody, #jkwanvisai tfoot, #jkwanvisai tr, #jkwanvisai td, #jkwanvisai th {
border-style: none;
}
#jkwanvisai p {
margin: 0;
padding: 0;
}
#jkwanvisai .gt_table {
display: table;
border-collapse: collapse;
line-height: normal;
margin-left: auto;
margin-right: auto;
color: #333333;
font-size: 16px;
font-weight: normal;
font-style: normal;
background-color: #FFFFFF;
width: 100%;
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;
}
#jkwanvisai .gt_caption {
padding-top: 4px;
padding-bottom: 4px;
}
#jkwanvisai .gt_title {
color: #333333;
font-size: 125%;
font-weight: initial;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
border-bottom-color: #FFFFFF;
border-bottom-width: 0;
}
#jkwanvisai .gt_subtitle {
color: #333333;
font-size: 85%;
font-weight: initial;
padding-top: 3px;
padding-bottom: 5px;
padding-left: 5px;
padding-right: 5px;
border-top-color: #FFFFFF;
border-top-width: 0;
}
#jkwanvisai .gt_heading {
background-color: #FFFFFF;
text-align: left;
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;
}
#jkwanvisai .gt_bottom_border {
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
}
#jkwanvisai .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;
}
#jkwanvisai .gt_col_heading {
color: #FFFFFF;
background-color: #4682B4;
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;
}
#jkwanvisai .gt_column_spanner_outer {
color: #FFFFFF;
background-color: #4682B4;
font-size: 100%;
font-weight: normal;
text-transform: inherit;
padding-top: 0;
padding-bottom: 0;
padding-left: 4px;
padding-right: 4px;
}
#jkwanvisai .gt_column_spanner_outer:first-child {
padding-left: 0;
}
#jkwanvisai .gt_column_spanner_outer:last-child {
padding-right: 0;
}
#jkwanvisai .gt_column_spanner {
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
vertical-align: bottom;
padding-top: 5px;
padding-bottom: 5px;
overflow-x: hidden;
display: inline-block;
width: 100%;
}
#jkwanvisai .gt_spanner_row {
border-bottom-style: hidden;
}
#jkwanvisai .gt_group_heading {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
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;
text-align: left;
}
#jkwanvisai .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;
}
#jkwanvisai .gt_from_md > :first-child {
margin-top: 0;
}
#jkwanvisai .gt_from_md > :last-child {
margin-bottom: 0;
}
#jkwanvisai .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;
}
#jkwanvisai .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: 5px;
padding-right: 5px;
}
#jkwanvisai .gt_stub_row_group {
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: 5px;
padding-right: 5px;
vertical-align: top;
}
#jkwanvisai .gt_row_group_first td {
border-top-width: 2px;
}
#jkwanvisai .gt_row_group_first th {
border-top-width: 2px;
}
#jkwanvisai .gt_summary_row {
color: #333333;
background-color: #FFFFFF;
text-transform: inherit;
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
}
#jkwanvisai .gt_first_summary_row {
border-top-style: solid;
border-top-color: #D3D3D3;
}
#jkwanvisai .gt_first_summary_row.thick {
border-top-width: 2px;
}
#jkwanvisai .gt_last_summary_row {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
}
#jkwanvisai .gt_grand_summary_row {
color: #333333;
background-color: #FFFFFF;
text-transform: inherit;
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
}
#jkwanvisai .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;
}
#jkwanvisai .gt_last_grand_summary_row_top {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
border-bottom-style: double;
border-bottom-width: 6px;
border-bottom-color: #D3D3D3;
}
#jkwanvisai .gt_striped {
background-color: rgba(128, 128, 128, 0.05);
}
#jkwanvisai .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;
}
#jkwanvisai .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;
}
#jkwanvisai .gt_footnote {
margin: 0px;
font-size: 90%;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
}
#jkwanvisai .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;
}
#jkwanvisai .gt_sourcenote {
font-size: 90%;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
}
#jkwanvisai .gt_left {
text-align: left;
}
#jkwanvisai .gt_center {
text-align: center;
}
#jkwanvisai .gt_right {
text-align: right;
font-variant-numeric: tabular-nums;
}
#jkwanvisai .gt_font_normal {
font-weight: normal;
}
#jkwanvisai .gt_font_bold {
font-weight: bold;
}
#jkwanvisai .gt_font_italic {
font-style: italic;
}
#jkwanvisai .gt_super {
font-size: 65%;
}
#jkwanvisai .gt_footnote_marks {
font-size: 75%;
vertical-align: 0.4em;
position: initial;
}
#jkwanvisai .gt_asterisk {
font-size: 100%;
vertical-align: 0;
}
#jkwanvisai .gt_indent_1 {
text-indent: 5px;
}
#jkwanvisai .gt_indent_2 {
text-indent: 10px;
}
#jkwanvisai .gt_indent_3 {
text-indent: 15px;
}
#jkwanvisai .gt_indent_4 {
text-indent: 20px;
}
#jkwanvisai .gt_indent_5 {
text-indent: 25px;
}
</style>
| id | repo_id | title |
|---|---|---|
| 26 | afrobarometer | Afrobarometer |
| 2 | datafirst | DataFirst , University of Cape Town, South Africa |
| 22 | dime | Development Impact Evaluation (DIME) |
| 1 | microdata_rg | Development Research Microdata |
| 4 | enterprise_surveys | Enterprise Surveys |
| 30 | fao | FAO - Food and Agriculture Microdata Catalog |
This package gives all flexibility of searching on the web. For more see
the documentation for search_catalog().
search_catalog(
keyword = "food",
org = "unhcr",
from = 2015,
to = 2024,
country ="Ethiopia",
sort_by = "year",
sort_order = "desc",
results = 10)There is also handy function to check latest publications of these datasets.
latest_entries(org = "wb", limit = 15)You can use data_files to see the data files included in the study.
Let’s see one of the popular survey on the WB. We can also use id number
of the study, which is 3110 instead of the name (See next code chunk).
data_files(id = "TZA_1991_KHDS_v01_M", org = "wb") |>
head() |>
my_gt_theme()
<style>#noayhroewz table {
font-family: system-ui, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol', 'Noto Color Emoji';
-webkit-font-smoothing: antialiased;
-moz-osx-font-smoothing: grayscale;
}
#noayhroewz thead, #noayhroewz tbody, #noayhroewz tfoot, #noayhroewz tr, #noayhroewz td, #noayhroewz th {
border-style: none;
}
#noayhroewz p {
margin: 0;
padding: 0;
}
#noayhroewz .gt_table {
display: table;
border-collapse: collapse;
line-height: normal;
margin-left: auto;
margin-right: auto;
color: #333333;
font-size: 16px;
font-weight: normal;
font-style: normal;
background-color: #FFFFFF;
width: 100%;
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;
}
#noayhroewz .gt_caption {
padding-top: 4px;
padding-bottom: 4px;
}
#noayhroewz .gt_title {
color: #333333;
font-size: 125%;
font-weight: initial;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
border-bottom-color: #FFFFFF;
border-bottom-width: 0;
}
#noayhroewz .gt_subtitle {
color: #333333;
font-size: 85%;
font-weight: initial;
padding-top: 3px;
padding-bottom: 5px;
padding-left: 5px;
padding-right: 5px;
border-top-color: #FFFFFF;
border-top-width: 0;
}
#noayhroewz .gt_heading {
background-color: #FFFFFF;
text-align: left;
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;
}
#noayhroewz .gt_bottom_border {
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
}
#noayhroewz .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;
}
#noayhroewz .gt_col_heading {
color: #FFFFFF;
background-color: #4682B4;
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;
}
#noayhroewz .gt_column_spanner_outer {
color: #FFFFFF;
background-color: #4682B4;
font-size: 100%;
font-weight: normal;
text-transform: inherit;
padding-top: 0;
padding-bottom: 0;
padding-left: 4px;
padding-right: 4px;
}
#noayhroewz .gt_column_spanner_outer:first-child {
padding-left: 0;
}
#noayhroewz .gt_column_spanner_outer:last-child {
padding-right: 0;
}
#noayhroewz .gt_column_spanner {
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
vertical-align: bottom;
padding-top: 5px;
padding-bottom: 5px;
overflow-x: hidden;
display: inline-block;
width: 100%;
}
#noayhroewz .gt_spanner_row {
border-bottom-style: hidden;
}
#noayhroewz .gt_group_heading {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
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;
text-align: left;
}
#noayhroewz .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;
}
#noayhroewz .gt_from_md > :first-child {
margin-top: 0;
}
#noayhroewz .gt_from_md > :last-child {
margin-bottom: 0;
}
#noayhroewz .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;
}
#noayhroewz .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: 5px;
padding-right: 5px;
}
#noayhroewz .gt_stub_row_group {
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: 5px;
padding-right: 5px;
vertical-align: top;
}
#noayhroewz .gt_row_group_first td {
border-top-width: 2px;
}
#noayhroewz .gt_row_group_first th {
border-top-width: 2px;
}
#noayhroewz .gt_summary_row {
color: #333333;
background-color: #FFFFFF;
text-transform: inherit;
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
}
#noayhroewz .gt_first_summary_row {
border-top-style: solid;
border-top-color: #D3D3D3;
}
#noayhroewz .gt_first_summary_row.thick {
border-top-width: 2px;
}
#noayhroewz .gt_last_summary_row {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
}
#noayhroewz .gt_grand_summary_row {
color: #333333;
background-color: #FFFFFF;
text-transform: inherit;
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
}
#noayhroewz .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;
}
#noayhroewz .gt_last_grand_summary_row_top {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
border-bottom-style: double;
border-bottom-width: 6px;
border-bottom-color: #D3D3D3;
}
#noayhroewz .gt_striped {
background-color: rgba(128, 128, 128, 0.05);
}
#noayhroewz .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;
}
#noayhroewz .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;
}
#noayhroewz .gt_footnote {
margin: 0px;
font-size: 90%;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
}
#noayhroewz .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;
}
#noayhroewz .gt_sourcenote {
font-size: 90%;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
}
#noayhroewz .gt_left {
text-align: left;
}
#noayhroewz .gt_center {
text-align: center;
}
#noayhroewz .gt_right {
text-align: right;
font-variant-numeric: tabular-nums;
}
#noayhroewz .gt_font_normal {
font-weight: normal;
}
#noayhroewz .gt_font_bold {
font-weight: bold;
}
#noayhroewz .gt_font_italic {
font-style: italic;
}
#noayhroewz .gt_super {
font-size: 65%;
}
#noayhroewz .gt_footnote_marks {
font-size: 75%;
vertical-align: 0.4em;
position: initial;
}
#noayhroewz .gt_asterisk {
font-size: 100%;
vertical-align: 0;
}
#noayhroewz .gt_indent_1 {
text-indent: 5px;
}
#noayhroewz .gt_indent_2 {
text-indent: 10px;
}
#noayhroewz .gt_indent_3 {
text-indent: 15px;
}
#noayhroewz .gt_indent_4 {
text-indent: 20px;
}
#noayhroewz .gt_indent_5 {
text-indent: 25px;
}
</style>
| id | sid | file_id | file_name | description | case_count | var_count |
|---|---|---|---|---|---|---|
| 81328 | 359 | F1 | Wave1_HH_S_____HH | Miscellaneous | 981 | 163 |
| 81329 | 359 | F2 | Wave1_HH_S00B_OTH | Section verification | 18258 | 16 |
| 81330 | 359 | F3 | Wave1_HH_S1___IND | Household Roster | 5373 | 25 |
| 81331 | 359 | F4 | Wave1_HH_S2___KID | Children Residing Elsewhere | 3394 | 28 |
| 81332 | 359 | F5 | Wave1_HH_S3___IND | Parents | 5298 | 27 |
| 81333 | 359 | F6 | Wave1_HH_S4___BUS | Overview of Household Businesses | 334 | 7 |
How about variables included in the data file? Of course you can check them as well.
variables(id = 359, file_id = "F3") |>
head() |>
my_gt_theme()
<style>#rxazendfhl table {
font-family: system-ui, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol', 'Noto Color Emoji';
-webkit-font-smoothing: antialiased;
-moz-osx-font-smoothing: grayscale;
}
#rxazendfhl thead, #rxazendfhl tbody, #rxazendfhl tfoot, #rxazendfhl tr, #rxazendfhl td, #rxazendfhl th {
border-style: none;
}
#rxazendfhl p {
margin: 0;
padding: 0;
}
#rxazendfhl .gt_table {
display: table;
border-collapse: collapse;
line-height: normal;
margin-left: auto;
margin-right: auto;
color: #333333;
font-size: 16px;
font-weight: normal;
font-style: normal;
background-color: #FFFFFF;
width: 100%;
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;
}
#rxazendfhl .gt_caption {
padding-top: 4px;
padding-bottom: 4px;
}
#rxazendfhl .gt_title {
color: #333333;
font-size: 125%;
font-weight: initial;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
border-bottom-color: #FFFFFF;
border-bottom-width: 0;
}
#rxazendfhl .gt_subtitle {
color: #333333;
font-size: 85%;
font-weight: initial;
padding-top: 3px;
padding-bottom: 5px;
padding-left: 5px;
padding-right: 5px;
border-top-color: #FFFFFF;
border-top-width: 0;
}
#rxazendfhl .gt_heading {
background-color: #FFFFFF;
text-align: left;
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;
}
#rxazendfhl .gt_bottom_border {
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
}
#rxazendfhl .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;
}
#rxazendfhl .gt_col_heading {
color: #FFFFFF;
background-color: #4682B4;
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;
}
#rxazendfhl .gt_column_spanner_outer {
color: #FFFFFF;
background-color: #4682B4;
font-size: 100%;
font-weight: normal;
text-transform: inherit;
padding-top: 0;
padding-bottom: 0;
padding-left: 4px;
padding-right: 4px;
}
#rxazendfhl .gt_column_spanner_outer:first-child {
padding-left: 0;
}
#rxazendfhl .gt_column_spanner_outer:last-child {
padding-right: 0;
}
#rxazendfhl .gt_column_spanner {
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
vertical-align: bottom;
padding-top: 5px;
padding-bottom: 5px;
overflow-x: hidden;
display: inline-block;
width: 100%;
}
#rxazendfhl .gt_spanner_row {
border-bottom-style: hidden;
}
#rxazendfhl .gt_group_heading {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
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;
text-align: left;
}
#rxazendfhl .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;
}
#rxazendfhl .gt_from_md > :first-child {
margin-top: 0;
}
#rxazendfhl .gt_from_md > :last-child {
margin-bottom: 0;
}
#rxazendfhl .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;
}
#rxazendfhl .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: 5px;
padding-right: 5px;
}
#rxazendfhl .gt_stub_row_group {
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: 5px;
padding-right: 5px;
vertical-align: top;
}
#rxazendfhl .gt_row_group_first td {
border-top-width: 2px;
}
#rxazendfhl .gt_row_group_first th {
border-top-width: 2px;
}
#rxazendfhl .gt_summary_row {
color: #333333;
background-color: #FFFFFF;
text-transform: inherit;
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
}
#rxazendfhl .gt_first_summary_row {
border-top-style: solid;
border-top-color: #D3D3D3;
}
#rxazendfhl .gt_first_summary_row.thick {
border-top-width: 2px;
}
#rxazendfhl .gt_last_summary_row {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
}
#rxazendfhl .gt_grand_summary_row {
color: #333333;
background-color: #FFFFFF;
text-transform: inherit;
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
}
#rxazendfhl .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;
}
#rxazendfhl .gt_last_grand_summary_row_top {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
border-bottom-style: double;
border-bottom-width: 6px;
border-bottom-color: #D3D3D3;
}
#rxazendfhl .gt_striped {
background-color: rgba(128, 128, 128, 0.05);
}
#rxazendfhl .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;
}
#rxazendfhl .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;
}
#rxazendfhl .gt_footnote {
margin: 0px;
font-size: 90%;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
}
#rxazendfhl .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;
}
#rxazendfhl .gt_sourcenote {
font-size: 90%;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
}
#rxazendfhl .gt_left {
text-align: left;
}
#rxazendfhl .gt_center {
text-align: center;
}
#rxazendfhl .gt_right {
text-align: right;
font-variant-numeric: tabular-nums;
}
#rxazendfhl .gt_font_normal {
font-weight: normal;
}
#rxazendfhl .gt_font_bold {
font-weight: bold;
}
#rxazendfhl .gt_font_italic {
font-style: italic;
}
#rxazendfhl .gt_super {
font-size: 65%;
}
#rxazendfhl .gt_footnote_marks {
font-size: 75%;
vertical-align: 0.4em;
position: initial;
}
#rxazendfhl .gt_asterisk {
font-size: 100%;
vertical-align: 0;
}
#rxazendfhl .gt_indent_1 {
text-indent: 5px;
}
#rxazendfhl .gt_indent_2 {
text-indent: 10px;
}
#rxazendfhl .gt_indent_3 {
text-indent: 15px;
}
#rxazendfhl .gt_indent_4 {
text-indent: 20px;
}
#rxazendfhl .gt_indent_5 {
text-indent: 25px;
}
</style>
| uid | sid | fid | vid | name | labl |
|---|---|---|---|---|---|
| 265957 | 359 | F3 | V180 | cluster | Cluster |
| 265958 | 359 | F3 | V181 | hh | Household Number |
| 265959 | 359 | F3 | V182 | id | Individual ID Code in HH |
| 265960 | 359 | F3 | V183 | wave | Wave |
| 265961 | 359 | F3 | V184 | passage | Passage |
| 265962 | 359 | F3 | V185 | sex | S1Q2: Sex |
Variables in microdata are often named something that has nothing to do with the variable except question order like this.
<style>#vweblhabor table {
font-family: system-ui, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol', 'Noto Color Emoji';
-webkit-font-smoothing: antialiased;
-moz-osx-font-smoothing: grayscale;
}
#vweblhabor thead, #vweblhabor tbody, #vweblhabor tfoot, #vweblhabor tr, #vweblhabor td, #vweblhabor th {
border-style: none;
}
#vweblhabor p {
margin: 0;
padding: 0;
}
#vweblhabor .gt_table {
display: table;
border-collapse: collapse;
line-height: normal;
margin-left: auto;
margin-right: auto;
color: #333333;
font-size: 16px;
font-weight: normal;
font-style: normal;
background-color: #FFFFFF;
width: 100%;
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;
}
#vweblhabor .gt_caption {
padding-top: 4px;
padding-bottom: 4px;
}
#vweblhabor .gt_title {
color: #333333;
font-size: 125%;
font-weight: initial;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
border-bottom-color: #FFFFFF;
border-bottom-width: 0;
}
#vweblhabor .gt_subtitle {
color: #333333;
font-size: 85%;
font-weight: initial;
padding-top: 3px;
padding-bottom: 5px;
padding-left: 5px;
padding-right: 5px;
border-top-color: #FFFFFF;
border-top-width: 0;
}
#vweblhabor .gt_heading {
background-color: #FFFFFF;
text-align: left;
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;
}
#vweblhabor .gt_bottom_border {
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
}
#vweblhabor .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;
}
#vweblhabor .gt_col_heading {
color: #FFFFFF;
background-color: #4682B4;
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;
}
#vweblhabor .gt_column_spanner_outer {
color: #FFFFFF;
background-color: #4682B4;
font-size: 100%;
font-weight: normal;
text-transform: inherit;
padding-top: 0;
padding-bottom: 0;
padding-left: 4px;
padding-right: 4px;
}
#vweblhabor .gt_column_spanner_outer:first-child {
padding-left: 0;
}
#vweblhabor .gt_column_spanner_outer:last-child {
padding-right: 0;
}
#vweblhabor .gt_column_spanner {
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
vertical-align: bottom;
padding-top: 5px;
padding-bottom: 5px;
overflow-x: hidden;
display: inline-block;
width: 100%;
}
#vweblhabor .gt_spanner_row {
border-bottom-style: hidden;
}
#vweblhabor .gt_group_heading {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
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;
text-align: left;
}
#vweblhabor .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;
}
#vweblhabor .gt_from_md > :first-child {
margin-top: 0;
}
#vweblhabor .gt_from_md > :last-child {
margin-bottom: 0;
}
#vweblhabor .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;
}
#vweblhabor .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: 5px;
padding-right: 5px;
}
#vweblhabor .gt_stub_row_group {
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: 5px;
padding-right: 5px;
vertical-align: top;
}
#vweblhabor .gt_row_group_first td {
border-top-width: 2px;
}
#vweblhabor .gt_row_group_first th {
border-top-width: 2px;
}
#vweblhabor .gt_summary_row {
color: #333333;
background-color: #FFFFFF;
text-transform: inherit;
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
}
#vweblhabor .gt_first_summary_row {
border-top-style: solid;
border-top-color: #D3D3D3;
}
#vweblhabor .gt_first_summary_row.thick {
border-top-width: 2px;
}
#vweblhabor .gt_last_summary_row {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
}
#vweblhabor .gt_grand_summary_row {
color: #333333;
background-color: #FFFFFF;
text-transform: inherit;
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
}
#vweblhabor .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;
}
#vweblhabor .gt_last_grand_summary_row_top {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
border-bottom-style: double;
border-bottom-width: 6px;
border-bottom-color: #D3D3D3;
}
#vweblhabor .gt_striped {
background-color: rgba(128, 128, 128, 0.05);
}
#vweblhabor .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;
}
#vweblhabor .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;
}
#vweblhabor .gt_footnote {
margin: 0px;
font-size: 90%;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
}
#vweblhabor .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;
}
#vweblhabor .gt_sourcenote {
font-size: 90%;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
}
#vweblhabor .gt_left {
text-align: left;
}
#vweblhabor .gt_center {
text-align: center;
}
#vweblhabor .gt_right {
text-align: right;
font-variant-numeric: tabular-nums;
}
#vweblhabor .gt_font_normal {
font-weight: normal;
}
#vweblhabor .gt_font_bold {
font-weight: bold;
}
#vweblhabor .gt_font_italic {
font-style: italic;
}
#vweblhabor .gt_super {
font-size: 65%;
}
#vweblhabor .gt_footnote_marks {
font-size: 75%;
vertical-align: 0.4em;
position: initial;
}
#vweblhabor .gt_asterisk {
font-size: 100%;
vertical-align: 0;
}
#vweblhabor .gt_indent_1 {
text-indent: 5px;
}
#vweblhabor .gt_indent_2 {
text-indent: 10px;
}
#vweblhabor .gt_indent_3 {
text-indent: 15px;
}
#vweblhabor .gt_indent_4 {
text-indent: 20px;
}
#vweblhabor .gt_indent_5 {
text-indent: 25px;
}
</style>
| id | v1 | v2 | v3 | v4 |
|---|---|---|---|---|
| 1 | 44 | male | master | 6395.007 |
| 2 | 48 | female | phd | 7402.144 |
| 3 | 43 | female | master | 5496.753 |
| 4 | 32 | female | phd | 4200.946 |
| 5 | 39 | male | master | 5391.046 |
| 6 | 47 | female | phd | 7186.892 |
Then you can prepare another data that contains metadata like this. It will be explained in detail in vignettes later.
<style>#scwfghycmj table {
font-family: system-ui, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol', 'Noto Color Emoji';
-webkit-font-smoothing: antialiased;
-moz-osx-font-smoothing: grayscale;
}
#scwfghycmj thead, #scwfghycmj tbody, #scwfghycmj tfoot, #scwfghycmj tr, #scwfghycmj td, #scwfghycmj th {
border-style: none;
}
#scwfghycmj p {
margin: 0;
padding: 0;
}
#scwfghycmj .gt_table {
display: table;
border-collapse: collapse;
line-height: normal;
margin-left: auto;
margin-right: auto;
color: #333333;
font-size: 16px;
font-weight: normal;
font-style: normal;
background-color: #FFFFFF;
width: 100%;
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;
}
#scwfghycmj .gt_caption {
padding-top: 4px;
padding-bottom: 4px;
}
#scwfghycmj .gt_title {
color: #333333;
font-size: 125%;
font-weight: initial;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
border-bottom-color: #FFFFFF;
border-bottom-width: 0;
}
#scwfghycmj .gt_subtitle {
color: #333333;
font-size: 85%;
font-weight: initial;
padding-top: 3px;
padding-bottom: 5px;
padding-left: 5px;
padding-right: 5px;
border-top-color: #FFFFFF;
border-top-width: 0;
}
#scwfghycmj .gt_heading {
background-color: #FFFFFF;
text-align: left;
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;
}
#scwfghycmj .gt_bottom_border {
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
}
#scwfghycmj .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;
}
#scwfghycmj .gt_col_heading {
color: #FFFFFF;
background-color: #4682B4;
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;
}
#scwfghycmj .gt_column_spanner_outer {
color: #FFFFFF;
background-color: #4682B4;
font-size: 100%;
font-weight: normal;
text-transform: inherit;
padding-top: 0;
padding-bottom: 0;
padding-left: 4px;
padding-right: 4px;
}
#scwfghycmj .gt_column_spanner_outer:first-child {
padding-left: 0;
}
#scwfghycmj .gt_column_spanner_outer:last-child {
padding-right: 0;
}
#scwfghycmj .gt_column_spanner {
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
vertical-align: bottom;
padding-top: 5px;
padding-bottom: 5px;
overflow-x: hidden;
display: inline-block;
width: 100%;
}
#scwfghycmj .gt_spanner_row {
border-bottom-style: hidden;
}
#scwfghycmj .gt_group_heading {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
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;
text-align: left;
}
#scwfghycmj .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;
}
#scwfghycmj .gt_from_md > :first-child {
margin-top: 0;
}
#scwfghycmj .gt_from_md > :last-child {
margin-bottom: 0;
}
#scwfghycmj .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;
}
#scwfghycmj .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: 5px;
padding-right: 5px;
}
#scwfghycmj .gt_stub_row_group {
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: 5px;
padding-right: 5px;
vertical-align: top;
}
#scwfghycmj .gt_row_group_first td {
border-top-width: 2px;
}
#scwfghycmj .gt_row_group_first th {
border-top-width: 2px;
}
#scwfghycmj .gt_summary_row {
color: #333333;
background-color: #FFFFFF;
text-transform: inherit;
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
}
#scwfghycmj .gt_first_summary_row {
border-top-style: solid;
border-top-color: #D3D3D3;
}
#scwfghycmj .gt_first_summary_row.thick {
border-top-width: 2px;
}
#scwfghycmj .gt_last_summary_row {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
}
#scwfghycmj .gt_grand_summary_row {
color: #333333;
background-color: #FFFFFF;
text-transform: inherit;
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
}
#scwfghycmj .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;
}
#scwfghycmj .gt_last_grand_summary_row_top {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
border-bottom-style: double;
border-bottom-width: 6px;
border-bottom-color: #D3D3D3;
}
#scwfghycmj .gt_striped {
background-color: rgba(128, 128, 128, 0.05);
}
#scwfghycmj .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;
}
#scwfghycmj .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;
}
#scwfghycmj .gt_footnote {
margin: 0px;
font-size: 90%;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
}
#scwfghycmj .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;
}
#scwfghycmj .gt_sourcenote {
font-size: 90%;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
}
#scwfghycmj .gt_left {
text-align: left;
}
#scwfghycmj .gt_center {
text-align: center;
}
#scwfghycmj .gt_right {
text-align: right;
font-variant-numeric: tabular-nums;
}
#scwfghycmj .gt_font_normal {
font-weight: normal;
}
#scwfghycmj .gt_font_bold {
font-weight: bold;
}
#scwfghycmj .gt_font_italic {
font-style: italic;
}
#scwfghycmj .gt_super {
font-size: 65%;
}
#scwfghycmj .gt_footnote_marks {
font-size: 75%;
vertical-align: 0.4em;
position: initial;
}
#scwfghycmj .gt_asterisk {
font-size: 100%;
vertical-align: 0;
}
#scwfghycmj .gt_indent_1 {
text-indent: 5px;
}
#scwfghycmj .gt_indent_2 {
text-indent: 10px;
}
#scwfghycmj .gt_indent_3 {
text-indent: 15px;
}
#scwfghycmj .gt_indent_4 {
text-indent: 20px;
}
#scwfghycmj .gt_indent_5 {
text-indent: 25px;
}
</style>
| var_id | var_name | label |
|---|---|---|
| id | individual_id | Respondent ID |
| v1 | age | Age of respondent |
| v2 | sex | Sex of respondent |
| v3 | education | Educational level |
| v4 | salary | Monthly salay ($) |
You can use set_attributes function to rename and set labels to these
variables.
my_data <- set_attributes(
mdt,
mtdt,
old_name = var_id,
new_name = var_name,
label = label)
head(my_data) |> my_gt_theme()
<style>#nfeyvcbrul table {
font-family: system-ui, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol', 'Noto Color Emoji';
-webkit-font-smoothing: antialiased;
-moz-osx-font-smoothing: grayscale;
}
#nfeyvcbrul thead, #nfeyvcbrul tbody, #nfeyvcbrul tfoot, #nfeyvcbrul tr, #nfeyvcbrul td, #nfeyvcbrul th {
border-style: none;
}
#nfeyvcbrul p {
margin: 0;
padding: 0;
}
#nfeyvcbrul .gt_table {
display: table;
border-collapse: collapse;
line-height: normal;
margin-left: auto;
margin-right: auto;
color: #333333;
font-size: 16px;
font-weight: normal;
font-style: normal;
background-color: #FFFFFF;
width: 100%;
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;
}
#nfeyvcbrul .gt_caption {
padding-top: 4px;
padding-bottom: 4px;
}
#nfeyvcbrul .gt_title {
color: #333333;
font-size: 125%;
font-weight: initial;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
border-bottom-color: #FFFFFF;
border-bottom-width: 0;
}
#nfeyvcbrul .gt_subtitle {
color: #333333;
font-size: 85%;
font-weight: initial;
padding-top: 3px;
padding-bottom: 5px;
padding-left: 5px;
padding-right: 5px;
border-top-color: #FFFFFF;
border-top-width: 0;
}
#nfeyvcbrul .gt_heading {
background-color: #FFFFFF;
text-align: left;
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;
}
#nfeyvcbrul .gt_bottom_border {
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
}
#nfeyvcbrul .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;
}
#nfeyvcbrul .gt_col_heading {
color: #FFFFFF;
background-color: #4682B4;
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;
}
#nfeyvcbrul .gt_column_spanner_outer {
color: #FFFFFF;
background-color: #4682B4;
font-size: 100%;
font-weight: normal;
text-transform: inherit;
padding-top: 0;
padding-bottom: 0;
padding-left: 4px;
padding-right: 4px;
}
#nfeyvcbrul .gt_column_spanner_outer:first-child {
padding-left: 0;
}
#nfeyvcbrul .gt_column_spanner_outer:last-child {
padding-right: 0;
}
#nfeyvcbrul .gt_column_spanner {
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
vertical-align: bottom;
padding-top: 5px;
padding-bottom: 5px;
overflow-x: hidden;
display: inline-block;
width: 100%;
}
#nfeyvcbrul .gt_spanner_row {
border-bottom-style: hidden;
}
#nfeyvcbrul .gt_group_heading {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
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;
text-align: left;
}
#nfeyvcbrul .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;
}
#nfeyvcbrul .gt_from_md > :first-child {
margin-top: 0;
}
#nfeyvcbrul .gt_from_md > :last-child {
margin-bottom: 0;
}
#nfeyvcbrul .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;
}
#nfeyvcbrul .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: 5px;
padding-right: 5px;
}
#nfeyvcbrul .gt_stub_row_group {
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: 5px;
padding-right: 5px;
vertical-align: top;
}
#nfeyvcbrul .gt_row_group_first td {
border-top-width: 2px;
}
#nfeyvcbrul .gt_row_group_first th {
border-top-width: 2px;
}
#nfeyvcbrul .gt_summary_row {
color: #333333;
background-color: #FFFFFF;
text-transform: inherit;
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
}
#nfeyvcbrul .gt_first_summary_row {
border-top-style: solid;
border-top-color: #D3D3D3;
}
#nfeyvcbrul .gt_first_summary_row.thick {
border-top-width: 2px;
}
#nfeyvcbrul .gt_last_summary_row {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
border-bottom-style: solid;
border-bottom-width: 2px;
border-bottom-color: #D3D3D3;
}
#nfeyvcbrul .gt_grand_summary_row {
color: #333333;
background-color: #FFFFFF;
text-transform: inherit;
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
}
#nfeyvcbrul .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;
}
#nfeyvcbrul .gt_last_grand_summary_row_top {
padding-top: 8px;
padding-bottom: 8px;
padding-left: 5px;
padding-right: 5px;
border-bottom-style: double;
border-bottom-width: 6px;
border-bottom-color: #D3D3D3;
}
#nfeyvcbrul .gt_striped {
background-color: rgba(128, 128, 128, 0.05);
}
#nfeyvcbrul .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;
}
#nfeyvcbrul .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;
}
#nfeyvcbrul .gt_footnote {
margin: 0px;
font-size: 90%;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
}
#nfeyvcbrul .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;
}
#nfeyvcbrul .gt_sourcenote {
font-size: 90%;
padding-top: 4px;
padding-bottom: 4px;
padding-left: 5px;
padding-right: 5px;
}
#nfeyvcbrul .gt_left {
text-align: left;
}
#nfeyvcbrul .gt_center {
text-align: center;
}
#nfeyvcbrul .gt_right {
text-align: right;
font-variant-numeric: tabular-nums;
}
#nfeyvcbrul .gt_font_normal {
font-weight: normal;
}
#nfeyvcbrul .gt_font_bold {
font-weight: bold;
}
#nfeyvcbrul .gt_font_italic {
font-style: italic;
}
#nfeyvcbrul .gt_super {
font-size: 65%;
}
#nfeyvcbrul .gt_footnote_marks {
font-size: 75%;
vertical-align: 0.4em;
position: initial;
}
#nfeyvcbrul .gt_asterisk {
font-size: 100%;
vertical-align: 0;
}
#nfeyvcbrul .gt_indent_1 {
text-indent: 5px;
}
#nfeyvcbrul .gt_indent_2 {
text-indent: 10px;
}
#nfeyvcbrul .gt_indent_3 {
text-indent: 15px;
}
#nfeyvcbrul .gt_indent_4 {
text-indent: 20px;
}
#nfeyvcbrul .gt_indent_5 {
text-indent: 25px;
}
</style>
| individual_id | age | sex | education | salary |
|---|---|---|---|---|
| 1 | 44 | male | master | 6395.007 |
| 2 | 48 | female | phd | 7402.144 |
| 3 | 43 | female | master | 5496.753 |
| 4 | 32 | female | phd | 4200.946 |
| 5 | 39 | male | master | 5391.046 |
| 6 | 47 | female | phd | 7186.892 |
labels are also assigned.
str(my_data)
#> 'data.frame': 100 obs. of 5 variables:
#> $ individual_id: int 1 2 3 4 5 6 7 8 9 10 ...
#> ..- attr(*, "label")= chr "Respondent ID"
#> $ age : int 44 48 43 32 39 47 40 34 49 43 ...
#> ..- attr(*, "label")= chr "Age of respondent"
#> $ sex : Factor w/ 2 levels "female","male": 2 1 1 1 2 1 2 2 1 2 ...
#> ..- attr(*, "label")= chr "Sex of respondent"
#> $ education : Factor w/ 3 levels "bachelor","master",..: 2 3 2 3 2 3 1 1 1 1 ...
#> ..- attr(*, "label")= chr "Educational level"
#> $ salary : num 6395 7402 5497 4201 5391 ...
#> ..- attr(*, "label")= chr "Monthly salay ($)"More coming soon!