# Missing Values


# Highlighted Missing Values

By default, `None` and `NaN` values are highlighted in red:


``` python
from great_docs import tbl_preview
from gdtest_tbl_preview import sample_missing

tbl_preview(sample_missing(15))
```


<table class="gt_table" data-quarto-disable-processing="true" data-quarto-bootstrap="false">
<thead>
<tr class="gt_heading">
<th colspan="5" class="gt_heading gt_title gt_font_normal"><div style="padding-top: 0; padding-bottom: 7px;">
<span class="gd-tbl-badge" style="background-color: #F0F0F0; color: #333333; border: 1px solid #F0F0F0; margin-right: 8px;">Table</span>Rows15Columns4
</div></th>
</tr>
<tr class="gt_col_headings">
<th class="gt_col_heading gt_columns_bottom_border gt_right" scope="col"></th>
<th id="alpha" class="gt_col_heading gt_columns_bottom_border gt_left" scope="col"><div>

alpha

<em>str</em>

</div></th>
<th id="beta" class="gt_col_heading gt_columns_bottom_border gt_right" scope="col"><div>

beta

<em>f64</em>

</div></th>
<th id="gamma" class="gt_col_heading gt_columns_bottom_border gt_right" scope="col"><div>

gamma

<em>f64</em>

</div></th>
<th id="delta" class="gt_col_heading gt_columns_bottom_border gt_left" scope="col"><div>

delta

<em>bool</em>

</div></th>
</tr>
</thead>
<tbody class="gt_table_body">
<tr>
<td class="gt_row gt_right gd-tbl-rownum">0</td>
<td class="gt_row gt_left" style="max-width: 117px">bar</td>
<td class="gt_row gt_right" style="max-width: 114px">48.77</td>
<td class="gt_row gt_right" style="max-width: 117px">10</td>
<td class="gt_row gt_left gd-tbl-missing" style="max-width: 117px">None</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">1</td>
<td class="gt_row gt_left" style="max-width: 117px">baz</td>
<td class="gt_row gt_right" style="max-width: 114px">79.19</td>
<td class="gt_row gt_right" style="max-width: 117px">81</td>
<td class="gt_row gt_left" style="max-width: 117px">True</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">2</td>
<td class="gt_row gt_left" style="max-width: 117px">foo</td>
<td class="gt_row gt_right" style="max-width: 114px">35.38</td>
<td class="gt_row gt_right" style="max-width: 117px">50</td>
<td class="gt_row gt_left" style="max-width: 117px">True</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">3</td>
<td class="gt_row gt_left gd-tbl-missing" style="max-width: 117px">None</td>
<td class="gt_row gt_right" style="max-width: 114px">43.77</td>
<td class="gt_row gt_right gd-tbl-missing" style="max-width: 117px">NaN</td>
<td class="gt_row gt_left gd-tbl-missing" style="max-width: 117px">None</td>
</tr>
<tr class="gd-tbl-divider">
<td class="gt_row gt_right gd-tbl-rownum">4</td>
<td class="gt_row gt_left" style="max-width: 117px">foo</td>
<td class="gt_row gt_right" style="max-width: 114px">47.08</td>
<td class="gt_row gt_right" style="max-width: 117px">6</td>
<td class="gt_row gt_left gd-tbl-missing" style="max-width: 117px">None</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">10</td>
<td class="gt_row gt_left" style="max-width: 117px">foo</td>
<td class="gt_row gt_right" style="max-width: 114px">55.35</td>
<td class="gt_row gt_right" style="max-width: 117px">26</td>
<td class="gt_row gt_left gd-tbl-missing" style="max-width: 117px">None</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">11</td>
<td class="gt_row gt_left gd-tbl-missing" style="max-width: 117px">None</td>
<td class="gt_row gt_right" style="max-width: 114px">67.44</td>
<td class="gt_row gt_right" style="max-width: 117px">81</td>
<td class="gt_row gt_left" style="max-width: 117px">False</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">12</td>
<td class="gt_row gt_left" style="max-width: 117px">bar</td>
<td class="gt_row gt_right gd-tbl-missing" style="max-width: 114px">None</td>
<td class="gt_row gt_right" style="max-width: 117px">92</td>
<td class="gt_row gt_left" style="max-width: 117px">True</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">13</td>
<td class="gt_row gt_left" style="max-width: 117px">baz</td>
<td class="gt_row gt_right" style="max-width: 114px">40.73</td>
<td class="gt_row gt_right" style="max-width: 117px">91</td>
<td class="gt_row gt_left" style="max-width: 117px">False</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">14</td>
<td class="gt_row gt_left" style="max-width: 117px">foo</td>
<td class="gt_row gt_right gd-tbl-missing" style="max-width: 114px">None</td>
<td class="gt_row gt_right" style="max-width: 117px">93</td>
<td class="gt_row gt_left gd-tbl-missing" style="max-width: 117px">None</td>
</tr>
</tbody>
</table>


# Without Highlighting

Turn off missing-value highlighting with `highlight_missing=False`:


``` python
tbl_preview(sample_missing(15), highlight_missing=False)
```


<table class="gt_table" data-quarto-disable-processing="true" data-quarto-bootstrap="false">
<thead>
<tr class="gt_heading">
<th colspan="5" class="gt_heading gt_title gt_font_normal"><div style="padding-top: 0; padding-bottom: 7px;">
<span class="gd-tbl-badge" style="background-color: #F0F0F0; color: #333333; border: 1px solid #F0F0F0; margin-right: 8px;">Table</span>Rows15Columns4
</div></th>
</tr>
<tr class="gt_col_headings">
<th class="gt_col_heading gt_columns_bottom_border gt_right" scope="col"></th>
<th id="alpha" class="gt_col_heading gt_columns_bottom_border gt_left" scope="col"><div>

alpha

<em>str</em>

</div></th>
<th id="beta" class="gt_col_heading gt_columns_bottom_border gt_right" scope="col"><div>

beta

<em>f64</em>

</div></th>
<th id="gamma" class="gt_col_heading gt_columns_bottom_border gt_right" scope="col"><div>

gamma

<em>f64</em>

</div></th>
<th id="delta" class="gt_col_heading gt_columns_bottom_border gt_left" scope="col"><div>

delta

<em>bool</em>

</div></th>
</tr>
</thead>
<tbody class="gt_table_body">
<tr>
<td class="gt_row gt_right gd-tbl-rownum">0</td>
<td class="gt_row gt_left" style="max-width: 117px">bar</td>
<td class="gt_row gt_right" style="max-width: 114px">48.77</td>
<td class="gt_row gt_right" style="max-width: 117px">10</td>
<td class="gt_row gt_left" style="max-width: 117px">None</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">1</td>
<td class="gt_row gt_left" style="max-width: 117px">baz</td>
<td class="gt_row gt_right" style="max-width: 114px">79.19</td>
<td class="gt_row gt_right" style="max-width: 117px">81</td>
<td class="gt_row gt_left" style="max-width: 117px">True</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">2</td>
<td class="gt_row gt_left" style="max-width: 117px">foo</td>
<td class="gt_row gt_right" style="max-width: 114px">35.38</td>
<td class="gt_row gt_right" style="max-width: 117px">50</td>
<td class="gt_row gt_left" style="max-width: 117px">True</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">3</td>
<td class="gt_row gt_left" style="max-width: 117px">None</td>
<td class="gt_row gt_right" style="max-width: 114px">43.77</td>
<td class="gt_row gt_right" style="max-width: 117px">NaN</td>
<td class="gt_row gt_left" style="max-width: 117px">None</td>
</tr>
<tr class="gd-tbl-divider">
<td class="gt_row gt_right gd-tbl-rownum">4</td>
<td class="gt_row gt_left" style="max-width: 117px">foo</td>
<td class="gt_row gt_right" style="max-width: 114px">47.08</td>
<td class="gt_row gt_right" style="max-width: 117px">6</td>
<td class="gt_row gt_left" style="max-width: 117px">None</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">10</td>
<td class="gt_row gt_left" style="max-width: 117px">foo</td>
<td class="gt_row gt_right" style="max-width: 114px">55.35</td>
<td class="gt_row gt_right" style="max-width: 117px">26</td>
<td class="gt_row gt_left" style="max-width: 117px">None</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">11</td>
<td class="gt_row gt_left" style="max-width: 117px">None</td>
<td class="gt_row gt_right" style="max-width: 114px">67.44</td>
<td class="gt_row gt_right" style="max-width: 117px">81</td>
<td class="gt_row gt_left" style="max-width: 117px">False</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">12</td>
<td class="gt_row gt_left" style="max-width: 117px">bar</td>
<td class="gt_row gt_right" style="max-width: 114px">None</td>
<td class="gt_row gt_right" style="max-width: 117px">92</td>
<td class="gt_row gt_left" style="max-width: 117px">True</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">13</td>
<td class="gt_row gt_left" style="max-width: 117px">baz</td>
<td class="gt_row gt_right" style="max-width: 114px">40.73</td>
<td class="gt_row gt_right" style="max-width: 117px">91</td>
<td class="gt_row gt_left" style="max-width: 117px">False</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">14</td>
<td class="gt_row gt_left" style="max-width: 117px">foo</td>
<td class="gt_row gt_right" style="max-width: 114px">None</td>
<td class="gt_row gt_right" style="max-width: 117px">93</td>
<td class="gt_row gt_left" style="max-width: 117px">None</td>
</tr>
</tbody>
</table>


# Mixed Python Types

Inf, NaN, None, empty strings, HTML-unsafe characters, and large numbers:


``` python
from gdtest_tbl_preview import sample_types

tbl_preview(sample_types(), show_all=True)
```


<table class="gt_table" data-quarto-disable-processing="true" data-quarto-bootstrap="false">
<thead>
<tr class="gt_heading">
<th colspan="6" class="gt_heading gt_title gt_font_normal"><div style="padding-top: 0; padding-bottom: 7px;">
<span class="gd-tbl-badge" style="background-color: #F0F0F0; color: #333333; border: 1px solid #F0F0F0; margin-right: 8px;">Table</span>Rows6Columns5
</div></th>
</tr>
<tr class="gt_col_headings">
<th class="gt_col_heading gt_columns_bottom_border gt_right" scope="col"></th>
<th id="integer" class="gt_col_heading gt_columns_bottom_border gt_right" scope="col"><div>

integer

<em>i64</em>

</div></th>
<th id="floating" class="gt_col_heading gt_columns_bottom_border gt_right" scope="col"><div>

floating

<em>f64</em>

</div></th>
<th id="boolean" class="gt_col_heading gt_columns_bottom_border gt_left" scope="col"><div>

boolean

<em>bool</em>

</div></th>
<th id="text" class="gt_col_heading gt_columns_bottom_border gt_left" scope="col"><div>

text

<em>str</em>

</div></th>
<th id="big_number" class="gt_col_heading gt_columns_bottom_border gt_right" scope="col"><div>

big_number

<em>i64</em>

</div></th>
</tr>
</thead>
<tbody class="gt_table_body">
<tr>
<td class="gt_row gt_right gd-tbl-rownum">0</td>
<td class="gt_row gt_right" style="max-width: 88px">0</td>
<td class="gt_row gt_right" style="max-width: 95px">0</td>
<td class="gt_row gt_left" style="max-width: 71px">True</td>
<td class="gt_row gt_left" style="max-width: 95px">hello</td>
<td class="gt_row gt_right" style="max-width: 153px">1000000000000000000</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">1</td>
<td class="gt_row gt_right" style="max-width: 88px">1</td>
<td class="gt_row gt_right" style="max-width: 95px">3.14</td>
<td class="gt_row gt_left" style="max-width: 71px">False</td>
<td class="gt_row gt_left" style="max-width: 95px">world</td>
<td class="gt_row gt_right" style="max-width: 153px">1000000000000000</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">2</td>
<td class="gt_row gt_right" style="max-width: 88px">-42</td>
<td class="gt_row gt_right" style="max-width: 95px">-2.718</td>
<td class="gt_row gt_left" style="max-width: 71px">True</td>
<td class="gt_row gt_left" style="max-width: 95px"></td>
<td class="gt_row gt_right" style="max-width: 153px">1000000000000</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">3</td>
<td class="gt_row gt_right" style="max-width: 88px">1000000</td>
<td class="gt_row gt_right" style="max-width: 95px">10000000000</td>
<td class="gt_row gt_left" style="max-width: 71px">False</td>
<td class="gt_row gt_left" style="max-width: 95px">café</td>
<td class="gt_row gt_right" style="max-width: 153px">1000000000</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">4</td>
<td class="gt_row gt_right" style="max-width: 88px">2147483648</td>
<td class="gt_row gt_right" style="max-width: 95px">Inf</td>
<td class="gt_row gt_left gd-tbl-missing" style="max-width: 71px">None</td>
<td class="gt_row gt_left" style="max-width: 95px"><b>bold</b></td>
<td class="gt_row gt_right" style="max-width: 153px">1000000</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">5</td>
<td class="gt_row gt_right gd-tbl-missing" style="max-width: 88px">None</td>
<td class="gt_row gt_right gd-tbl-missing" style="max-width: 95px">NaN</td>
<td class="gt_row gt_left" style="max-width: 71px">True</td>
<td class="gt_row gt_left gd-tbl-missing" style="max-width: 95px">None</td>
<td class="gt_row gt_right" style="max-width: 153px">1000</td>
</tr>
</tbody>
</table>
