Data Analysis Report Writing and Presentation: Code Examples for Various Business Scenarios

Data analysis report writing and presentation involves turning analytical results into clear, understandable visual and textual outputs for stakeholders. The following sections illustrate how to perform typical analyses in different business contexts using Python's pandas for data manipulation and matplotlib for visualization.

E‑commerce scenario : Analyze sales data to show monthly sales trends, top‑selling products, and customer segmentation.

import pandas as
import matplotlib.pyplot as
# 读取销售数据
sales_data = pd.read_csv('sales_data.csv')
# 绘制销售趋势图
sales_data['Date'] = pd.to_datetime(sales_data['Date'])
monthly_sales = sales_data.resample('M', on='Date')['Revenue'].sum()
monthly_sales.plot(kind='line', marker='o')
plt.xlabel('Month')
plt.ylabel('Revenue')
plt.title('Monthly Sales Trend')
plt.show()
# 计算最畅销产品
top_products = sales_data.groupby('Product')['Quantity'].sum().nlargest(5)
print(top_products)
# 进行客户细分
customer_segments = sales_data.groupby('CustomerID')['Revenue'].sum()
customer_segments.hist(bins=10)
plt.xlabel('Revenue')
plt.ylabel('Number of Customers')
plt.title('Customer Segments')
plt.show()

Market research scenario : Analyze survey data to present response distribution, key metrics, and textual insights.

import pandas as
import matplotlib.pyplot as
# 读取调研数据
survey_data = pd.read_csv('survey_data.csv')
# 统计调研结果
survey_results = survey_data['Response'].value_counts()
print(survey_results)
# 绘制关键指标图表
key_metrics = survey_data.groupby('Category')['Rating'].mean()
key_metrics.plot(kind='bar')
plt.xlabel('Category')
plt.ylabel('Average Rating')
plt.title('Key Metrics')
plt.show()
# 分析洞察
insights = survey_data.groupby('Category')['Comment'].apply(lambda x: ', '.join(x))
print(insights)

Healthcare scenario : Analyze patient data to show disease distribution, visit trends, and identify high‑risk patients.

import pandas as
import matplotlib.pyplot as
# 读取患者数据
patient_data = pd.read_csv('patient_data.csv')
# 统计疾病情况
disease_counts = patient_data['Disease'].value_counts()
print(disease_counts)
# 绘制就诊趋势图
patient_data['VisitDate'] = pd.to_datetime(patient_data['VisitDate'])
daily_visits = patient_data.resample('D', on='VisitDate')['PatientID'].nunique()
daily_visits.plot(kind='line', marker='o')
plt.xlabel('Date')
plt.ylabel('Number of Visits')
plt.title('Daily Visit Trend')
plt.show()
# 提供医疗建议
high_risk_patients = patient_data[patient_data['RiskLevel'] == 'High']
print(high_risk_patients)

Financial scenario : Analyze investment data to display portfolio performance, risk assessment, and asset distribution.

import pandas as
import matplotlib.pyplot as
# 读取投资数据
investment_data = pd.read_csv('investment_data.csv')
# 计算投资组合表现
investment_data['Date'] = pd.to_datetime(investment_data['Date'])
investment_data['PortfolioValue'] = investment_data['Shares'] * investment_data['Price']
portfolio_performance = investment_data.groupby('Date')['PortfolioValue'].sum()
portfolio_performance.plot(kind='line', marker='o')
plt.xlabel('Date')
plt.ylabel('Portfolio Value')
plt.title('Portfolio Performance')
plt.show()
# 进行风险评估
risk_assessment = investment_data.groupby('Asset')['Return'].std()
print(risk_assessment)
# 分析资产分布
asset_distribution = investment_data.groupby('Asset')['Shares'].sum()
asset_distribution.plot(kind='pie', autopct='%1.1f%%')
plt.title('Asset Distribution')
plt.show()

Social media scenario : Analyze user behavior data to illustrate user growth, activity distribution, and content trends.

import pandas as
import matplotlib.pyplot as
# 读取用户行为数据
user_data = pd.read_csv('user_data.csv')
# 统计用户增长情况
user_growth = user_data.resample('M', on='Date')['UserID'].nunique()
user_growth.plot(kind='line', marker='o')
plt.xlabel('Month')
plt.ylabel('Number of Users')
plt.title('User Growth')
plt.show()
# 计算用户活跃度
user_activity = user_data.groupby('UserID')['Interactions'].sum()
user_activity.hist(bins=10)
plt.xlabel('Interactions')
plt.ylabel('Number of Users')
plt.title('User Activity')
plt.show()
# 分析内容趋势
content_trends = user_data.groupby('Category')['Views'].sum()
content_trends.plot(kind='bar')
plt.xlabel('Category')
plt.ylabel('Total Views')
plt.title('Content Trends')
plt.show()

These examples demonstrate how to adapt data analysis techniques to different domains, adjust visualizations, and incorporate findings into a structured report. A suggested report template includes sections such as cover page, table of contents, executive summary, introduction, methodology, results, discussion, conclusion, references, and appendix for code.

1. 封面页
   - 报告标题
   - 报告日期
   - 作者/团队名称
   - 公司/组织名称

2. 目录
   - 列出报告中各个部分的标题和页码

3. 摘要/总结
   - 对报告的主要内容进行简要概述
   - 强调关键发现和结论

4. 引言
   - 介绍报告的背景和目的
   - 解释数据来源和数据收集方法

5. 数据分析方法
   - 描述用于分析数据的方法和技术
   - 包括数据清洗、数据处理、统计分析等步骤

6. 数据分析结果
   - 使用图表、表格等可视化工具展示分析结果
   - 解释每个图表和表格的含义和洞察
   - 引用关键指标和统计数据

7. 结果解释和讨论
   - 解释分析结果的意义和影响
   - 分析发现的原因和驱动因素
   - 讨论可能的改进措施和建议

8. 结论
   - 总结报告的主要发现和结论
   - 强调报告的价值和意义

9. 参考文献/数据来源
   - 引用使用的文献、参考资料或数据来源

10. 附录
   - 包括用于分析的代码示例、数据处理步骤等详细信息