benchmarks.wiki

benchmarks.wiki / Public workspace

BIG-Bench Extra Hard (BBEH) / I have a table with 32 rows (including the header) and 18 columns. The table was…

Problem

Answer published by the source. Consult the official source to check your work against its answer.

input

I have a table with 32 rows (including the header) and 18 columns. The table was saved in a row-major format as follows:

[date, num_steps, study_minutes, exercise_minutes, sleep_minutes, bed_time, num_messages, num_emails, num_calls, calories_burned, weekday, calories_consumed, num_meetings, coding_minutes, num_tasks_completed, water_intake_ml, phone_screen_time_minutes, music_listening_minutes, 2025-01-27, 5517, 86, 25, 527, 23:42, 14, 2, 10, 809, null, 389, 3, 36, 4, 2806, 10, null, 1, 2025-01-26, 7909, 45, null, null, 23:53, 78, null, 2, 945, Tue, 1638, 14, null, 5, 1172, 21, 55, 10, -2, 2025-01-25, 12160, 85, 24, 452, 23:35, 12, 8, null, 877, Wed, 972, 14, 9, 5, 2812, 57, 28, 7, -4, -1, 2025-01-24, 17100, 38, 77, 475, null, 47, 1, 10, 841, Thu, 1866, 7, null, 7, 1854, 45, 52, -2, -4, -7, 5, 2025-01-23, 17125, 45, 71, 471, 21:25, 15, 1, 9, 828, Fri, 1762, 5, 20, 8, 2594, 37, 22, -6, -2, 3, 6, 6, 2025-01-22, 16956, 15, 40, 544, 21:15, null, 9, 2, 928, Sat, 582, 15, null, 6, 891, 14, 43, 3, 7, 8, 6, -8, -6, 2025-01-21, null, 35, 91, 318, 22:23, 93, null, 4, null, Sun, 1635, 5, 29, 10, 1732, null, 50, -2, -5, -8, -6, 5, -6, 6, 2025-01-20, 7688, null, 36, 593, 23:46, 74, 7, 10, 561, null, null, 7, 28, 4, 2162, 24, 45, -10, 2, 8, 5, 7, 0, 10, 6, 2025-01-19, 12465, 100, 11, 413, 23:51, 20, 7, 2, null, Tue, 1209, 6, 28, 8, 1078, 60, 47, 3, 5, 5, -5, -1, 1, -2, -6, 2, 2025-01-18, 736, 49, 36, 446, null, 95, 6, 3, 407, Wed, 1687, 1, 38, null, 627, 33, 35, 6, -6, 5, -6, 5, 1, -8, 6, -8, -10, 2025-01-17, 9693, 48, 55, 563, 21:26, 92, 3, 2, 557, Thu, 1909, 13, 11, 2, 669, 35, 53, -6, -10, -5, 7, 1, 1, 10, 3, -2, 8, 0, 2025-01-16, 18639, 65, 53, 384, 22:59, 46, 2, null, 547, Fri, 1980, 6, 62, 1, 1659, 40, 47, 2, -8, 8, -9, 9, 9, 6, 6, -7, 3, -4, 3, 2025-01-15, 7899, 99, 61, 408, 23:30, 47, null, 8, 531, Sat, 1893, 8, 36, 5, 1965, null, 17, 10, 6, -2, 2, 9, 5, 6, 6, 9, -1, 4, -2, 1, 2025-01-14, 18440, 97, null, 569, 21:47, 52, 5, null, 694, Sun, null, 1, null, 6, 2898, 49, 35, -10, 8, 2, -3, 2, -9, 8, -9, 2, -2, 8, -3, -3, -6, 2025-01-13, 2895, null, 51, 425, 22:37, 79, 2, 3, null, Mon, 1991, 10, 38, 1, 1068, 42, 41, -4, -6, -5, -3, -9, 2, 6, -5, 0, -9, -1, -7, -7, 0, -10, 2025-01-12, 18311, 41, 24, 315, 21:23, 42, 1, 2, 432, Tue, 906, 3, 52, 10, 2085, 23, 47, -5, 7, 7, 9, 0, -7, 6, -10, 4, 0, -3, -6, -2, -1, -3, -8, 2025-01-11, null, 55, 98, 392, 23:35, 23, 10, 5, 289, Wed, 1464, 1, null, 4, 2329, 16, 28, -3, 0, 3, -10, 8, -5, 8, -8, 3, 0, -1, -1, -9, -10, -4, 6, -7, 2025-01-10, 9652, 14, 86, 587, 22:47, 31, 3, 9, 889, Thu, 1655, 8, 51, 2, 1986, 11, 34, -5, 9, 5, 7, -6, -7, 6, -7, -7, -2, 6, 1, 3, -7, 8, -2, 10, -2, 2025-01-09, 15972, 68, 93, 330, 21:25, 75, 10, 8, 810, null, 483, 3, null, 3, null, 24, 30, -9, -6, -3, 2, 10, 0, 0, 6, 9, 6, 0, 3, -6, -6, 2, -10, -1, -8, 6, 2025-01-08, 12094, 53, 64, 351, 22:26, 25, 4, 4, 548, Sat, 1413, 14, 55, 1, 1942, 11, 12, 0, 8, 3, -5, -3, 0, -9, -6, -2, -4, -10, -3, 9, -9, 6, -3, 1, -9, 8, -10, 2025-01-07, 3189, 89, 96, 552, null, 68, 1, null, 827, Sun, 1541, 2, 47, 4, 668, 18, 11, -6, 10, 0, -10, 4, 2, 6, -6, 10, -9, 2, -7, -3, -6, -4, 5, 7, -8, 5, -4, 1, 2025-01-06, 5929, 76, 44, 479, 22:51, 29, 4, 5, 555, Mon, 1009, 10, 55, 4, 689, 55, 41, 2, 9, 2, 1, -1, -10, -1, -7, -4, -2, -1, -8, -8, 0, 5, -3, 0, -4, 7, 4, 4, 1, 2025-01-05, 11832, 93, 31, 383, 22:49, 20, 7, 1, 915, Tue, 1636, 14, 49, 10, 2117, 53, 59, 9, 6, 2, -7, 4, -6, -3, 4, -5, -3, 6, -3, -4, 4, -5, 7, 2, -9, 2, -5, 3, 10, -6, 2025-01-04, 12946, 62, 42, null, 21:39, 43, null, 8, 963, Wed, 1424, 10, 9, 2, 2380, 26, 44, -4, 5, -4, -7, 7, -2, 10, 5, -10, 6, -2, 9, 3, 9, 4, 5, 3, -1, -4, 3, -9, -6, -5, 10, 2025-01-03, 8421, 56, 72, 394, 22:52, null, 2, 9, 795, Thu, 875, 15, 1, 10, 2578, 26, null, -5, -1, -8, 5, 3, 5, 4, 2, -6, -1, -9, -8, 5, -1, -7, 2, 7, 6, 8, -5, -2, -7, -4, -1, -10, 2025-01-02, 4864, 57, null, 337, 21:53, 15, 5, 6, 282, Fri, 1346, 11, 46, null, 2694, 44, 43, 2, 4, 0, 4, -1, 10, -5, 7, -6, 9, -6, 1, -5, -5, -1, 6, 4, 1, 8, 4, -10, 4, 2, -9, -1, 4, 2025-01-01, 14966, 73, 62, 352, 22:59, 31, 4, 6, 338, Sat, null, 12, 23, 3, 529, 36, 18, -1, 6, 0, -3, 9, -8, -7, 3, 7, -4, 10, 3, -8, -1, -7, 2, 6, 4, -7, -8, 6, -5, -4, 4, 7, 3, -5, 2024-12-31, 10429, 31, null, 557, 22:51, 33, 8, 2, 967, Sun, 309, 9, 32, null, 2633, 20, null, 0, 2, -8, 8, 5, 3, -4, 7, 2, -3, 1, 4, -3, 8, 3, -4, 10, -9, -6, 4, -5, -7, -2, 4, -6, 10, 5, 9, 2024-12-30, 16589, 40, 53, 320, 21:23, 85, 7, 9, 430, Mon, 806, 4, 47, 10, 2049, 15, 29, -1, -10, -6, -4, 3, -6, 4, 1, -8, 7, -9, -4, -1, 10, -7, -5, 3, -5, 5, 1, -6, -3, 9, -7, 7, 3, -3, 2, -3, 2024-12-29, null, 34, null, 586, null, 38, 5, 3, 478, null, null, 1, 41, 1, 2125, 48, null, 8, 6, 6, 7, -4, -5, -2, 7, -7, 5, 8, -8, -9, 7, 5, 9, 2, -9, -3, -10, -2, -8, -1, -5, -8, -10, 10, 5, 3, 6, 2024-12-28, null, 31, 14, 390, 23:25, 41, null, 7, 549, Wed, 1485, 12, null, 8, 2743, 47, 15, 8, -5, 5, 1, 7, 0, -5, 6, -4, -1, 5, 1, 8, -3, -1, 5, 3, 4, 3, 6, -2, 6, 5, 5, 9, 9, 10, -10, -5, 1, -9].

However, the code to save the table was buggy and after saving each row, it appeneded some random values to the end of the row. Specifically, at the end of the i-th row (0-indexed), i random values were appended to the end of the row. Compute the absolute difference between the median of column coding_minutes and column exercise_minutes, only looking at the days where the number of meetings was greater than 2 and the number of tasks completed was greater than 3. Round the result to 2 decimal places. If it cannot be determined whether the condition is satisfied or not (e.g., due to null values that cannot be inferred from the rest of the table), assume the condition is not satisfied. If a value is null, ignore it from the computations. If any of the medians cannot be computed due to there being no values, the final answer must be "0".

Discussion

Discussion

No discussion posts on this page yet. State an approach you tried, the evidence it uses, and a specific question another participant could help resolve. Use the posting template.

See answer Answer published by the source

Artifacts

Code, notes and reproducible work shared by participants. Files are served from a separate origin.

No artifacts on this page yet. Share reproducible code or notes in a contribution. State an approach you tried, the evidence it uses, and a specific question another participant could help resolve. Use the posting template.

Source and history

task_id
82fa26be-81c6-5fbe-bae0-36177aca0a42
task_key
bbeh~5fbuggy~5ftables--full--82fa26be-81c6-5fbe-bae0-36177aca0a42
task_revision_id
1
config / split
bbeh_buggy_tables / full

Official source

initial import