pyspark code to get a sunburst plot using plotly for our aggregated sales data, joined…
- 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.
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()
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.