-
-
-
jinxing • Desktop • 100 View • 2024-07-11 08:25:39
Write continuous numbers in a string of numbers as intervals
-
jinxing • Desktop • 101 View • 2024-07-09 13:08:28
Repeat value of each cell N times according to value of the neighboring cell
-
-
jinxing • Desktop • 183 View • 2024-07-08 03:02:42
Expand multi-row text in a cell to multiple cells
-
jinxing • Application • 132 View • 2024-07-08 00:50:24
Judge whether two csv files have same content
-
jinxing • Desktop • 154 View • 2024-07-05 06:04:23
Concatenate column values and perform grouping & aggregation
-
jinxing • Desktop • 149 View • 2024-07-04 13:37:43
Summarize data every two columns under each category
-
-
jinxing • Application • 122 View • 2024-07-04 07:54:29
Filter a CSV file according to condition and output result as a list
-
jinxing • Application • 149 View • 2024-07-04 07:08:50
Convert irregular format CSV to standard JSON strings
-
jinxing • Application • 147 View • 2024-07-01 03:24:48
Rearrange an irregular text file into a two-dimensional table
-
-
jinxing • Desktop • 123 View • 2024-07-01 01:56:51
Split & group text and perform distinct on each group
-
jinxing • Application • 129 View • 2024-07-01 00:39:05
Convert a rowwise CSV file to a multilayer JSON string
-
jinxing • Desktop • 142 View • 2024-06-26 02:21:11
Split each cell value and expand it according to the specified rule
-
jinxing • Application • 162 View • 2024-06-26 01:22:53
Filter a CSV file and re-arrange it by category
-
jinxing • Desktop • 130 View • 2024-06-24 13:21:00
Import a txt file where separator is missing in a column to Excel
-
-
jinxing • Desktop • 131 View • 2024-06-24 09:00:03
In Excel, parse hexadecimal numbers and make queries
-
jinxing • Desktop • 138 View • 2024-06-24 08:59:47
In Excel, search a target value and hide columns to its right
-
jinxing • Desktop • 148 View • 2024-06-24 08:59:29
In Excel, judge whether a word has duplicate letters
-
jinxing • Desktop • 132 View • 2024-06-24 08:58:52
Excel, find the maximum value and the neighboring N members before and after
-
jinxing • Desktop • 138 View • 2024-06-24 08:58:35
In Excel, combine multiple detail data columns into one row in each group
Recent hot
- Performance optimization case course: TPCH-Q5
- Performance optimization case course: TPCH-Q6
- Performance optimization case course: TPCH-Q7
- Performance optimization case course: TPCH-Q8
- Performance optimization case course: TPCH-Q9
- Performance optimization case course: TPCH-Q10
- Performance optimization case course: TPCH-Q11
- Performance optimization case course: TPCH-Q12
- Example codes for comparing SPL, SQL, and Python
- 1.1 Simple set