Talk:Tony Award for Best Lighting Design
{{talkheader}}
{{WikiProject banner shell|class=List|1=
{{WikiProject Musical Theatre}}
{{WikiProject Theatre|importance=mid}}
{{WikiProject Awards|importance=Low}}
{{WikiProject Lists|class=List|importance=Low}}
{{WikiProject Stagecraft|importance=mid}}
}}
{{SubArticle|Tony Awards}}
Convert table to "long" format
Most Tony Awards are split into separate wikipedia pages for their different categories/genres (musical vs. play). In this case, the award is condensed to a single page. Being that this might be confusing for data ingestion / data pipelines, I'm going to suggest we convert the data from wide to long, like as is done for Tony Award for Best Sound Design.
= Current data state =
| class="wikitable" style="width:60%;"
! style="width:10%;" |Year ! style="width:25%;”" |Designer ! style="width:25%;”" |Production |
| rowspan="11" align="center" |2010 {{small|64th Tony Awards}} |
| colspan="2" |Lighting Design for a Play |
|---|
| style="background:#B0C4DE"
|Neil Austin |Red |
| Neil Austin |
| Mark Henderson |
| Brian MacDevitt |
| colspan="2" |Lighting Design for a Musical |
| style="background:#B0C4DE" |
| Donald Holder |
| Nick Richings |
| Robert Wierzel |
= Suggested data state =
| class="wikitable" style="width:80%;"
! style="width:10%;" |Year ! style="width:25%;”" |Designer ! style="width:25%;”" |Production ! style="width:25%;”" |Award Type |
| rowspan="11" align="center" |2010 {{small|64th Tony Awards}} |
| style="background:#B0C4DE"
|Neil Austin |Red | Best Lighting Design for a Play |
| Neil Austin
| Best Lighting Design for a Play |
| Mark Henderson
| Best Lighting Design for a Play |
| Brian MacDevitt
| Best Lighting Design for a Play |
| style="background:#B0C4DE"
| Best Lighting Design for a Musical |
| Donald Holder
| Best Lighting Design for a Musical |
| Nick Richings
| Best Lighting Design for a Musical |
| Robert Wierzel
| Best Lighting Design for a Musical |
Yaakov bressler (talk) 19:00, 3 January 2021 (UTC)
= Work in Progress: Variants of explicit Tony Award categorization (with long format) =
Below are 2 variants of a wide + explicit table format. Which format does the community prefer? (Note: I've included them as screenshots instead of code.)
File:Screenshot of variant 1 – explicit Tony Award categorization for wide data .png|Variant 1 – rowspan labels + explicit field
File:Screenshot of variant 2 – explicit Tony Award categorization for wide data.png|Variant 2 – explicit field as multi-index attribute
Yaakov bressler (talk) 15:46, 5 January 2021 (UTC)