# Pandas Tables


# Pandas DataFrame

Pass a Pandas DataFrame directly. The preview auto-detects the library and shows a **Pandas** badge.


``` python
import pandas as pd
from great_docs import tbl_preview

df = pd.DataFrame({
    "name": ["Alice", "Bob", "Charlie", "Diana", "Eve",
             "Frank", "Grace", "Hank", "Iris", "Jack",
             "Kate", "Leo", "Mia", "Noah", "Olivia"],
    "department": ["Eng", "Sales", "Eng", "HR", "Sales",
                   "Eng", "HR", "Sales", "Eng", "HR",
                   "Sales", "Eng", "HR", "Sales", "Eng"],
    "salary": [95000, 72000, 88000, 65000, 78000,
              105000, 62000, 81000, 92000, 58000,
              74000, 110000, 67000, 83000, 97000],
    "years": [5, 3, 7, 2, 4, 10, 1, 6, 8, 3, 4, 12, 2, 5, 9],
})

tbl_preview(df)
```


<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: #150458; color: #FFFFFF; border: 1px solid #150458; margin-right: 8px;">Pandas</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="name" class="gt_col_heading gt_columns_bottom_border gt_left" scope="col"><div>

name

<em>str</em>

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

department

<em>str</em>

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

salary

<em>i64</em>

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

years

<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_left" style="max-width: 112px">Alice</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">95000</td>
<td class="gt_row gt_right" style="max-width: 101px">5</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">1</td>
<td class="gt_row gt_left" style="max-width: 112px">Bob</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">72000</td>
<td class="gt_row gt_right" style="max-width: 101px">3</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">2</td>
<td class="gt_row gt_left" style="max-width: 112px">Charlie</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">88000</td>
<td class="gt_row gt_right" style="max-width: 101px">7</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">3</td>
<td class="gt_row gt_left" style="max-width: 112px">Diana</td>
<td class="gt_row gt_left" style="max-width: 140px">HR</td>
<td class="gt_row gt_right" style="max-width: 109px">65000</td>
<td class="gt_row gt_right" style="max-width: 101px">2</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: 112px">Eve</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">78000</td>
<td class="gt_row gt_right" style="max-width: 101px">4</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">10</td>
<td class="gt_row gt_left" style="max-width: 112px">Kate</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">74000</td>
<td class="gt_row gt_right" style="max-width: 101px">4</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">11</td>
<td class="gt_row gt_left" style="max-width: 112px">Leo</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">110000</td>
<td class="gt_row gt_right" style="max-width: 101px">12</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">12</td>
<td class="gt_row gt_left" style="max-width: 112px">Mia</td>
<td class="gt_row gt_left" style="max-width: 140px">HR</td>
<td class="gt_row gt_right" style="max-width: 109px">67000</td>
<td class="gt_row gt_right" style="max-width: 101px">2</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">13</td>
<td class="gt_row gt_left" style="max-width: 112px">Noah</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">83000</td>
<td class="gt_row gt_right" style="max-width: 101px">5</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">14</td>
<td class="gt_row gt_left" style="max-width: 112px">Olivia</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">97000</td>
<td class="gt_row gt_right" style="max-width: 101px">9</td>
</tr>
</tbody>
</table>


# Custom Head and Tail

Show 8 rows from the top and 3 from the bottom:


``` python
tbl_preview(df, n_head=8, n_tail=3)
```


<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: #150458; color: #FFFFFF; border: 1px solid #150458; margin-right: 8px;">Pandas</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="name" class="gt_col_heading gt_columns_bottom_border gt_left" scope="col"><div>

name

<em>str</em>

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

department

<em>str</em>

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

salary

<em>i64</em>

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

years

<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_left" style="max-width: 112px">Alice</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">95000</td>
<td class="gt_row gt_right" style="max-width: 101px">5</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">1</td>
<td class="gt_row gt_left" style="max-width: 112px">Bob</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">72000</td>
<td class="gt_row gt_right" style="max-width: 101px">3</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">2</td>
<td class="gt_row gt_left" style="max-width: 112px">Charlie</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">88000</td>
<td class="gt_row gt_right" style="max-width: 101px">7</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">3</td>
<td class="gt_row gt_left" style="max-width: 112px">Diana</td>
<td class="gt_row gt_left" style="max-width: 140px">HR</td>
<td class="gt_row gt_right" style="max-width: 109px">65000</td>
<td class="gt_row gt_right" style="max-width: 101px">2</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">4</td>
<td class="gt_row gt_left" style="max-width: 112px">Eve</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">78000</td>
<td class="gt_row gt_right" style="max-width: 101px">4</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">5</td>
<td class="gt_row gt_left" style="max-width: 112px">Frank</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">105000</td>
<td class="gt_row gt_right" style="max-width: 101px">10</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">6</td>
<td class="gt_row gt_left" style="max-width: 112px">Grace</td>
<td class="gt_row gt_left" style="max-width: 140px">HR</td>
<td class="gt_row gt_right" style="max-width: 109px">62000</td>
<td class="gt_row gt_right" style="max-width: 101px">1</td>
</tr>
<tr class="gd-tbl-divider">
<td class="gt_row gt_right gd-tbl-rownum">7</td>
<td class="gt_row gt_left" style="max-width: 112px">Hank</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">81000</td>
<td class="gt_row gt_right" style="max-width: 101px">6</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">12</td>
<td class="gt_row gt_left" style="max-width: 112px">Mia</td>
<td class="gt_row gt_left" style="max-width: 140px">HR</td>
<td class="gt_row gt_right" style="max-width: 109px">67000</td>
<td class="gt_row gt_right" style="max-width: 101px">2</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">13</td>
<td class="gt_row gt_left" style="max-width: 112px">Noah</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">83000</td>
<td class="gt_row gt_right" style="max-width: 101px">5</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">14</td>
<td class="gt_row gt_left" style="max-width: 112px">Olivia</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">97000</td>
<td class="gt_row gt_right" style="max-width: 101px">9</td>
</tr>
</tbody>
</table>


# Show All Rows


``` python
tbl_preview(df, show_all=True)
```


<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: #150458; color: #FFFFFF; border: 1px solid #150458; margin-right: 8px;">Pandas</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="name" class="gt_col_heading gt_columns_bottom_border gt_left" scope="col"><div>

name

<em>str</em>

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

department

<em>str</em>

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

salary

<em>i64</em>

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

years

<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_left" style="max-width: 112px">Alice</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">95000</td>
<td class="gt_row gt_right" style="max-width: 101px">5</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">1</td>
<td class="gt_row gt_left" style="max-width: 112px">Bob</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">72000</td>
<td class="gt_row gt_right" style="max-width: 101px">3</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">2</td>
<td class="gt_row gt_left" style="max-width: 112px">Charlie</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">88000</td>
<td class="gt_row gt_right" style="max-width: 101px">7</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">3</td>
<td class="gt_row gt_left" style="max-width: 112px">Diana</td>
<td class="gt_row gt_left" style="max-width: 140px">HR</td>
<td class="gt_row gt_right" style="max-width: 109px">65000</td>
<td class="gt_row gt_right" style="max-width: 101px">2</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">4</td>
<td class="gt_row gt_left" style="max-width: 112px">Eve</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">78000</td>
<td class="gt_row gt_right" style="max-width: 101px">4</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">5</td>
<td class="gt_row gt_left" style="max-width: 112px">Frank</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">105000</td>
<td class="gt_row gt_right" style="max-width: 101px">10</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">6</td>
<td class="gt_row gt_left" style="max-width: 112px">Grace</td>
<td class="gt_row gt_left" style="max-width: 140px">HR</td>
<td class="gt_row gt_right" style="max-width: 109px">62000</td>
<td class="gt_row gt_right" style="max-width: 101px">1</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">7</td>
<td class="gt_row gt_left" style="max-width: 112px">Hank</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">81000</td>
<td class="gt_row gt_right" style="max-width: 101px">6</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">8</td>
<td class="gt_row gt_left" style="max-width: 112px">Iris</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">92000</td>
<td class="gt_row gt_right" style="max-width: 101px">8</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">9</td>
<td class="gt_row gt_left" style="max-width: 112px">Jack</td>
<td class="gt_row gt_left" style="max-width: 140px">HR</td>
<td class="gt_row gt_right" style="max-width: 109px">58000</td>
<td class="gt_row gt_right" style="max-width: 101px">3</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">10</td>
<td class="gt_row gt_left" style="max-width: 112px">Kate</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">74000</td>
<td class="gt_row gt_right" style="max-width: 101px">4</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">11</td>
<td class="gt_row gt_left" style="max-width: 112px">Leo</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">110000</td>
<td class="gt_row gt_right" style="max-width: 101px">12</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">12</td>
<td class="gt_row gt_left" style="max-width: 112px">Mia</td>
<td class="gt_row gt_left" style="max-width: 140px">HR</td>
<td class="gt_row gt_right" style="max-width: 109px">67000</td>
<td class="gt_row gt_right" style="max-width: 101px">2</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">13</td>
<td class="gt_row gt_left" style="max-width: 112px">Noah</td>
<td class="gt_row gt_left" style="max-width: 140px">Sales</td>
<td class="gt_row gt_right" style="max-width: 109px">83000</td>
<td class="gt_row gt_right" style="max-width: 101px">5</td>
</tr>
<tr>
<td class="gt_row gt_right gd-tbl-rownum">14</td>
<td class="gt_row gt_left" style="max-width: 112px">Olivia</td>
<td class="gt_row gt_left" style="max-width: 140px">Eng</td>
<td class="gt_row gt_right" style="max-width: 109px">97000</td>
<td class="gt_row gt_right" style="max-width: 101px">9</td>
</tr>
</tbody>
</table>
