# Pandas



# Set max row for dataframe output

```python
# max row to display dataframe set to 7
import pandas as pd
pd.set_option('display.max_rows', 7)
```

# Combine df with concat

```python
# Combine all dataframe with concat
frame_format = [df_f0_f1, df_f1_f2, df_f2_f3, df_f3_f4, df_f4_f5]
df_all = pd.concat(frame_format, sort = False)
```

# Create histogram from df

##### df\_trace\_person\_count sample:

<table border="1" class="dataframe" id="bkmrk-%C2%A0-trace-id-no-of-uni" style="width: 63.9506%;"><thead><tr><th style="width: 10.5172%;"> </th><th style="width: 56.6861%;">trace id</th><th style="width: 32.7995%;">no of unique person</th></tr></thead><tbody><tr><th style="width: 10.5172%;">0</th><td style="width: 56.6861%;">TRACE\_PERSON\_0000000003</td><td style="width: 32.7995%;">16</td></tr><tr><th style="width: 10.5172%;">1</th><td style="width: 56.6861%;">TRACE\_PERSON\_0000000005</td><td style="width: 32.7995%;">20</td></tr><tr><th style="width: 10.5172%;">2</th><td style="width: 56.6861%;">TRACE\_PERSON\_0000000011</td><td style="width: 32.7995%;">5</td></tr><tr><th style="width: 10.5172%;">...</th><td style="width: 56.6861%;">...</td><td style="width: 32.7995%;">...</td></tr><tr><th style="width: 10.5172%;">313</th><td style="width: 56.6861%;">TRACE\_PERSON\_0000000995</td><td style="width: 32.7995%;">20</td></tr><tr><th style="width: 10.5172%;">314</th><td style="width: 56.6861%;">TRACE\_PERSON\_0000000998</td><td style="width: 32.7995%;">6</td></tr><tr><th style="width: 10.5172%;">315</th><td style="width: 56.6861%;">TRACE\_PERSON\_0000000999</td><td style="width: 32.7995%;">8</td></tr></tbody></table>

##### Code:

```python
import matplotlib.pyplot as plt

fig = plt.figure(figsize=(10,10)) 
axes1 = fig.add_subplot(1,1,1)
axes1.hist(df_trace_person_count['no of unique person'],bins=72, color='black')
axes1.set_xlabel('Count of people')
axes1.set_ylabel('Count of clusters')
```

##### Result:

[![image.png](https://bookstack.fscene8.me/uploads/images/gallery/2024-01/scaled-1680-/HTgimage.png)](https://bookstack.fscene8.me/uploads/images/gallery/2024-01/HTgimage.png)