下面是我的数据: Dataframe -- df_AW17
Product ID Season Division Brand Category Sub Category AW16 (Sales) AW17 (Sales)
Blazer 1 AW17 Men's Wear Brand 1 Top BLAZER 198
Blazer 2 AW16 Men's Wear Brand 1 Top BLAZER 138
Blazer 2 AW17 Men's Wear Brand 1 Top BLAZER 270
Blazer 3 AW17 Men's Wear Brand 1 Top BLAZER 27
Blazer 4 AW17 Men's Wear Brand 1 Top BLAZER 192
Blazer-10 AW17 Women's Wear Brand 1 Top BLAZER 15
Blazer-11 AW16 Women's Wear Brand 1 Top BLAZER 10
Blazer-11 AW17 Women's Wear Brand 1 Top BLAZER 14
Blazer-12 AW17 Women's Wear Brand 1 Top BLAZER 16
Blazer-13 AW17 Women's Wear Brand 1 Top BLAZER 207
Blazer-5 AW16 Women's Wear Brand 1 Top BLAZER 126
Blazer-5 AW17 Women's Wear Brand 1 Top BLAZER 200
Blazer-6 AW17 Men's Wear Brand 1 Top BLAZER 5
Blazer-7 AW17 Women's Wear Brand 1 Top BLAZER 299
Blazer-8 AW17 Women's Wear Brand 1 Top BLAZER 147
Blazer-9 AW17 Men's Wear Brand 1 Top BLAZER 23
Jacket-10 AW17 Men's Wear Brand 1 Top JACKETS 20
Jacket-11 AW17 Men's Wear Brand 1 Top JACKETS 5
Jacket-12 AW16 Men's Wear Brand 1 Top JACKETS 5
Jacket-12 AW17 Men's Wear Brand 1 Top JACKETS 12
Jacket-13 AW16 Women's Wear Brand 1 Top JACKETS 15它有产品ID作为值,我需要使用Season AW16,AW17和AW16 ( sales ),AW17 ( Sales )的给定销售额来获得销售增长%作为新列。问题是我无法分组或放入公式,因为对于特定的Product ID,Sales的列值在不同的行中。
我曾经试过这样做。
df_AW17['Sales Growth %'] = df_AW17.groupby(['Product ID'])(((df_AW17['AW17 (Sales)'] - df_AW17['AW16 (Sales)']) / df_AW17['AW16 (Sales)']) * 100)。
我想要的结果是从特定于产品ID的年份AW16 (销售额)到AW17 (销售额)的(销售额增长%)。
发布于 2020-04-09 16:26:14
由于数据帧中的所有行似乎都有惟一的产品in,那么下面创建新列的更简单的方法是否不能实现这个目的呢?
df_AW17['Sales_growth_pct'] = (df_AW17['AW17 (Sales)'] - df_AW17['AW16 (Sales)']) / df_AW17['AW16 (Sales)']https://stackoverflow.com/questions/61114207
复制相似问题