我正在尝试找到连胜场次最多的球队，但我不知道如何解决这个问题。
这是我的数据集：
```python
df = {
    "game": ["1201", "1202", "1203", "1204", "1205"],
    "主队": ["B", "C", "D", "E", "D"],
    "客队": ["A", "B", "C", "D", "A"],
    "胜利者": ["主队", "客队", "主队", "客队", "客队"],
}

<details>
<summary>英文:</summary>
I&#39;m trying to find the team/s that have the most consecutive wins, but I don&#39;t know how to approach the question.
This is my dataset:

I am trying to get something like this:
| team | number of wins |
| ---- | -------------- |
|   B  |       2        |
|   D  |       2        |
</details>
# 答案1
**得分**: 2
尝试：
```python
df['winner'] = df['winner'] + ' team'
df_winners = df.melt(['game', 'winner']).query('winner == variable')
print(df_winners)
print(df_winners.groupby('value')['game'].count())

       game     winner   variable value
0  1201  home team  home team     B
6  1202  away team  away team     B
8  1204  away team  away team     D
9  1205  away team  away team     A
    value
A    1
B    2
D    1
Name: game, dtype: int64
#### 更新后纠正输入数据框：
df = {
    "game": ["1201", "1202", "1203", "1204", "1205"],
    "home team": ["B", "C", "D", "E", "D"],
    "away team": ["A", "B", "C ", "D", "A"],
    "winner": ["home", "away", "home", "away", "away"],
}
df = pd.DataFrame(df)
然后运行：
```python
df['winner'] = df['winner'] + ' team'
df_winners = df.melt(['game', 'winner']).query('winner == variable')
print(df_winners)
print(df_winners.groupby('value')['game'].count())

       game     winner   variable value
0  1201  home team  home team     B
2  1203  home team  home team     D
6  1202  away team  away team     B
8  1204  away team  away team     D
9  1205  away team  away team     A
   value
A    1
B    2
D    2
Name: game, dtype: int64