找到拥有效率最高的团队的部门(需要培训的员工比例最小的团队)。

Question

进口numpy作为np进口熊猫作为pd

该文件存储在以下路径：

'https://media-doselect.s3.amazonaws.com/generic/NMgEjwkAEGGQZBoNYGr9Ld7w0/rating.csv‘

df = pd.read_csv('https://media-doselect.s3.amazonaws.com/generic/NMgEjwkAEGGQZBoNYGr9Ld7w0/rating.csv') df‘’Training‘= df.Rating.apply(lambda：'No’如果x <= 3.5其他‘是’是‘) df.head()

Answer 1

如果我没听错的话？

import pandas as pd


df = pd.read_csv('https://media-doselect.s3.amazonaws.com/generic/NMgEjwkAEGGQZBoNYGr9Ld7w0/rating.csv')

df = (
    df
    .groupby("Department")["Rating"]
    .mean()
    .reset_index()
    .min()["Department"]
)

print(df)

Finance