dotnet / machinelearning

ML.NET is an open source and cross-platform machine learning framework for .NET.
https://dot.net/ml
MIT License
9.05k stars 1.88k forks source link

Create Order By multiple columns for DataFrame #5758

Open 0xcafebabee opened 3 years ago

0xcafebabee commented 3 years ago

System information

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
ericstj commented 3 years ago

CC @pgovind @eerhardt

pgovind commented 3 years ago

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.

janbodnar commented 1 year ago

Any updates on this issue?

https://stackoverflow.com/questions/76901645/sort-dataframe-by-multiple-columns-in-c-sharp/76959227

0xcafebabee commented 1 year ago

I made it on my own codebase (not in github) - I think I can provide the same functionality in this repository

superichmann commented 1 year ago

?

avernigora-clgx commented 8 months ago

@pgovind any good news on groupby ? 😆

0xcafebabee commented 8 months ago

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: @.***>