我有两列名为“family”和“severity”的列。我想要拆分“severity”列中的唯一值，并在新创建的列中找到“family”列的出现次数。
初始数据框架：
```python
df
family severity
AA     High
BB     Critical
CC     Medium
DD     Low
AA     Low
CC     High

df_output
family Critical High Medium Low Total
AA       0       1     0     1    2
BB       1       0     0     0    1
CC       0       1     1     0    2
DD       0       0     0     1    1
Total    1       2     1     2    6

这是翻译好的部分，没有其他内容。
<details>
<summary>英文:</summary>
I have two columns called &quot;family&quot; and &quot;severity&quot;. I would like to split the unique values in the &quot;severity&quot; column and find the occurrences of column &quot;family&quot; in newly created columns.
Initial Dataframe:

Output

</details>
# 答案1
**得分**: 4
使用 [`crosstab`](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.crosstab.html) 并使用 `margins=True`：
```python
final = pd.crosstab(df['family'], df['severity'], margins=True, margins_name='Total').rename_axis(None, axis=1)
print(final)

            Critical  High  Low  Medium  Total
    family                                  
    AA             0     1    1       0      2
    BB             1     0    0       0      1
    CC             0     1    0       1      2
    DD             0     0    1       0      1
    Total          1     2    2       1      6