machinelearning
machinelearning copied to clipboard
dotnet
Create Order By multiple columns for DataFrame
System information
- OS version/distro: Windows 10
- .NET Version (eg., dotnet --info): netstandard2.0
Issue
Please provide new functionality for DataFrames: Order By multiple columns, for example:
// Arrange
| Column0 | Column1 | Column2 | Column3 |
|---|---|---|---|
| AAA | 1 | 1212 | 1313 |
| BBB | 3 | 99 | 1616 |
| CCC | 2 | 98 | 1717 |
| DDD | 2 | 97 | 1818 |
| EEE | 1 | 1111 | 1515 |
| FFF | 1 | 1212 | 1414 |
// Act
DataFrame.OrderBy(new [] { "Column1", "Column2", "Column3" })
// Assert
| Column0 | Column1 | Column2 | Column3 |
|---|---|---|---|
| EEE | 1 | 1111 | 1515 |
| AAA | 1 | 1212 | 1313 |
| FFF | 1 | 1212 | 1414 |
| DDD | 2 | 97 | 1818 |
| CCC | 2 | 98 | 1717 |
| BBB | 3 | 99 | 1616 |
Dupe of https://github.com/dotnet/machinelearning/issues/5649.
Support for multiple group by wasn't high priority when GroupBy was implemented, but I will make a run at this after .NET 6 work winds down and there's more time.
Any updates on this issue?
https://stackoverflow.com/questions/76901645/sort-dataframe-by-multiple-columns-in-c-sharp/76959227
I made it on my own codebase (not in github) - I think I can provide the same functionality in this repository
Ok, will create PR on this shortly ))
On Wed, Mar 27, 2024, 11:10 PM Andrey Vernigora @.***> wrote:
@pgovind https://github.com/pgovind any good news on this? 😆
— Reply to this email directly, view it on GitHub https://github.com/dotnet/machinelearning/issues/5758#issuecomment-2024131482, or unsubscribe https://github.com/notifications/unsubscribe-auth/ATZI3SV5AUU5U5OUG32AK7TY2NGW3AVCNFSM43MBPMR2U5DIOJSWCZC7NNSXTN2JONZXKZKDN5WW2ZLOOQ5TEMBSGQYTGMJUHAZA . You are receiving this because you authored the thread.Message ID: @.***>