根据提供的数据,我们可以从以下几个维度对品牌进行分析:
销量占比 = 品牌销量 / 总品牌销量销售额占比 = 品牌销售额 / 总品牌销售额# 示例代码(假设已有DataFrame)
import pandas as pd
# 加载数据
data = pd.read_csv('brand_sales_data.csv')
# 计算各品牌的销售占比
total_sales = data['销量'].sum()
total_revenue = data['销售额'].sum()
sales_ratio = data['销量'] / total_sales * 100
revenue_ratio = data['销售额'] / total_revenue * 100
data['销量占比'] = sales_ratio
data['销售额占比'] = revenue_ratio
# 输出结果
print(data[['品牌', '销量占比', '销售额占比']])
import numpy as np
from scipy.stats import pearsonr
# 加载数据
data = pd.read_csv('brand_sales_data.csv')
# 计算每个品牌的商品数量
unique_items_per_brand = data.groupby('品牌')['商品编号'].nunique().reset_index()
unique_items_per_brand.columns = ['品牌', '商品数']
# 合并数据
combined_data = pd.merge(data, unique_items_per_brand, on='品牌')
combined_data['相关性系数'] = combined_data.apply(lambda row: pearsonr(row['商品数'], row['销量'])[0], axis=1)
print(combined_data[['品牌', '商品数', '销量', '销售额', '相关性系数']])
# 计算每个品牌的关联小店数量
store_count_per_brand = data.groupby('品牌')['店铺编号'].nunique().reset_index()
store_count_per_brand.columns = ['品牌', '关联小店数']
combined_data = pd.merge(combined_data, store_count_per_brand, on='品牌')
print(combined_data[['品牌', '关联小店数', '销量']])
high_revenue_brands = combined_data[combined_data['销售额'] > 10000000]
print(high_revenue_brands[['品牌', '销量', '销售额', '商品数', '关联小店数']])
以上分析数据来源:互联岛