P50PandasBeginnerChoose10 min

Choose Wide or Long Format for Weekly Channel Metrics

Choose a table shape for weekly channel trend analysis and visualization.

#choose#wide#long-format

Scenario

Weekly metrics currently have columns email_revenue, search_revenue, and social_revenue. The team needs filters, channel comparisons, and a line chart by week.

Problem statement

Choose the preferred shape and justify it.

Your Task

  1. Choose wide or long format.
  2. Explain filtering and chart benefits.
  3. Name a case where wide is still useful.

Related Concepts

Tidy dataMeltVisualization

Ready to count this problem?

Mark it complete when you have reasoned through the solution in your own words.