我有一个数据框:
| product | cost | |
|---|---|---|
| 0 | product a | 56 |
| 1 | product b | 59 |
| 2 | product c | 104 |
我想做一个百分比变化矩阵，如下所示:
| product a | product b | product c | |
|---|---|---|---|
| product a | -5.08% | -46.15% | |
| product b | 5.36% | -43.30% | |
| product c | 85.71% | 76.27% |
可能有n种产品.
如何使用Pandas？
如何获得最高/最低百分比的更改产品？即最高:产品a与产品c.最低:产品c与产品a.
谢谢你的帮助.
Use numpy broadcasting:
# convert columns to arrays
idx = df['product'].to_numpy()
cost = df['cost'].to_numpy()
# compute the percentage change using broadcasting
# convert to DataFrame
out = pd.DataFrame(((cost[:,None]-cost)/cost*100).round(2),
index=idx, columns=idx)
# optional, set NaNs in the diagonal
np.fill_diagonal(out.values, np.nan)
print(out)
输出:
product a product b product c
product a NaN -5.08 -46.15
product b 5.36 NaN -43.27
product c 85.71 76.27 NaN