René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Improve sorting on DataFrame","articleBody":"Currently, we don't support multiColumn sorting. For example let's use this data as example: https://www.kaggle.com/datasets/prashant111/the-simpsons-dataset?resource=download\r\n\r\nI have this DataFrame that I want to sort by season and by episode\r\n![Capture d’écran 2023-04-11 à 11 31 12](https://user-images.githubusercontent.com/33934979/231117983-0612d5e6-0a76-4b5b-bf9f-8925d33d4923.png)\r\n\r\nTo sort it by season and by episode I need to do this:\r\n\r\n```st\r\ndf\r\n    sortBy: #number_in_season;\r\n    sortBy: #season\r\n```\r\n\r\nIf I do it the other way around, first season and then the episode it does not work.\r\n\r\nThis raise the question that we need a better api and mechanism to sort a dataframe. Some options can be:\r\n\r\nWith ChainedSortFunction\r\n```st\r\ndf sortBy: #season ascending, #number_in_season ascending\r\n```\r\n\r\nOr more pandas like: https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.sort_values.html\r\n```st\r\ndf sortValuesDescending: ( #season #number_in_season)\r\ndf sortValuesAscending: ( #season #number_in_season)\r\n```\r\n\r\nAlso we need to add the `sorted` methods that return a new DataFrame.","author":{"url":"https://github.com/jordanmontt","@type":"Person","name":"jordanmontt"},"datePublished":"2023-04-11T13:11:50.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/215/DataFrame/issues/215"}