Skip to content
TheChatArchiveThe Chat Archive
Claudeclaude-1· AnthropicHugging Face Arena Human Preference 55K

pyspark code to get a sunburst plot using plotly for our aggregated sales data, joined…

From a Chatbot Arena battleThe same person sent this prompt to two anonymous models at once. Compare it with gpt-4-0314’s answer.
  1. User

    pyspark code to get a sunburst plot using plotly for our aggregated sales data, joined to store and department lookup. Color by revenue green to red. Only return code.

  2. Claude Assistant

    import pyspark from pyspark.sql.functions import *

    from plotly.subplots import make_subplots import plotly.graph_objects as go

    Load data

    sales = spark.read.parquet("sales_data") store = spark.read.parquet("store_lookup") dept = spark.read.parquet("department_lookup")

    Join data

    sales = sales.join(store, "store_id", "left_outer") sales = sales.join(dept, "dept_id", "left_outer")

    Aggregate revenue by [store, department, category]

    agg = sales.groupby("store_name", "department", "category").agg(sum("revenue").alias("revenue"))

    Calculate color scale

    max_rev = agg.select(max("revenue")).collect()[0][0] min_rev = agg.select(min("revenue")).collect()[0][0] color_scale = [ [0, 'green'], [0.5, 'yellow'], [1, 'red'] ]

    Build figure

    fig = make_subplots(rows=1, cols=1, specs=[[{'type':'sunburst'}]])

    for store_name, department, category, revenue in agg.collect(): fig.add_trace( go.Sunburst( labels=[store_name, department, category], parents=[store_name, department], values=[revenue], branchvalues="total", marker=dict( colors= [ [revenue / max_rev for color, _ in color_scale] ] ) ) )

    fig.update_layout( title="Revenue by Store, Department and Category", annotations=[ dict( text="Revenue", showarrow=False, x=0.5, y=0.5, font_size=20, textangle=0) ] )

    fig.show()

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.