Skip to main content
 首页 » 编程设计

python之与 pandas 中的组一起操作

2025年02月15日13zhenyulu

我有一个问题让我很头疼。 假设我有下一个数据框:

df2 = pd.DataFrame(np.random.randint(0,3,size=(10, 4)),columns=['ONE', 'TWO', 'CARS', 'FOUR']) 
df2['NAMES'] = ['Peter','Jon','Mary','Mary','Peter','Peter','BONIFACE','Michael','Lucy','Gilari'] 
df2['CARS'] = ['Mercedes','BMW','Ford','BMW','BMW','Dacia','Ford','Pontiac','Chevrolet','Tesla'] 

例如,我按汽车分组。

agrupe = df2.groupby(['CARS']) 

事情是,一旦我对它进行了分组,我就想对其进行操作,例如在 BMW 制作的组中,我想将第 2 列的值分配给第 1 列上具有 2 的元素的第 4 列。让我看看我是否学会了操作它:

g = agrupe.get_group('BMW') 

从这里开始

     ONE TWO CARS  FOUR  NAMES 
1    1    0  BMW     1    Jon 
3    2    1  BMW     1   Mary 
4    0    1  BMW     0  Peter 

为此:

    ONE  TWO CARS  FOUR  NAMES 
1    1    0  BMW     1   Jon 
3    2    1  BMW     1   Mary 
4    0    1  BMW     1  Peter 

请您参考如下方法:

看来你需要groupby使用自定义函数 f:

np.random.seed(100) 
df2 = pd.DataFrame(np.random.randint(0,3,size=(10, 4)),columns=['ONE', 'TWO', 'CARS', 'FOUR']) 
df2['NAMES'] = ['Peter','Jon','Mary','Mary','Peter','Peter','BONIFACE','Michael','Lucy','Gilari'] 
df2['CARS'] = ['Mercedes','BMW','Ford','BMW','BMW','Dacia','Ford','Pontiac','Chevrolet','Tesla'] 
print (df2) 
   ONE  TWO       CARS  FOUR     NAMES 
0    0    0   Mercedes     2     Peter 
1    2    0        BMW     1       Jon 
2    2    2       Ford     2      Mary 
3    1    0        BMW     0      Mary 
4    0    2        BMW     1     Peter 
5    1    2      Dacia     0     Peter 
6    0    1       Ford     1  BONIFACE 
7    0    0    Pontiac     1   Michael 
8    1    2  Chevrolet     2      Lucy 
9    1    1      Tesla     2    Gilari 
def f(x): 
    if (x.name == 'BMW'): 
        x.loc[x.ONE == 2, 'FOUR'] = x.TWO 
    return x 
 
agrupe = df2.groupby('CARS').apply(f) 
print (agrupe) 
   ONE  TWO       CARS  FOUR     NAMES 
0    0    0   Mercedes     2     Peter 
1    2    0        BMW     0       Jon 
2    2    2       Ford     2      Mary 
3    1    0        BMW     0      Mary 
4    0    2        BMW     1     Peter 
5    1    2      Dacia     0     Peter 
6    0    1       Ford     1  BONIFACE 
7    0    0    Pontiac     1   Michael 
8    1    2  Chevrolet     2      Lucy 
9    1    1      Tesla     2    Gilari 

更好的解决方案是首先选择列 CARS 为 BMW 且列 ONE 为 2 的所有行,然后按 TWO 列更改 FOUR:

df2.loc[(df2.CARS == 'BMW') & (df2.ONE == 2), 'FOUR'] = df2.TWO 
print (df2) 
   ONE  TWO       CARS  FOUR     NAMES 
0    0    0   Mercedes     2     Peter 
1    2    0        BMW     0       Jon 
2    2    2       Ford     2      Mary 
3    1    0        BMW     0      Mary 
4    0    2        BMW     1     Peter 
5    1    2      Dacia     0     Peter 
6    0    1       Ford     1  BONIFACE 
7    0    0    Pontiac     1   Michael 
8    1    2  Chevrolet     2      Lucy 
9    1    1      Tesla     2    Gilari 

或者,如果ONE 列中的2 需要更改,则按TWO 列更改FOUR 列:

np.random.seed(13) 
df2 = pd.DataFrame(np.random.randint(0,3,size=(10, 4)),columns=['ONE', 'TWO', 'CARS', 'FOUR']) 
df2['NAMES'] = ['Peter','Jon','Mary','Mary','Peter','Peter','BONIFACE','Michael','Lucy','Gilari'] 
df2['CARS'] = ['Mercedes','BMW','Ford','BMW','BMW','Dacia','Ford','Pontiac','Chevrolet','Tesla'] 
print (df2) 
   ONE  TWO       CARS  FOUR     NAMES 
0    2    0   Mercedes     0     Peter 
1    2    2        BMW     1       Jon 
2    0    2       Ford     0      Mary 
3    2    2        BMW     2      Mary 
4    1    1        BMW     1     Peter 
5    0    2      Dacia     1     Peter 
6    2    1       Ford     2  BONIFACE 
7    0    0    Pontiac     0   Michael 
8    2    2  Chevrolet     0      Lucy 
9    1    1      Tesla     2    Gilari 
 
 
df2.loc[df2.ONE == 2, 'FOUR'] = df2.TWO 
print (df2) 
   ONE  TWO       CARS  FOUR     NAMES 
0    2    0   Mercedes     0     Peter 
1    2    2        BMW     2       Jon 
2    0    2       Ford     0      Mary 
3    2    2        BMW     2      Mary 
4    1    1        BMW     1     Peter 
5    0    2      Dacia     1     Peter 
6    2    1       Ford     1  BONIFACE 
7    0    0    Pontiac     0   Michael 
8    2    2  Chevrolet     2      Lucy 
9    1    1      Tesla     2    Gilari