77,936 questions
0
votes
1
answer
60
views
How to filter data into another spreadsheet based on two values in the same column in google sheets
I'm making a book spreadsheet where I'd like formats to filter into a spreadsheet for physical books (Hardcover and paperback) and another for Digital books (ebooks and audiobooks). I can only seem ...
3
votes
3
answers
156
views
How do I cluster/group duplicate customer objects in my list based on email OR mobile in C#
For my current project in C#, I am tasked with fetching customer details from a data source, 'cleansing' said customers (making sure the name is capitalised correctly, mobile formatted correctly, etc.)...
- 61
-2
votes
0
answers
34
views
LibreOffice Writer - controlling the flow of sorted names in multiple columns across multiple pages [closed]
I have a long list of first and last names, one to a line, sorted alphabetically by last name.
(I haven't found the answer for what I'm looking for on Stackoverflow, for LibreOffice Writer, but there ...
- 169
0
votes
0
answers
19
views
Prisma - Sorting by function applied on a column
I want to use a function in my orderBy clause. To my great surprise I can't find a way in the official documentation to do this without executing raw SQL in Prisma. This is similar to what Python or ...
- 11
1
vote
2
answers
93
views
Typescript sort array of array tuples
I have tuples in the form (Status and priority)
[State,prio]
States are defined so:
enum State {
A = "A",
B = "B",
C = "C"
...
}
Now i want to sort an ...
- 1,107
3
votes
0
answers
101
views
Fast lazy sort & deduplication over multiple sorted lazy sequences in Clojure
I implemented a few lazy sort & merge functions that are used heavily in my ReBAC authorization library, EACL, to lazily "merge" & deduplicate ~1M datoms emitted from Datomic's d/...
- 29.1k
1
vote
2
answers
111
views
Why is the worst-case binary selection sort time complexity considered O(n^2)?
Wikipedia and other textbooks reference binary selection sort's asymptotic worst-case time complexity to be O(n^2), usually justifying this with any extra computation caused by swaps. I don't ...
- 33
0
votes
1
answer
102
views
Sorting completed date in WooCommerce order list (admin dashboard)
I added a new column of completed date in the woocommerce order list page using the code here. The new column shows sorting buttons (up/down arrows) properly but when clicked, seems like it sorts on ...
- 19
0
votes
0
answers
44
views
Sorting items in a Pina store is very slow
I have a Pinia store defined like this:
export type Era = {
id: number
name: string
start_year: number
end_year: number
item_count: number
}
const settingStore = {
eras: ref([] as Era[])...
- 130k
1
vote
1
answer
128
views
I need to sort a list of coordinate pairs by y decreasing then x increasing [duplicate]
I am trying to sort this list of pairs so they are ordered by y decreasing as the primary factor and x increasing as a tie breaker.
[['0', '0'], ['0', '1'], ['1','1'], ['2','1'], ['0', '2'], ['1','2'],...
0
votes
1
answer
63
views
Sort Tabs Alphabetically keeping Certain Tabs first and ignoring Hidden Tabs
I have a file that includes a variety of reference sheets and sheets that are only used at the end of the academic year plus a tab/sheet for individual students. Students come and go so I need the ...
- 17
1
vote
2
answers
131
views
How to sort only based on the value in the B column of every row?
This is what I am currently using for my code.
Private Sub CommandButton1_Click()
' Sort button and save a backup copy
Range("B1").Sort Key1:=Range("b3"), Order1:=xlAscending, Key2:...
- 95
-2
votes
1
answer
123
views
Is this a valid JavaScript approach for sorting large arrays of unique integers efficiently? [closed]
I’m experimenting with sorting large arrays of unique integers in JavaScript and came up with a simple approach. I’m curious if it’s a recognized pattern or if there are potential pitfalls I might be ...
- 1
0
votes
2
answers
97
views
Make onEdit work for two separate tables within the same sheet [closed]
How would I be able to make this function work for two separate tables within the same sheet?
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Leaderboard"); ...
2
votes
1
answer
89
views
Sort each row of a pandas column consisting of delimited strings
CONTEXT
Let's say I have df, which consists of a column of delimited strings that I would like to sort.
import pandas as pd
df = pd.DataFrame({'sort_me':['foo; bar','foo; bar','bar; foo']})
df
...
- 1,645