df-drills pandas · Polars · DuckDB SQL · DuckDB Relational 题目列表 登录

周末订单

简单 08-datetime 日期时间 datetimeweekdayfilter

找出所有在周末下的订单,并标出星期几。

  • 新列 weekday 用 ISO 编号:周一 = 1、周二 = 2 …… 周六 = 6、周日 = 7。
  • 周末指周六和周日(weekday 为 6 或 7)。只输出周末订单。
  • order_ts 为 null 的订单不输出。

输入

  • orders(order_id, customer_id, order_ts, status, channel),order_ts 不带时区。

输出

列为 order_id, order_ts, weekday,行顺序不限。

输入表 (case base,共 2 个 case:base、edge)

orders shop/orders
#order_idint64customer_idint64order_tsdatetimestatusstringchannelstring
1 1001 39 2026-01-01 19:38:00 paid app
2 1002 16 2026-01-17 14:07:00 paid app
3 1003 4 2026-01-08 15:40:20 cancelled web
4 1004 2 2026-05-23 10:48:58 paid null
5 1005 12 2026-06-22 11:07:22 paid store
6 1006 17 2026-08-15 05:15:25 paid web
7 1007 9 2026-06-11 01:00:32 refunded store
8 1008 45 2026-09-19 20:47:10 paid web
9 1009 2 2025-10-05 04:53:38 paid app
10 1010 4 2026-02-19 01:39:54 paid app
11 1011 28 2026-03-05 03:04:45 refunded store
12 1012 2 2026-08-01 07:09:17 paid web
13 1013 26 2026-01-22 03:48:14 refunded store
14 1014 2 2026-02-09 01:41:41 paid app
15 1015 5 2026-08-03 19:49:04 refunded web
16 1016 26 2026-02-16 00:43:43 refunded app
17 1017 9 2025-12-06 04:48:57 pending app
18 1018 999 2026-05-19 12:13:43 paid store
19 1019 26 2026-02-05 15:02:26 paid store
20 1020 44 2025-11-24 11:19:00 cancelled web
显示前 20 行,共 200 行

期望输出 (case base,行顺序不限)

#order_idInt64order_tsDatetime(time_unit='us', time_zone=None)weekdayInt64
1 1002 2026-01-17 14:07:00 6
2 1004 2026-05-23 10:48:58 6
3 1006 2026-08-15 05:15:25 6
4 1008 2026-09-19 20:47:10 6
5 1009 2025-10-05 04:53:38 7
6 1012 2026-08-01 07:09:17 6
7 1017 2025-12-06 04:48:57 6
8 1025 2026-07-05 07:41:49 7
9 1031 2026-02-14 10:30:00 6
10 1032 2026-02-14 13:30:00 6
11 1033 2026-02-14 16:30:00 6
12 1034 2026-02-14 10:30:00 6
13 1037 2026-03-08 19:28:41 7
14 1048 2025-12-14 00:07:09 7
15 1051 2026-03-01 00:00:00 7
16 1054 2026-02-28 23:59:59 6
17 1056 2025-08-17 02:43:23 7
18 1058 2026-07-05 13:29:06 7
19 1059 2026-06-14 04:09:36 7
20 1067 2026-01-04 18:32:00 7
21 1073 2026-08-16 07:33:27 7
22 1074 2026-09-27 02:16:14 7
23 1080 2025-09-28 02:53:58 7
24 1083 2025-12-06 12:27:00 6
25 1084 2026-01-24 16:39:05 6
26 1088 2026-01-18 17:26:00 7
27 1089 2026-08-22 13:11:23 6
28 1092 2026-03-21 08:38:21 6
29 1100 2026-04-11 18:29:09 6
30 1109 2026-06-14 03:11:11 7
31 1111 2026-05-16 04:09:21 6
32 1112 2025-11-29 00:30:56 6
33 1113 2026-06-13 23:49:53 6
34 1114 2026-07-11 09:15:35 6
35 1122 2025-12-14 12:51:43 7
36 1123 2026-02-01 19:21:59 7
37 1128 2026-06-28 02:18:58 7
38 1131 2026-07-19 09:52:06 7
39 1133 2026-06-06 16:52:09 6
40 1134 2026-02-14 23:29:24 6
41 1136 2026-05-17 10:38:27 7
42 1139 2026-08-30 02:51:19 7
43 1148 2025-11-29 20:13:10 6
44 1149 2026-07-11 04:13:28 6
45 1153 2026-02-15 11:13:43 7
46 1155 2026-05-03 02:09:16 7
47 1163 2025-11-23 17:08:17 7
48 1170 2026-08-29 20:25:45 6
49 1173 2025-10-05 12:00:32 7
50 1181 2026-09-13 20:40:59 7
显示前 50 行,共 59 行