benchmarks.wiki

benchmarks.wiki / Public workspace

BIG-Bench Extra Hard (BBEH) / I have a table with 30 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 30 rows (including the header) and 18 columns. The table was converted to markdown 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 && 2025-01-26| 6520 && null| 60 && 100| 10 && 27| 417 && 375| 23:23 && 23:13| 50 && 52| 5 && 3| 4 && 3| 952 && 591| null && Tue| 1019 && 930| 2 && 2| 15 && 57| 5 && 9| 1875 && 2985| 23 && null| 45 && 44 |
| 2025-01-25 && 2025-01-24| 19630 && 2684| null && 92| 51 && 39| null && 403| 23:57 && 23:14| 52 && 45| 9 && 10| 7 && 7| 298 && null| Wed && Thu| 1403 && 1012| 8 && 6| 6 && 40| 1 && 8| 1315 && null| null && 58| 31 && 55 |
| 2025-01-23 && 2025-01-22| null && 4570| 75 && 34| 51 && 96| 563 && 354| 21:54 && 23:29| null && 88| 4 && 7| 2 && 9| 241 && 592| Fri && Sat| null && 526| 3 && 7| 48 && 52| 1 && 9| 1754 && 759| 55 && 25| 38 && 26 |
| 2025-01-21 && 2025-01-20| 7687 && 8775| 64 && null| 81 && 38| 385 && 436| 22:55 && 23:35| 74 && 44| null && null| 7 && 10| null && 734| null && null| 556 && 496| null && null| 36 && null| 4 && 8| 1049 && 1426| 50 && 33| 33 && 46 |
| 2025-01-19 && 2025-01-18| 14792 && 10523| 80 && null| null && 70| null && 567| 23:46 && 23:17| 93 && 24| 10 && null| 8 && 5| 691 && 935| Tue && Wed| 696 && 1073| 11 && 2| 21 && 0| null && 6| 685 && 667| 30 && 53| null && 47 |
| 2025-01-17 && 2025-01-16| 2093 && 14524| 56 && 92| 36 && 59| 382 && 427| 21:59 && 22:45| 97 && 23| 8 && 10| 9 && 8| 585 && 746| Thu && Fri| 973 && 815| 7 && 5| 45 && 1| null && 8| 680 && 666| null && 32| null && 21 |
| 2025-01-15 && 2025-01-14| 1131 && 8689| 60 && 31| 97 && 60| 482 && null| 23:31 && 23:24| null && 72| 6 && 3| 10 && 9| 584 && 335| Sat && null| 893 && 925| 10 && 8| 45 && null| 3 && 1| 2051 && 1778| 20 && 21| 19 && 50 |
| 2025-01-13 && 2025-01-12| 10808 && 10079| 65 && 25| 83 && 64| 541 && 332| 22:38 && 21:58| 62 && 100| 6 && 10| 6 && 5| null && 227| Mon && Tue| 1896 && 337| 2 && 7| 50 && 31| 10 && 6| 1931 && 1614| 30 && 15| 21 && 35 |
| 2025-01-11 && 2025-01-10| null && 11765| 41 && 68| 33 && 43| 414 && 404| 22:32 && 21:16| 74 && 99| 8 && 3| 3 && 4| 788 && 778| Wed && Thu| 1549 && 1452| 3 && 8| 37 && null| 9 && 6| 1593 && 2002| 52 && 53| 28 && 23 |
| 2025-01-09 && 2025-01-08| 8287 && 15328| 50 && 75| 35 && 25| 579 && 598| 23:24 && 21:13| 28 && 54| 9 && 5| 3 && 7| 460 && 390| Fri && Sat| 506 && 1894| 8 && 6| 40 && 38| 10 && null| 1057 && 535| null && 35| 44 && 20 |
| 2025-01-07 && 2025-01-06| 6062 && 4913| 60 && 98| 99 && 25| 531 && 549| 23:18 && 21:59| 23 && 89| 7 && null| 6 && 3| 420 && 497| Sun && Mon| 1976 && 836| 10 && 3| 32 && 26| 10 && 7| 2032 && 1829| 13 && 51| 14 && 11 |
| 2025-01-05 && 2025-01-04| 19886 && 12917| 92 && 64| 77 && null| 559 && null| 21:25 && 22:14| 98 && 42| 10 && null| 6 && 4| 153 && 239| Tue && Wed| 1865 && 1323| 3 && 9| 64 && 14| 10 && 10| 998 && 1314| null && null| null && 42 |
| 2025-01-03 && 2025-01-02| 3574 && 3745| 64 && 35| 49 && 84| 510 && 371| 23:56 && 22:56| 76 && 71| 9 && 10| 4 && null| 561 && 106| Thu && Fri| 1529 && 743| 9 && 13| 34 && 26| null && 4| 2433 && 2800| 53 && 38| 49 && 21 |
| 2025-01-01 && 2024-12-31| 13719 && 14236| 88 && 71| 12 && 71| 372 && 427| 21:45 && null| 15 && 33| 9 && 9| 3 && 4| 657 && 422| Sat && Sun| 676 && 778| 3 && 4| null && 4| 2 && null| 560 && null| 46 && 30| 32 && 30 |
| 2024-12-30 && null| 17438 && null| null && null| 96 && null| 473 && null| 23:54 && null| 14 && null| 10 && null| 5 && null| 973 && null| null && null| 1161 && null| 7 && null| 20 && null| 9 && null| 802 && null| 51 && null| 42 && null |.

However, the code to convert the table into markdown format was buggy and mistakenly merged every two rows of values (not including the header) into one row by placing the values of the second row after the first row separated by " && ". In the case of an odd number of rows, the last row was merged with a row full of "null" values. Compute the absolute difference between the sum of column sleep_minutes and column coding_minutes, only looking at the days where the coding minutes was greater than 20 and the number of calories burned was less than 800. 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 sums 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
b451528c-28b8-5ef5-971b-c71d8383fb37
task_key
bbeh~5fbuggy~5ftables--full--b451528c-28b8-5ef5-971b-c71d8383fb37
task_revision_id
1
config / split
bbeh_buggy_tables / full

Official source

initial import