数据收集与预处理
计算关键指标
数据分析与可视化
撰写分析报告
import pandas as pd
import matplotlib.pyplot as plt
# 假设已有数据存储在CSV文件中
data = pd.read_csv('live_data.csv')
# 计算短视频引流占比
data['short_video_ratio'] = data['short_video_visits'] / data['total_visits']
# TOP3直播的引流人次占比
top3_indices = data.sort_values(by='short_video_visits', ascending=False).head(3).index
top3_total_visits = data.loc[top3_indices, 'short_video_visits'].sum()
data['top3_ratio'] = (top3_total_visits / data['total_visits']) * 100
# 绘制短视频引流占比与销售额的关系图
plt.scatter(data['short_video_ratio'], data['sales'])
plt.xlabel('Short Video Ratio')
plt.ylabel('Sales')
plt.title('Short Video Ratio vs Sales')
plt.show()
以上分析数据来源:互联岛