I have the dataframe presented bellow:

```
import pandas as pd

data=pd.DataFrame({"Year": [1982, 1983, 1982, 1983, 1984, 1982],
                   "Status": ["Yes", "No", "Yes", "Yes", "No", "No"]})

```

I need to aggregate values by `'Year'` and `'Status'` columns and count values in `'Status'` column.

My code below does not give the result I expected.

```
evo=data.groupby(['Year','Status'] )['Status'].value_counts()

Year  Status  Status
1982  No      No        1
      Yes     Yes       2
1983  No      No        1
      Yes     Yes       1
1984  No      No        1
Name: Status, dtype: int64

```

**Desired result presented bellow:**

|  | Year | Status\_yes | Count\_yes | Status\_no | Count\_no |
| --- | --- | --- | --- | --- | --- |
| 0 | 1982 | yes | 2 | no | 1 |
| 1 | 1983 | yes | 1 | no | 1 |
| 2 | 1984 | yes | 0 | no | 1 |

I wish I can get evo dataframe and use for the plot figures later. How could I do that? Thanks a lot!