-
Java, perform COUNT on each group of a large csv file
Application • 0 Reply • 289 View • 2024-08-23 15:29 -
-
Java, fill each row having a null value in a csv file with values in the directly previous row
Application • 0 Reply • 254 View • 2024-08-22 16:21 -
Get rankings of Excel rows in each group while retaining the existing order
Desktop • 0 Reply • 304 View • 2024-08-22 16:06 -
Group and Summarize data, and align to the specified sequence
Application • 0 Reply • 218 View • 2024-08-21 15:00 -
-
Group an EXCEL table and concatenate values of rows meeting the specified condition
Desktop • 0 Reply • 279 View • 2024-08-20 15:03 -
SQL, compute cumulative sums according to the termination condition
Application • 0 Reply • 265 View • 2024-08-19 17:39 -
-
In an Excel table, find rows corresponding to the 1st and the last non-empty cells in each column
Desktop • 0 Reply • 248 View • 2024-08-19 14:03 -
-
SQL, concatenate multiple rows of strings and remove duplicates
Application • 0 Reply • 242 View • 2024-08-16 15:26 -
SQL, output associated records having many-to-many relationship row by row
Application • 0 Reply • 224 View • 2024-08-15 15:54 -
-
Copy each row N times (N is the cell value of the specified column)
Desktop • 0 Reply • 205 View • 2024-08-14 15:36 -
-
Group rows and combine non-null values in each of non-grouping columns
Desktop • 0 Reply • 367 View • 2024-08-09 15:40 -
-
-
-
SQL, split values of two columns respectively and count members of their intersection
Application • 0 Reply • 293 View • 2024-08-07 18:08 -
Group and summarize rows while retaining columns whose values are unchanged
Desktop • 0 Reply • 270 View • 2024-08-06 16:04 -
SQL, Set different flags for different groups according to whether there are duplicate values
Application • 0 Reply • 357 View • 2024-08-06 16:02 -
Get duplicate records from a csv file and sort them
Application • 0 Reply • 399 View • 2024-08-05 17:30 -
-
Define a dynamic range of columns and perform aggregation
Desktop • 0 Reply • 218 View • 2024-08-05 09:25 -
Retrieve multiple columns from a csv file to generate a new file
Application • 0 Reply • 287 View • 2024-08-02 14:02 -
Clear duplicate lines and lines having missing values from a csv file
Application • 0 Reply • 251 View • 2024-08-01 15:37 -
Group columns of an Excel table and perform aggregation
Desktop • 0 Reply • 307 View • 2024-08-01 14:32 -
Merge multiple files, remove duplicates and sort the result
Application • 0 Reply • 297 View • 2024-07-31 18:28