A_test_box/exe_box.py

data = {"submissions": [774, 20, 1378, 2098, 22, 786, 236, 1428, 171, 1824, 7526, 361, 1295, 2631, 4203, 821, 839, 590, 103, 340, 1886, 1037, 623, 1067, 1166, 1310, 537, 1390, 341, 1431, 205, 38, 1345, 15, 605, 354, 736, 887, 1598, 467, 567, 179, 1730, 1812, 1457, 653, 33, 456, 95, 1633, 244, 370, 543, 758, 12, 620, 133, 1093, 392, 276, 456, 221, 645, 207, 164, 745, 640, 810, 2066, 462, 753, 3883, 77, 555, 240, 952, 240, 755, 564, 92, 887, 485, 26, 320, 570, 740, 5109, 628, 1334, 782, 51, 4514, 1611, 577, 114, 534, 392, 663, 112, 1050, 190, 8, 1033, 1504, 737, 459, 1341, 72, 397, 3434, 252, 710, 300, 274, 2722, 740, 201, 1149, 3, 259, 585, 795, 66, 119, 1735, 1020, 2956, 455, 401, 53, 172, 3412, 753, 2225, 958, 420, 279, 148, 132, 646, 31, 238, 29, 76, 27, 1029, 173, 327, 490, 1559, 192, 11, 655, 31, 786, 50, 159, 1167, 472, 1284, 211, 575, 258, 608, 923, 405, 1224, 882, 2120, 1603, 350, 806, 1365, 711, 399, 787, 1719, 1554, 189, 417, 255, 510, 636, 289, 1163, 6451, 707, 332, 1356, 133, 870, 60, 2828, 147, 546, 227, 1280, 1434, 903, 179, 50, 215, 1766, 100, 272, 276, 181, 276, 70, 619, 1560, 38, 908, 68, 81, 209, 385, 193, 423, 22, 1003, 1139, 133, 11, 321, 88, 559, 13, 467, 449, 1487, 572, 1047, 303, 586, 622, 796, 212, 597, 82, 1408, 304, 112, 2602, 75, 50, 1, 601, 1043, 59, 60, 345, 501, 596, 361, 547, 681, 546, 489, 127, 1876, 227, 300, 607, 1344, 363, 1907, 1131, 126, 103, 273, 459, 67, 554, 333, 290, 170, 5, 682, 1953, 449, 293, 2235, 316, 306, 160, 380, 323, 657, 666, 2842, 651, 168, 82, 16, 634, 977, 123, 79, 880, 536, 649, 511, 343, 31, 1154, 311, 675, 181, 153, 122, 1842, 653, 841, 637, 1190, 1033, 137, 2379, 32, 223, 245, 310, 288, 148, 28, 945, 275, 904, 52, 209, 279, 1392, 139, 138, 532, 779, 117, 378, 797, 168, 383, 53, 297, 1515, 1013, 647, 780, 856, 847, 35, 805, 168, 300, 792, 501, 515, 866, 2803, 596, 2093, 124, 1068, 181, 1539, 607, 1030, 443, 406, 237, 362, 58, 94, 1693, 133, 320, 8, 607, 250, 2164, 612, 172, 10, 862, 54, 571, 256, 29, 846, 271, 2246, 1274, 350, 64, 15, 108, 181, 1210, 211, 649, 2785, 490, 189, 374, 762, 60, 331, 223, 197, 16, 959, 1341, 125, 839, 949, 35, 1869, 509, 1663, 583, 36, 488, 45, 41, 749, 334, 390, 305, 643, 762, 77, 557, 124, 1972, 934, 1333, 381, 141, 17, 342, 708, 294, 421, 128, 55, 240, 151, 126, 17, 579, 232, 236, 103, 14, 181, 98, 38, 916, 162, 265, 1737, 102, 111, 47, 1836, 387, 376, 999, 295, 66, 42, 1073, 793, 1628, 72, 96, 344, 1792, 69, 188, 338, 19, 679, 329, 18, 43, 128, 810, 1429, 379, 137, 2808, 399, 106, 54, 379, 206, 648, 589, 1702, 750, 74, 688, 910, 79, 177, 3513, 18, 187, 41, 861, 189, 904, 651, 113, 49, 32, 1744, 557, 504, 510, 1274, 85, 51, 5, 288, 474, 44, 119, 326, 68, 410, 786, 13, 790, 11, 681, 426, 80, 285, 260, 202, 1264, 813, 100, 220, 413, 110, 88, 1524, 362, 716, 922, 32, 52, 12, 76, 42, 990, 236, 86, 389, 68, 77, 36, 914, 2280, 40, 678, 854, 508, 66, 456, 105, 167, 70, 132, 75, 6, 734, 65, 1304, 338, 67, 1061, 28, 414, 169, 96, 95, 577, 91, 57, 674, 21, 606, 411, 404, 675, 36, 184, 268, 169, 78, 1473, 1448, 78, 465, 148, 381, 318, 189, 117, 236, 1287, 146, 170, 628, 48, 271, 68, 10, 802, 15, 369, 168, 760, 495, 545, 991, 404, 213, 263, 88, 357, 70, 66, 71, 6, 1105, 90, 106, 17, 216, 738, 249, 15, 70, 1207, 94, 28, 279, 947, 112, 9, 1221, 292, 37, 180, 255, 219, 345, 37, 581, 126, 496, 314, 498, 70, 492, 308, 60, 422, 1611, 216, 305, 52, 102, 426, 605, 1376, 142, 401, 34, 62, 403, 14, 564, 26, 725, 182, 12, 61, 203, 1018, 320, 85, 614, 184, 69, 44, 7, 148, 13, 173, 281, 222, 244, 55, 4, 490, 484, 436, 35, 1076, 319, 141, 400, 385, 747, 898, 492, 421, 311, 83, 182, 470, 50, 222, 163, 258, 256, 15, 206, 306, 391, 789, 84, 23, 789, 16, 516, 952, 437, 150, 167, 275, 313, 87, 266, 101, 17, 343, 143, 20, 9, 68, 5, 48, 67, 30, 109, 49, 101, 657, 478, 293, 847, 966, 313, 487, 409, 181, 64, 114, 179, 798, 170, 233, 405, 176, 14, 245, 77, 159, 18, 74, 478, 33, 16, 233, 96, 49, 77, 120, 157, 15, 126, 52, 39, 38, 646, 463, 452, 37, 1359, 102, 64, 27, 13, 260, 98, 762, 166, 109, 57, 299, 13, 107, 4, 288, 73, 614, 99, 227, 63, 42, 337, 554, 130, 555, 630, 78, 3, 40, 70, 529, 419, 663, 12, 302, 345, 387, 131, 40, 33, 158, 116, 7, 20, 45, 20, 475, 60, 80, 6, 224, 14, 227, 359, 1131, 30, 32, 114, 345, 1193, 49, 147, 178, 211, 21, 34, 589, 22, 1, 21, 674, 259, 60, 714, 33, 419, 173, 76, 2163, 552, 40, 93, 1638, 407, 107, 67, 226, 256, 121, 335, 115, 279, 919, 336, 608, 1544, 1661, 395, 131, 89, 197, 24, 98, 564, 387, 14, 224, 133, 68, 253, 399, 182, 274, 490, 115, 38, 10, 486, 127, 91, 90, 424, 1, 39, 196, 494, 11, 157, 66, 52, 2, 227, 214, 34, 4, 457, 98, 33, 131, 66, 404, 194, 261, 229, 192, 81, 28, 58, 36, 36, 569, 179, 30, 362, 85, 237, 173, 145, 54, 374, 42, 23, 117, 80, 6, 250, 248, 25, 141, 115, 102, 26, 333, 602, 105, 78, 5, 186, 51, 144, 155, 45, 41, 122, 70, 416, 28, 20, 40, 204, 96, 144, 49, 12, 206, 80, 13, 462, 822, 148, 31, 77, 97, 338, 458, 56, 175, 37, 369, 148, 54, 79, 186, 693, 37, 134, 69, 92, 155, 76, 110, 28, 108, 431, 58, 356, 45, 25, 87, 299, 193, 3, 37, 14, 230, 247, 39, 156, 134, 79, 78, 322, 20, 7, 64, 371, 66, 188, 46, 552, 198, 49, 357, 3, 3, 41, 120, 505, 110, 1, 295, 142, 425, 158, 207, 378, 61, 117, 26, 22, 92, 115, 1072, 300, 116, 27, 13, 162, 10, 233, 27, 311, 312, 510, 113, 94, 73, 234, 85, 31, 577, 201, 293, 44, 56, 97, 7, 194, 26, 3, 103, 166, 26, 777, 228, 51, 11, 336, 46, 71, 78, 100, 239, 205, 87, 220, 232, 342, 85, 207, 5, 64, 140, 107, 14, 238, 43, 38, 124, 22, 11, 163, 250, 23, 107, 57, 377, 512, 16, 434, 656, 68, 72, 200, 11, 53, 139, 45, 12, 151, 44, 77, 78, 24, 57, 350, 14, 127, 42, 209, 14, 287, 87, 66, 88, 798, 303, 170, 189, 443, 100, 146, 34, 184, 269, 232, 29, 47, 10, 172, 119, 324, 19, 54, 175, 19, 51, 270, 77, 216, 104, 24, 6, 38, 99, 20, 4, 10, 181, 29, 131, 45, 117, 122, 13, 107, 265, 28, 326, 58, 25, 132, 204, 30, 223, 17, 190, 297, 299, 230, 13, 10, 172, 6, 146, 364, 164, 60, 16, 40, 17, 14, 26, 363, 322, 19, 8, 47, 134, 223, 180, 65, 35, 17, 350, 10, 69, 83, 18, 13, 35, 31, 50, 123, 28, 61, 198, 186, 16, 6, 96, 78, 139, 48, 3, 289, 7, 9, 70, 77, 257, 39, 37, 103, 63, 163, 161, 40, 13, 54, 170, 41, 3, 184, 24, 129, 102, 88, 30, 49, 39, 3, 155, 157, 24, 22, 3, 2, 45, 2, 108, 21, 59, 246, 307, 73, 13, 36, 337, 38, 35, 6, 35, 312, 5, 6, 135, 157, 18, 238, 5, 24, 11, 204, 80, 186, 20, 20, 473, 158, 42, 61, 29, 106, 14, 39, 18, 22, 66, 4, 38, 61, 25, 6, 127, 6, 14, 84, 102, 76, 56, 4, 35, 170, 111, 49, 17, 29, 62, 13, 8, 28, 132, 13, 5, 28, 18, 31, 17, 224, 10, 14, 1, 194, 56, 4, 8, 386, 36, 605, 60, 23, 109, 21, 5, 19, 4, 4, 28, 12, 49, 44, 213, 44, 72, 38, 105, 26, 77, 90, 25, 21, 33, 47, 178, 7, 38, 43, 44, 30, 41, 66, 16, 5, 32, 126, 15, 51, 4, 22, 28, 71, 7, 256, 26, 47, 81, 21, 82, 30, 70, 40, 40, 36, 23, 85, 231, 49, 102, 73, 11, 86, 13, 33, 23, 31, 7, 57, 70, 36, 62, 136, 12, 7, 45, 73, 7, 287, 82, 14, 55, 8, 4, 16, 1, 16, 96, 29, 26, 71, 3, 11, 33, 40, 158, 21, 80, 68, 26, 29, 68, 148, 29, 51, 43, 27, 50, 16, 69, 7, 10, 120, 35, 51, 39, 13, 22, 10, 28, 10, 55, 84, 1, 56, 76, 1, 110, 145, 11, 135, 51, 23, 478, 13, 101, 3, 29, 8, 48, 3, 49, 63, 155, 99, 16, 35, 25, 13, 12, 1, 53, 7, 11, 131, 10, 6, 21, 9, 29, 2, 34, 9, 15, 77, 26, 32, 2, 557, 19, 31, 19, 205, 157, 20, 24, 10, 26, 29, 93, 27, 15, 39, 14, 1, 25, 39, 1, 12, 72, 17, 14, 16, 33, 7, 95, 46, 18, 16, 19, 1, 203, 5, 42, 5, 2, 178, 11, 176, 19, 42, 1, 66, 100, 8, 3, 3, 5, 14, 1053, 53, 124, 108, 148, 58, 118, 4, 12, 65, 1, 8, 16, 7, 10, 4, 5, 9, 53, 96, 4, 4, 6, 12, 7, 1, 8, 107, 13, 9, 27, 12, 11, 100, 33, 140, 41, 3, 3, 7, 2, 49, 18, 29, 236, 1, 11, 1, 22, 4, 20, 10, 4, 8, 2, 14, 9, 18, 1, 4, 20, 8, 42, 1, 1, 3, 29, 2, 1, 2, 2, 1, 3, 1, 5, 34, 5, 5, 57, 38, 6, 2, 3, 13, 15, 5, 5, 10, 1, 2, 405, 25, 10, 6, 10, 17, 7, 15, 4, 3, 69, 658, 24, 2, 1, 17, 12, 16, 1, 1, 9, 5, 366, 44, 4, 17, 8, 56, 235, 1, 213, 4, 3, 5, 107, 6, 41, 357, 56, 277, 40, 143, 101, 51, 2, 37, 340, 27, 5, 8, 1, 5, 2, 1, 5, 2, 3, 34, 55, 910, 14, 2, 7, 1, 1, 35, 1, 139, 4], "codes": [19, 5, 32, 7, 13, 15, 5, 9, 9, 10, 10, 10, 6, 13, 20, 10, 5, 6, 9, 10, 10, 13, 10, 11, 10, 10, 10, 10, 10, 21, 10, 11, 60, 10, 11, 10, 10, 8, 8, 9, 16, 10, 7, 19, 17, 20, 6, 14, 10, 10, 15, 10, 5, 9, 10, 9, 6, 9, 15, 9, 8, 9, 6, 9, 11, 10, 12, 17, 13, 14, 10, 11, 9, 20, 19, 9, 5, 18, 18, 5, 5, 11, 10, 10, 9, 20, 6, 10, 24, 8, 10, 10, 17, 10, 9, 23, 16, 10, 10, 9, 20, 20, 36, 8, 10, 12, 9, 16, 14, 16, 9, 15, 10, 24, 20, 15, 10, 17, 14, 11, 8, 5, 9, 6, 9, 8, 10, 10, 9, 9, 14, 14, 10, 19, 11, 10, 11, 15, 18, 10, 10, 5, 11, 10, 15, 8, 10, 40, 10, 9, 10, 8, 10, 10, 10, 19, 10, 9, 8, 8, 10, 6, 25, 20, 17, 16, 10, 20, 20, 10, 6, 8, 9, 10, 16, 9, 21, 7, 8, 10, 10, 9, 10, 27, 9, 10, 10, 20, 7, 17, 11, 10, 19, 10, 12, 10, 10, 25, 10, 20, 10, 10, 10, 10, 10, 16, 18, 18, 9, 16, 10, 8, 12, 11, 35, 8, 6, 10, 15, 20, 19, 11, 10, 25, 20, 9, 18, 24, 9, 20, 9, 6, 17, 7, 9, 9, 9, 8, 10, 22, 19, 20, 20, 10, 6, 15, 20, 14, 10, 20, 21, 9, 25, 5, 10, 9, 10, 10, 11, 17, 19, 10, 9, 19, 5, 19, 30, 11, 6, 16, 10, 10, 9, 10, 41, 16, 14, 20, 18, 10, 21, 10, 10, 9, 10, 6, 12, 10, 10, 10, 19, 19, 5, 11, 22, 12, 25, 10, 10, 14, 19, 5, 10, 9, 15, 11, 11, 13, 8, 5, 8, 16, 10, 15, 8, 14, 13, 10, 10, 8, 14, 10, 18, 10, 5, 10, 7, 11, 5, 10, 16, 5, 10, 10, 10, 15, 9, 10, 7, 8, 10, 20, 9, 6, 10, 10, 7, 14, 10, 5, 10, 9, 20, 14, 10, 10, 32, 10, 19, 9, 18, 11, 10, 20, 10, 10, 7, 8, 7, 29, 20, 20, 8, 18, 18, 20, 6, 12, 10, 14, 13, 18, 20, 10, 16, 12, 10, 6, 10, 10, 14, 7, 13, 20, 10, 51, 10, 6, 12, 10, 19, 15, 19, 10, 10, 9, 9, 10, 19, 6, 20, 19, 20, 10, 5, 5, 12, 10, 10, 5, 5, 10, 10, 9, 19, 9, 18, 14, 10, 6, 10, 30, 16, 10, 10, 8, 20, 10, 19, 20, 29, 9, 16, 6, 7, 10, 20, 8, 10, 20, 17, 12, 19, 14, 8, 19, 13, 5, 10, 8, 21, 10, 7, 10, 11, 6, 18, 10, 11, 20, 20, 17, 10, 56, 7, 17, 10, 10, 13, 9, 5, 19, 20, 20, 24, 11, 8, 20, 10, 17, 20, 10, 7, 6, 9, 10, 15, 19, 23, 18, 8, 8, 10, 5, 10, 22, 10, 13, 6, 9, 9, 10, 11, 14, 10, 10, 8, 25, 13, 10, 5, 7, 10, 8, 11, 5, 9, 10, 10, 10, 5, 10, 9, 9, 6, 9, 10, 9, 11, 12, 12, 7, 10, 16, 9, 7, 35, 10, 10, 21, 25, 17, 20, 7, 10, 20, 18, 6, 14, 10, 10, 10, 6, 11, 20, 16, 8, 5, 14, 6, 10, 9, 17, 6, 20, 14, 20, 35, 15, 10, 11, 10, 25, 20, 19, 9, 6, 6, 20, 9, 9, 6, 10, 7, 12, 10, 20, 11, 10, 15, 13, 10, 17, 8, 5, 9, 10, 8, 15, 8, 9, 20, 7, 20, 10, 20, 18, 15, 8, 44, 7, 25, 46, 9, 11, 10, 18, 11, 8, 6, 20, 9, 7, 9, 13, 10, 10, 6, 10, 9, 7, 10, 9, 8, 8, 24, 7, 6, 8, 10, 9, 19, 8, 17, 10, 5, 10, 9, 10, 10, 26, 10, 7, 20, 8, 31, 9, 9, 7, 9, 6, 20, 10, 9, 17, 6, 10, 6, 5, 10, 5, 8, 23, 10, 17, 5, 7, 5, 10, 20, 7, 9, 10, 13, 13, 7, 10, 10, 10, 37, 5, 25, 20, 31, 10, 5, 10, 16, 10, 8, 20, 10, 10, 8, 9, 10, 9, 11, 8, 5, 10, 10, 10, 8, 10, 10, 10, 10, 6, 10, 17, 5, 10, 10, 10, 10, 18, 9, 17, 8, 9, 6, 10, 8, 16, 11, 8, 6, 9, 12, 9, 10, 10, 10, 10, 8, 6, 8, 5, 18, 7, 6, 6, 18, 7, 11, 10, 15, 8, 10, 11, 19, 8, 10, 12, 17, 9, 23, 9, 12, 9, 7, 9, 28, 9, 18, 8, 7, 10, 10, 9, 30, 7, 14, 8, 10, 19, 5, 14, 7, 6, 18, 21, 6, 5, 20, 6, 17, 8, 8, 10, 7, 10, 9, 10, 9, 13, 10, 5, 10, 10, 9, 10, 7, 7, 21, 11, 22, 8, 7, 7, 17, 19, 12, 9, 7, 8, 10, 25, 20, 10, 6, 18, 10, 10, 10, 10, 6, 10, 7, 8, 11, 10, 5, 17, 17, 29, 10, 10, 5, 10, 5, 6, 8, 21, 20, 7, 14, 7, 17, 10, 5, 7, 15, 19, 9, 20, 7, 6, 8, 7, 27, 9, 10, 8, 10, 9, 10, 10, 20, 10, 18, 15, 6, 7, 16, 7, 10, 9, 8, 10, 11, 6, 6, 18, 13, 10, 6, 20, 20, 6, 6, 9, 10, 13, 12, 8, 9, 14, 10, 18, 10, 10, 7, 9, 15, 15, 10, 17, 8, 10, 20, 10, 10, 20, 11, 9, 8, 19, 10, 12, 7, 15, 5, 10, 14, 8, 17, 7, 7, 10, 8, 8, 11, 17, 8, 5, 14, 6, 8, 9, 25, 7, 14, 9, 10, 6, 17, 8, 6, 16, 10, 29, 10, 6, 6, 10, 7, 20, 10, 16, 8, 10, 10, 14, 10, 10, 12, 8, 11, 7, 20, 10, 5, 6, 9, 5, 6, 7, 9, 11, 5, 17, 9, 6, 9, 6, 8, 9, 6, 16, 9, 8, 5, 5, 9, 6, 10, 10, 15, 7, 10, 11, 19, 6, 5, 7, 6, 16, 12, 10, 15, 9, 9, 7, 8, 10, 11, 7, 10, 10, 9, 7, 9, 5, 11, 5, 5, 9, 8, 17, 5, 9, 19, 7, 17, 9, 10, 14, 9, 9, 12, 8, 8, 10, 7, 12, 8, 10, 10, 17, 5, 10, 7, 8, 10, 7, 5, 7, 7, 35, 6, 5, 7, 16, 20, 11, 9, 9, 7, 7, 7, 10, 8, 15, 10, 6, 5, 9, 8, 18, 5, 9, 6, 7, 13, 8, 10, 7, 7, 6, 6, 5, 14, 7, 6, 36, 29, 6, 23, 10, 9, 6, 15, 11, 5, 11, 8, 41, 7, 9, 19, 6, 9, 5, 15]}

print(len(data['submissions']))
print(len(data['codes']))

import pandas as pd
import numpy as np

# 获取数组长度
submissions_length = len(data['submissions'])
codes_length = len(data['codes'])

# 计算差异
length_diff = abs(submissions_length - codes_length)

# 补齐较短的数组（前后补零）
if submissions_length > codes_length:
    # 在codes数组前后补零
    data['codes'] = [0] * (length_diff // 2) + data['codes'] + [0] * (length_diff - length_diff // 2)
elif codes_length > submissions_length:
    # 在submissions数组前后补零
    data['submissions'] = [0] * (length_diff // 2) + data['submissions'] + [0] * (length_diff - length_diff // 2)

# 将数据转换为DataFrame
df = pd.DataFrame({
    'submissions': data['submissions'],
    'codes': data['codes']
})

# 保存为Excel文件
file_path = './data_with_padded_arrays.xlsx'
df.to_excel(file_path, index=False)

file_path