如何在"Team"列中随机排列标签"Patriots"和"Colts"?(蟒蛇)



假设这是数据,我如何洗牌标签"爱国者;以及";Colts";在";团队;列并将其附加到新列?

Team  Blakeman  Prioleau    Combined    Pressure Drop
0  Patriots    11.50   11.80   11.650  0.850
1  Patriots    10.85   11.20   11.025  1.475
2  Patriots    11.15   11.50   11.325  1.175
3  Patriots    10.70   11.00   10.850  1.650
4  Patriots    11.10   11.45   11.275  1.225
5  Patriots    11.60   11.95   11.775  0.725
6  Patriots    11.85   12.30   12.075  0.425
7  Patriots    11.10   11.55   11.325  1.175
8  Patriots    10.95   11.35   11.150  1.350
9  Patriots    10.50   10.90   10.700  1.800
10  Patriots    10.90   11.35   11.125  1.375
11   Colts      12.70   12.35   12.525  0.475
12   Colts      12.75   12.30   12.525  0.475
13   Colts      12.50   12.95   12.725  0.275
14   Colts      12.55   12.15   12.350  0.650

你在找这样的东西吗?

import pandas as pd
import numpy as np
df = pd.DataFrame({'Team': ['Patriots','Patriots','Colts'], 'Blakeman':[11.50,10.85,12.70]})
df['new_col'] = np.random.permutation(df['Team'].values)
df
Team      Blakeman  new_col
0   Patriots  11.50     Colts
1   Patriots  10.85     Patriots
2   Colts     12.70     Patriots

最新更新