search

owid / etl

A compute graph for loading and transforming OWID's data
https://docs.owid.io/projects/etl
MIT License
58 stars 18 forks source link

🐛 chart-diff: undetected conflicts #2892

Closed lucasrodes closed 4 days ago

lucasrodes commented 5 days ago

We detect conflicts currently based on whether a chart has an update timestamp more recent in master than in staging. This captures some conflicts but not all of them.

Solution

Create a new table: chart_diff_conflicts to track if a conflict was resolved. A conflict is uniquely identified by chart_id and updatedAt (in target). If the conflict is resolved, we add an entry with conflict="resolved".

Note: Should be merged after merging:

Context

In the diagram below, we show two scenarios:

Scenario 1: Reflects what we've been doing this far Scenario 2: Reflects a case when the user first branches out, and before updating a chart, someone goes and edits this chart on master.

Some definitions:

image

owidbot commented 5 days ago
Quick links (staging server): Site Admin Wizard

Login: ssh owid@staging-site-chart-diff-conflict

chart-diff: ✅
  • 1/1 reviewed charts
    • Modified: 1/1
    • New: 0/0
data-diff: ❌ Found differences ```diff = Dataset garden/energy/2024-06-20/electricity_mix = Table electricity_mix ~ Column coal_generation__twh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year coal_generation__twh - coal_generation__twh + Asia 2023 NaN 8696.457031 Europe 2023 NaN 622.725159 High-income countries 2023 NaN 1781.384521 South America 2023 NaN 38.435528 Upper-middle-income countries 2023 NaN 6705.588379 ~ Column coal_share_of_electricity__pct (changed data) ~ Changed values: 10 / 10138 (0.10%) country year coal_share_of_electricity__pct - coal_share_of_electricity__pct + Asia 2023 NaN 52.269951 Europe 2023 NaN 13.257526 High-income countries 2023 NaN 15.891244 South America 2023 NaN 2.945224 Upper-middle-income countries 2023 NaN 48.562599 ~ Column direct_primary_energy_consumption__twh (changed data) ~ Changed values: 45 / 10138 (0.44%) country year direct_primary_energy_consumption__twh - direct_primary_energy_consumption__twh + High-income countries 2023 NaN 56370.949219 Lower-middle-income countries 1970 1258.734741 1305.932129 Lower-middle-income countries 1987 6563.684570 6733.767578 Lower-middle-income countries 1990 7638.102539 7861.853516 Lower-middle-income countries 1997 7850.183594 8095.404785 ~ Column fossil_generation__twh (changed data) ~ Changed values: 24 / 10138 (0.24%) country year fossil_generation__twh - fossil_generation__twh + Lower-middle-income countries 1990 NaN 512.421509 Lower-middle-income countries 1991 NaN 526.002991 Lower-middle-income countries 1994 NaN 538.960022 Lower-middle-income countries 2023 NaN 2261.270996 South America 2023 NaN 279.340790 ~ Column fossil_share_of_electricity__pct (changed data) ~ Changed values: 24 / 10138 (0.24%) country year fossil_share_of_electricity__pct - fossil_share_of_electricity__pct + Lower-middle-income countries 1990 NaN 59.574398 Lower-middle-income countries 1991 NaN 59.592144 Lower-middle-income countries 1994 NaN 58.939022 Lower-middle-income countries 2023 NaN 64.246201 South America 2023 NaN 21.405224 ~ Column gas_generation__twh (changed data) ~ Changed values: 24 / 10138 (0.24%) country year gas_generation__twh - gas_generation__twh + Lower-middle-income countries 1990 NaN 106.621025 Lower-middle-income countries 1991 NaN 115.229462 Lower-middle-income countries 1994 NaN 132.685898 Lower-middle-income countries 2023 NaN 589.343689 South America 2023 NaN 203.292053 ~ Column gas_share_of_electricity__pct (changed data) ~ Changed values: 24 / 10138 (0.24%) country year gas_share_of_electricity__pct - gas_share_of_electricity__pct + Lower-middle-income countries 1990 NaN 12.395817 Lower-middle-income countries 1991 NaN 13.054623 Lower-middle-income countries 1994 NaN 14.510124 Lower-middle-income countries 2023 NaN 16.744164 South America 2023 NaN 15.577789 ~ Column hydro_generation__twh (changed data) ~ Changed values: 45 / 10138 (0.44%) country year hydro_generation__twh - hydro_generation__twh + High-income countries 2023 NaN 1263.528687 Lower-middle-income countries 1970 NaN 45.889198 Lower-middle-income countries 1987 NaN 109.135948 Lower-middle-income countries 1990 NaN 134.793259 Lower-middle-income countries 1997 NaN 146.052856 ~ Column hydro_share_of_electricity__pct (changed data) ~ Changed values: 25 / 10138 (0.25%) country year hydro_share_of_electricity__pct - hydro_share_of_electricity__pct + Europe 2023 NaN 16.520908 Lower-middle-income countries 1985 NaN 16.291794 Lower-middle-income countries 1991 NaN 16.133011 Lower-middle-income countries 1996 NaN 15.672986 Lower-middle-income countries 1999 NaN 15.053476 ~ Column low_carbon_generation__twh (changed data) ~ Changed values: 45 / 10138 (0.44%) country year low_carbon_generation__twh - low_carbon_generation__twh + High-income countries 2023 NaN 5351.831543 Lower-middle-income countries 1970 NaN 47.197342 Lower-middle-income countries 1987 NaN 170.083176 Lower-middle-income countries 1990 NaN 223.750626 Lower-middle-income countries 1997 NaN 245.221191 ~ Column low_carbon_share_of_electricity__pct (changed data) ~ Changed values: 25 / 10138 (0.25%) country year low_carbon_share_of_electricity__pct - low_carbon_share_of_electricity__pct + Europe 2023 NaN 59.752853 Lower-middle-income countries 1985 NaN 26.029053 Lower-middle-income countries 1991 NaN 25.981586 Lower-middle-income countries 1996 NaN 25.464617 Lower-middle-income countries 1999 NaN 23.789312 ~ Column nuclear_generation__twh (changed data) ~ Changed values: 11 / 10138 (0.11%) country year nuclear_generation__twh - nuclear_generation__twh + Europe 2023 NaN 965.053162 High-income countries 2023 NaN 1880.554199 Lower-middle-income countries 2023 NaN 129.621185 South America 2023 NaN 23.473022 Upper-middle-income countries 2023 NaN 724.774048 ~ Column nuclear_share_of_electricity__pct (changed data) ~ Changed values: 10 / 10138 (0.10%) country year nuclear_share_of_electricity__pct - nuclear_share_of_electricity__pct + Asia 2023 NaN 4.944662 Europe 2023 NaN 20.545528 High-income countries 2023 NaN 16.775909 South America 2023 NaN 1.798682 Upper-middle-income countries 2023 NaN 5.248893 ~ Column oil_generation__twh (changed data) ~ Changed values: 99 / 10138 (0.98%) country year oil_generation__twh - oil_generation__twh + Europe 1985 NaN 377.883972 European Union (27) 1993 NaN 196.928940 Lower-middle-income countries 1990 NaN 98.068466 North America 1994 NaN 203.660309 Upper-middle-income countries 1988 NaN 304.004517 ~ Column oil_share_of_electricity__pct (changed data) ~ Changed values: 99 / 10138 (0.98%) country year oil_share_of_electricity__pct - oil_share_of_electricity__pct + Europe 1985 NaN 9.828362 European Union (27) 1993 NaN 8.547535 Lower-middle-income countries 1990 NaN 11.401492 North America 1994 NaN 4.837090 Upper-middle-income countries 1988 NaN 11.614008 ~ Column other_renewables_including_bioenergy_generation__twh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year other_renewables_including_bioenergy_generation__twh - other_renewables_including_bioenergy_generation__twh + Asia 2023 NaN 388.483917 Europe 2023 NaN 203.489655 High-income countries 2023 NaN 359.011902 South America 2023 NaN 72.123505 Upper-middle-income countries 2023 NaN 345.392395 ~ Column other_renewables_including_bioenergy_share_of_electricity__pct (changed data) ~ Changed values: 10 / 10138 (0.10%) country year other_renewables_including_bioenergy_share_of_electricity__pct - other_renewables_including_bioenergy_share_of_electricity__pct + Asia 2023 NaN 2.334978 Europe 2023 NaN 4.332199 High-income countries 2023 NaN 3.202647 South America 2023 NaN 5.526654 Upper-middle-income countries 2023 NaN 2.501369 ~ Column per_capita_coal_generation__kwh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year per_capita_coal_generation__kwh - per_capita_coal_generation__kwh + Asia 2023 NaN 1830.131958 Europe 2023 NaN 837.522400 High-income countries 2023 NaN 1449.935547 South America 2023 NaN 87.409286 Upper-middle-income countries 2023 NaN 2618.096436 ~ Column per_capita_fossil_generation__kwh (changed data) ~ Changed values: 24 / 10138 (0.24%) country year per_capita_fossil_generation__kwh - per_capita_fossil_generation__kwh + Lower-middle-income countries 1990 NaN 253.592010 Lower-middle-income countries 1991 NaN 254.591583 Lower-middle-income countries 1994 NaN 245.254593 Lower-middle-income countries 2023 NaN 648.595337 South America 2023 NaN 635.270996 ~ Column per_capita_gas_generation__kwh (changed data) ~ Changed values: 24 / 10138 (0.24%) country year per_capita_gas_generation__kwh - per_capita_gas_generation__kwh + Lower-middle-income countries 1990 NaN 52.765625 Lower-middle-income countries 1991 NaN 55.772404 Lower-middle-income countries 1994 NaN 60.378922 Lower-middle-income countries 2023 NaN 169.040146 South America 2023 NaN 462.322571 ~ Column per_capita_hydro_generation__kwh (changed data) ~ Changed values: 45 / 10138 (0.44%) country year per_capita_hydro_generation__kwh - per_capita_hydro_generation__kwh + High-income countries 2023 NaN 1028.433350 Lower-middle-income countries 1970 NaN 36.514576 Lower-middle-income countries 1987 NaN 57.837975 Lower-middle-income countries 1990 NaN 66.707764 Lower-middle-income countries 1997 NaN 62.678043 ~ Column per_capita_low_carbon_generation__kwh (changed data) ~ Changed values: 45 / 10138 (0.44%) country year per_capita_low_carbon_generation__kwh - per_capita_low_carbon_generation__kwh + High-income countries 2023 NaN 4356.056641 Lower-middle-income countries 1970 NaN 37.555485 Lower-middle-income countries 1987 NaN 90.137726 Lower-middle-income countries 1990 NaN 110.731827 Lower-middle-income countries 1997 NaN 105.235764 ~ Column per_capita_nuclear_generation__kwh (changed data) ~ Changed values: 11 / 10138 (0.11%) country year per_capita_nuclear_generation__kwh - per_capita_nuclear_generation__kwh + Europe 2023 NaN 1297.929932 High-income countries 2023 NaN 1530.653564 Lower-middle-income countries 2023 NaN 37.178959 South America 2023 NaN 53.381863 Upper-middle-income countries 2023 NaN 282.977142 ~ Column per_capita_oil_generation__kwh (changed data) ~ Changed values: 99 / 10138 (0.98%) country year per_capita_oil_generation__kwh - per_capita_oil_generation__kwh + Europe 1985 NaN 533.547302 European Union (27) 1993 NaN 466.515900 Lower-middle-income countries 1990 NaN 48.533051 North America 1994 NaN 454.527985 Upper-middle-income countries 1988 NaN 158.713257 ~ Column per_capita_other_renewables_including_bioenergy_generation__kwh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year per_capita_other_renewables_including_bioenergy_generation__kwh - per_capita_other_renewables_including_bioenergy_generation__kwh + Asia 2023 NaN 81.754768 Europe 2023 NaN 273.679565 High-income countries 2023 NaN 292.213257 South America 2023 NaN 164.021790 Upper-middle-income countries 2023 NaN 134.853271 ~ Column per_capita_renewable_generation__kwh (changed data) ~ Changed values: 45 / 10138 (0.44%) country year per_capita_renewable_generation__kwh - per_capita_renewable_generation__kwh + High-income countries 2023 NaN 2825.402588 Lower-middle-income countries 1970 NaN 36.514576 Lower-middle-income countries 1987 NaN 60.432655 Lower-middle-income countries 1990 NaN 69.659111 Lower-middle-income countries 1997 NaN 66.631653 ~ Column per_capita_solar_and_wind_generation__kwh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year per_capita_solar_and_wind_generation__kwh - per_capita_solar_and_wind_generation__kwh + Asia 2023 NaN 418.648468 Europe 2023 NaN 1159.497192 High-income countries 2023 NaN 1504.756104 South America 2023 NaN 463.836670 Upper-middle-income countries 2023 NaN 700.450684 ~ Column per_capita_solar_generation__kwh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year per_capita_solar_generation__kwh - per_capita_solar_generation__kwh + Asia 2023 NaN 197.328690 Europe 2023 NaN 372.742798 High-income countries 2023 NaN 602.444397 South America 2023 NaN 173.271347 Upper-middle-income countries 2023 NaN 278.627014 ~ Column per_capita_total_generation__kwh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year per_capita_total_generation__kwh - per_capita_total_generation__kwh + Asia 2023 NaN 3501.308105 Europe 2023 NaN 6317.335449 High-income countries 2023 NaN 9124.117188 South America 2023 NaN 2967.831787 Upper-middle-income countries 2023 NaN 5391.178223 ~ Column per_capita_wind_generation__kwh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year per_capita_wind_generation__kwh - per_capita_wind_generation__kwh + Asia 2023 NaN 221.319794 Europe 2023 NaN 786.754456 High-income countries 2023 NaN 902.311707 South America 2023 NaN 290.565308 Upper-middle-income countries 2023 NaN 421.823700 ~ Column primary_energy_consumption__twh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year primary_energy_consumption__twh - primary_energy_consumption__twh + Asia 2023 NaN 91422.265625 Europe 2023 NaN 28666.621094 High-income countries 2023 NaN 64908.398438 South America 2023 NaN 7656.339355 Upper-middle-income countries 2023 NaN 76803.554688 ~ Column renewable_generation__twh (changed data) ~ Changed values: 45 / 10138 (0.44%) country year renewable_generation__twh - renewable_generation__twh + High-income countries 2023 NaN 3471.277344 Lower-middle-income countries 1970 NaN 45.889198 Lower-middle-income countries 1987 NaN 114.031921 Lower-middle-income countries 1990 NaN 140.756912 Lower-middle-income countries 1997 NaN 155.265594 ~ Column renewable_share_of_electricity__pct (changed data) ~ Changed values: 25 / 10138 (0.25%) country year renewable_share_of_electricity__pct - renewable_share_of_electricity__pct + Europe 2023 NaN 39.207321 Lower-middle-income countries 1985 NaN 17.193811 Lower-middle-income countries 1991 NaN 16.808912 Lower-middle-income countries 1996 NaN 16.502615 Lower-middle-income countries 1999 NaN 16.274147 ~ Column solar_and_wind_generation__twh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year solar_and_wind_generation__twh - solar_and_wind_generation__twh + Asia 2023 NaN 1989.342041 Europe 2023 NaN 862.123901 High-income countries 2023 NaN 1848.736694 South America 2023 NaN 203.957825 Upper-middle-income countries 2023 NaN 1794.026367 ~ Column solar_and_wind_share_of_electricity__pct (changed data) ~ Changed values: 10 / 10138 (0.10%) country year solar_and_wind_share_of_electricity__pct - solar_and_wind_share_of_electricity__pct + Asia 2023 NaN 11.956917 Europe 2023 NaN 18.354214 High-income countries 2023 NaN 16.492075 South America 2023 NaN 15.628806 Upper-middle-income countries 2023 NaN 12.992535 ~ Column solar_generation__twh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year solar_generation__twh - solar_generation__twh + Asia 2023 NaN 937.670349 Europe 2023 NaN 277.146393 High-income countries 2023 NaN 740.160522 South America 2023 NaN 76.190712 Upper-middle-income countries 2023 NaN 713.632263 ~ Column solar_share_of_electricity__pct (changed data) ~ Changed values: 10 / 10138 (0.10%) country year solar_share_of_electricity__pct - solar_share_of_electricity__pct + Asia 2023 NaN 5.635856 Europe 2023 NaN 5.900316 High-income countries 2023 NaN 6.602770 South America 2023 NaN 5.838314 Upper-middle-income countries 2023 NaN 5.168202 ~ Column total_electricity_share_of_primary_energy__pct (changed data) ~ Changed values: 25 / 10138 (0.25%) country year total_electricity_share_of_primary_energy__pct - total_electricity_share_of_primary_energy__pct + Europe 2023 NaN 19.432449 Lower-middle-income countries 1985 10.762549 10.469264 Lower-middle-income countries 1991 11.573279 11.235438 Lower-middle-income countries 1996 12.894382 12.484454 Lower-middle-income countries 1999 13.496456 13.076603 ~ Column total_generation__twh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year total_generation__twh - total_generation__twh + Asia 2023 NaN 16637.583984 Europe 2023 NaN 4697.144531 High-income countries 2023 NaN 11209.849609 South America 2023 NaN 1305.012207 Upper-middle-income countries 2023 NaN 13808.132812 ~ Column wind_generation__twh (changed data) ~ Changed values: 10 / 10138 (0.10%) country year wind_generation__twh - wind_generation__twh + Asia 2023 NaN 1051.671753 Europe 2023 NaN 584.977539 High-income countries 2023 NaN 1108.576172 South America 2023 NaN 127.767105 Upper-middle-income countries 2023 NaN 1080.394165 ~ Column wind_share_of_electricity__pct (changed data) ~ Changed values: 10 / 10138 (0.10%) country year wind_share_of_electricity__pct - wind_share_of_electricity__pct + Asia 2023 NaN 6.321060 Europe 2023 NaN 12.453897 High-income countries 2023 NaN 9.889304 South America 2023 NaN 9.790491 Upper-middle-income countries 2023 NaN 7.824332 = Dataset garden/lis/2024-06-13/luxembourg_income_study = Table lis_percentiles_adults ~ Column avg (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column share (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column thr (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). = Table luxembourg_income_study ~ Column avg_p100_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p100_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p100_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p100_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p100_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p100_mi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p10_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p10_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p10_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p10_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p10_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p10_mi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p20_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p20_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p20_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p20_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p20_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p20_mi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p30_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p30_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p30_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p30_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p30_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p30_mi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p40_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p40_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p40_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p40_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p40_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p40_mi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p50_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p50_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p50_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p50_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p50_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p50_mi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p60_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p60_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p60_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p60_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p60_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p60_mi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p70_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p70_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p70_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p70_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p70_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p70_mi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p80_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p80_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p80_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p80_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p80_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p80_mi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p90_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p90_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p90_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p90_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p90_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_p90_mi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_40_median_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_40_median_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_40_median_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_40_median_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_40_median_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_40_median_mi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_50_median_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_50_median_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_50_median_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_50_median_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_50_median_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_50_median_mi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_60_median_dhci_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_60_median_dhci_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_60_median_dhi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_60_median_dhi_pc (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_60_median_mi_eq (changed metadata) - - We obtain after tax income (cash) by using the disposable household cash income variable (`dhci`). ? - - + + We obtain after tax income (cash) by using the disposable household cash income variable (dhci). ~ Column avg_shortfall_60_median_mi_pc (changed metadata) - - ...diff too long, truncated... ``` Automatically updated datasets matching _weekly_wildfires|excess_mortality|covid|fluid|flunet|country_profile|garden/ihme_gbd/2019/gbd_risk_ are not included

Edited: 2024-06-26 13:00:29 UTC Execution time: 3.91 seconds

Marigold commented 4 days ago

I ran into the following when testing:

It's also a bit confusing that I'm given a choice for version (do I need it?), title (it's the same) and dimensions (it's useful to see it, but I have no idea what to do with it) despite only touching subtitle.

@lucasrodes please remove the .. from the subtitle when you're done with this.

lucasrodes commented 4 days ago

@Marigold I think this comes from the fact that I am using a st.experimental_dialog (the conflict resolver modal) within a st.experimental_fragment (the chart diff block).

According to their docs:

Dialogs can't contain fragments, and fragments can't contain dialogs.

😢

I think it works in indicator upgrader (we have dialogs for the 'explore mode') because the modal there only displays things (user can't interact with input widgets ー e.g. a button).

Solution

We can either get rid of the fragments around chart diffs individual blocks or dialogs around the conflict resolver.

I think I'll try to remove the st.experimental_dialog and use a st.popover for the conflict resolver instead.

The drawback of using popover is that the HTML in it will be rendered even if the user does not click on it (similar to the issue with tabs). So, if we had several chart diffs with big conflicts, this could have a cost in performance.

However, I think that the performance increase from using fragment is substantial and should outweigh the downsides from using popover.

Also, it is rare that we have a page packed with several chart diffs with conflicts.