Operation support table

op_name pandas duckdb bigquery mysql postgresql snowflake sqlite
0 abs ✅ ✅ ✅ ✅ ✅ ✅ ✅
1 add ✅ ✅ ✅ ✅ ✅ ✅ ✅
2 all ✅ ✅ ✅ ✅ ✅
3 any ✅ ✅ ✅ ✅ ✅
4 asfreq ✅
5 astype ✅ ✅ ✅ ✅ ✅ ✅ ✅
6 between ✅ ✅ ✅ ✅ ✅ ✅ ✅
7 bfill ✅
8 cat.add_categories ✅
9 cat.as_ordered ✅
10 cat.as_unordered ✅
11 cat.remove_categories ✅
12 cat.rename_categories ✅
13 cat.reorder_categories ✅
14 cat.set_categories ✅
15 clip ✅ ✅ ✅ ✅ ✅ ✅
16 copy ✅
17 count ✅ ✅ ✅ ✅ ✅ ✅ ✅
18 cummax ✅ ✅ ✅ ✅ ✅ ✅ ✅
19 cummin ✅ ✅ ✅ ✅ ✅ ✅ ✅
20 cumprod ✅
21 cumsum ✅ ✅ ✅ ✅ ✅ ✅ ✅
22 diff ✅ ✅ ✅ ✅ ✅ ✅ ✅
23 div ✅ ✅ ✅ ✅ ✅ ✅ ✅
24 divide ✅ ✅ ✅ ✅ ✅ ✅ ✅
25 dt.ceil ✅
26 dt.date ✅
27 dt.day ✅ ✅ ✅ ✅ ✅ ✅ ✅
28 dt.day_name ✅
29 dt.dayofweek ✅ ✅ ✅ ✅ ✅ ✅ ✅
30 dt.dayofyear ✅ ✅ ✅ ✅ ✅ ✅ ✅
31 dt.days_in_month ✅ ✅ ✅ ✅ ✅ ✅ ✅
32 dt.daysinmonth ✅ ✅ ✅ ✅ ✅ ✅ ✅
33 dt.floor ✅
34 dt.freq ✅
35 dt.hour ✅ ✅ ✅ ✅ ✅ ✅ ✅
36 dt.is_leap_year ✅
37 dt.is_month_end ✅ ✅ ✅ ✅ ✅ ✅ ✅
38 dt.is_month_start ✅ ✅ ✅ ✅ ✅ ✅ ✅
39 dt.is_quarter_end ✅ ✅ ✅ ✅ ✅ ✅
40 dt.is_quarter_start ✅ ✅ ✅ ✅ ✅ ✅
41 dt.is_year_end ✅ ✅ ✅ ✅ ✅ ✅ ✅
42 dt.is_year_start ✅ ✅ ✅ ✅ ✅ ✅ ✅
43 dt.microsecond ✅
44 dt.minute ✅ ✅ ✅ ✅ ✅ ✅ ✅
45 dt.month ✅ ✅ ✅ ✅ ✅ ✅ ✅
46 dt.month_name ✅ ✅
47 dt.nanosecond ✅
48 dt.normalize ✅
49 dt.quarter ✅ ✅ ✅ ✅ ✅ ✅ ✅
50 dt.round ✅
51 dt.second ✅ ✅ ✅ ✅ ✅ ✅ ✅
52 dt.strftime ✅
53 dt.time ✅
54 dt.timetz ✅
55 dt.to_period ✅
56 dt.tz ✅
57 dt.tz_localize ✅
58 dt.week ✅ ✅ ✅ ✅ ✅ ✅ ✅
59 dt.weekday ✅ ✅ ✅ ✅ ✅ ✅ ✅
60 dt.weekofyear ✅ ✅ ✅ ✅ ✅ ✅ ✅
61 dt.year ✅ ✅ ✅ ✅ ✅ ✅ ✅
62 dtype ✅
63 eq ✅ ✅ ✅ ✅ ✅ ✅ ✅
64 ffill ✅
65 fillna ✅ ✅ ✅ ✅ ✅ ✅ ✅
66 floordiv ✅
67 ge ✅ ✅ ✅ ✅ ✅ ✅ ✅
68 gt ✅ ✅ ✅ ✅ ✅ ✅ ✅
69 head ✅
70 idxmax ✅
71 idxmin ✅
72 is_monotonic_decreasing ✅
73 is_monotonic_increasing ✅
74 isin ✅ ✅ ✅ ✅ ✅ ✅ ✅
75 isna ✅ ✅ ✅ ✅ ✅ ✅ ✅
76 isnull ✅ ✅ ✅ ✅ ✅ ✅ ✅
77 le ✅ ✅ ✅ ✅ ✅ ✅ ✅
78 lt ✅ ✅ ✅ ✅ ✅ ✅ ✅
79 mad ✅
80 mask ✅
81 max ✅ ✅ ✅ ✅ ✅ ✅ ✅
82 mean ✅ ✅ ✅ ✅ ✅ ✅ ✅
83 median ✅ (win)
84 min ✅ ✅ ✅ ✅ ✅ ✅ ✅
85 mod ✅ ✅ ✅ ✅ ✅ ✅ ✅
86 mul ✅ ✅ ✅ ✅ ✅ ✅ ✅
87 multiply ✅ ✅ ✅ ✅ ✅ ✅ ✅
88 name ✅
89 ndim ✅
90 ne ✅ ✅ ✅ ✅ ✅ ✅ ✅
91 notna ✅ ✅ ✅ ✅ ✅ ✅ ✅
92 notnull ✅ ✅ ✅ ✅ ✅ ✅ ✅
93 nunique ✅ (agg) ✅ (agg) (agg) (agg) (agg)
94 pct_change ✅
95 pow ✅
96 prod ✅
97 quantile ✅ (agg) (win) (agg) ✅
98 radd ✅ ✅ ✅ ✅ ✅ ✅ ✅
99 rank ✅ ✅ ✅ ✅ ✅ ✅ ✅
100 rdiv ✅ ✅ ✅ ✅ ✅ ✅ ✅
101 replace ✅
102 rfloordiv ✅
103 rmod ✅ ✅ ✅ ✅ ✅ ✅ ✅
104 rmul ✅ ✅ ✅ ✅ ✅ ✅ ✅
105 round ✅ ✅ ✅ ✅ ✅ ✅ ✅
106 rpow ✅
107 rsub ✅ ✅ ✅ ✅ ✅ ✅ ✅
108 rtruediv ✅
109 sem ✅
110 shift ✅
111 size ✅ ✅ ✅ (agg) ✅ (agg) (agg)
112 skew ✅
113 std ✅ ✅ ✅ ✅ ✅
114 str.capitalize ✅ ✅ ✅ ✅ ✅ ✅ ✅
115 str.center ✅
116 str.contains ✅ ✅ ✅ ✅
117 str.count ✅
118 str.encode ✅
119 str.endswith ✅ ✅ ✅ ✅ ✅ ✅ ✅
120 str.find ✅
121 str.findall ✅
122 str.isalnum ✅
123 str.isalpha ✅
124 str.isdecimal ✅
125 str.isdigit ✅
126 str.islower ✅ ✅ ✅ ✅ ✅ ✅ ✅
127 str.isnumeric ✅
128 str.isspace ✅
129 str.istitle ✅
130 str.isupper ✅
131 str.len ✅ ✅ ✅ ✅ ✅ ✅ ✅
132 str.ljust ✅
133 str.lower ✅ ✅ ✅ ✅ ✅ ✅ ✅
134 str.lstrip ✅ ✅ ✅ ✅ ✅ ✅ ✅
135 str.match ✅
136 str.pad ✅
137 str.replace ✅ ✅
138 str.rfind ✅
139 str.rjust ✅
140 str.rsplit ✅
141 str.rstrip ✅ ✅ ✅ ✅ ✅ ✅ ✅
142 str.slice ✅
143 str.slice_replace ✅
144 str.split ✅
145 str.startswith ✅ ✅ ✅ ✅ ✅ ✅ ✅
146 str.strip ✅ ✅ ✅ ✅ ✅ ✅ ✅
147 str.swapcase ✅
148 str.title ✅ ✅ ✅ ✅
149 str.upper ✅ ✅ ✅ ✅ ✅ ✅ ✅
150 str.wrap ✅
151 sub ✅ ✅ ✅ ✅ ✅ ✅ ✅
152 subtract ✅ ✅ ✅ ✅ ✅ ✅ ✅
153 sum ✅ ✅ ✅ ✅ ✅ ✅ ✅
154 tail ✅
155 truediv ✅ ✅ ✅ ✅ ✅ ✅ ✅
156 var ✅ ✅ ✅ ✅ ✅
157 where ✅