Web Traffic Analysis Example

Initial Prompt

Analyze monthly website traffic patterns for Q4 2023.

Output

user_proxy (to analyst): Need insights on Q4 website traffic patterns.

analyst (to function):
import pandas as pd
import matplotlib.pyplot as plt

traffic_data = pd.read_csv('web_analytics.csv')
q4_data = traffic_data[traffic_data['date'].between('2023-10-01', '2023-12-31')]

# Daily traffic analysis
daily_traffic = q4_data.groupby('date')['visits'].sum()
peak_day = daily_traffic.idxmax()
peak_traffic = daily_traffic.max()

print(f"Peak Traffic Day: {peak_day}")
print(f"Total Visits: {peak_traffic:,}")
print(f"Average Daily Visits: {daily_traffic.mean():,.0f}")

user_proxy (to analyst):
Analysis Results:
- Peak traffic occurred on Black Friday
- 45% increase in mobile users
- Weekend traffic 2.3x higher than weekdays
- Most active hours: 2PM-6PM EST