第一个

假设您需要多个值和至少一个正数：

g = (df.assign(flag=df['Value'].gt(0))
       .groupby(['State', 'ColorName', 'Code'])
     )

m1 = g.transform('size').gt(1)
m2 = g['flag'].transform('any')

df['Validated'] = np.where(m1&m2, 'Valid', 'Invalid')

输出量：

State ColorName Code  Value Validated
0      Arizona    Yellow    A     50     Valid
1      Alabama    Orange    A    150     Valid
2     Arkansas       Red    B   -500     Valid
3      Kentuky     Green    M    -40   Invalid
4         Ohio      Blue    X    100   Invalid
5      Alabama    Orange    A    -30     Valid
6      Arizona    Yellow    A    100     Valid
7   California      Blue    C    100     Valid
8   California      Blue    C   -100     Valid
9     Arkansas       Red    B    500     Valid
10        Ohio    Yellow    X    100   Invalid
11  California      Blue    C    100     Valid

如果只需要至少一个正值：

df['Validated'] = np.where(m2, 'Valid', 'Invalid')

输出量：

State ColorName Code  Value Validated
0      Arizona    Yellow    A     50     Valid
1      Alabama    Orange    A    150     Valid
2     Arkansas       Red    B   -500     Valid
3      Kentuky     Green    M    -40   Invalid
4         Ohio      Blue    X    100     Valid
5      Alabama    Orange    A    -30     Valid
6      Arizona    Yellow    A    100     Valid
7   California      Blue    C    100     Valid
8   California      Blue    C   -100     Valid
9     Arkansas       Red    B    500     Valid
10        Ohio    Yellow    X    100     Valid
11  California      Blue    C    100     Valid