```
import pandas as pd
import numpy as np

data_agency = pd.read_excel("Sample.xlsm")

```

[![enter image description here](https://i.stack.imgur.com/stRyc.png)](https://i.stack.imgur.com/stRyc.png)

```
data_agency.groupby(['Person']).sum()

```

But I get something similar to only a single row's of data instead:
[![enter image description here](https://i.stack.imgur.com/ci25t.png)](https://i.stack.imgur.com/ci25t.png)

`type(data_agency['Person'].iloc[0])` returns a `str` type

`type(data_agency['Reg Hrs.'].iloc[0])` returns a `float64` type