Pandas
pandas.pydata.org › docs › reference › api › pandas.DataFrame.sort_values.html
pandas.DataFrame.sort_values — pandas 3.0.2 documentation
GitHub · X · Mastodon · DataFrame.sort_values(by, *, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last', ignore_index=False, key=None)[source]# Sort by the values along either axis. Parameters: bystr or list of str · Name or list of names to sort by.
Beautiful Soup
tedboy.github.io › pandas › generated › pandas.DataFrame.sort_values.html
pandas.DataFrame.sort_values — Pandas Doc
pandas.DataFrame.sort_values · View page source · DataFrame.sort_values(by, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last')[source] Sort by the values along either axis ·
Videos
01:40
Resolving the Pandas sort_values() Issue: Correctly Sorting Your ...
07:28
Sort DataFrames Fast Using .sort_values() | Python Pandas Tutorial ...
04:18
Sorting Data in Pandas: Exploring the sort_values() Method - YouTube
07:58
Pandas Part 9 - The sort_values() method - YouTube
11:48
sort_index function | sort_values function | Pandas DataFrame | ...
PYTHON PANDAS TUTORIAL #10 - SORT_VALUES ...
Pandas-docs
pandas-docs.github.io › pandas-docs-travis › reference › api › pandas.DataFrame.sort_values.html
pandas.DataFrame.sort_values — pandas 0.25.0.dev0+752.g49f33f0d documentation
Pandas Arrays · Panel · Index ... · Enter search terms or a module, class or function name. DataFrame.sort_values(self, by, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last')[source]¶ ·...
GitHub
github.com › pandas-dev › pandas › issues › 15389
DataFrame.sort_values(inplace=True) is slow and eats too much memory · Issue #15389 · pandas-dev/pandas
February 14, 2017 - AlgosNon-arithmetic algos: value_counts, factorize, sorting, isin, clip, shift, diffNon-arithmetic algos: value_counts, factorize, sorting, isin, clip, shift, diffPerformanceMemory or execution speed performanceMemory or execution speed performanceinplaceRelating to inplace parameter or equivalentRelating to inplace parameter or equivalent ... import pandas import numpy import resource import sys variant, nrows, ncols = sys.argv[1:4] numpy.random.seed(0) df = pandas.DataFrame(numpy.random.randn(int(nrows), int(ncols))) if variant == '1': df.sort_values(by=list(df.columns), inplace=True) elif v
Author liori
Pandas
pandas.pydata.org › docs › reference › api › pandas.Series.sort_values.html
pandas.Series.sort_values — pandas 3.0.1 documentation
GitHub · X · Mastodon · Series.sort_values(*, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last', ignore_index=False, key=None)[source]# Sort by the values. Sort a Series in ascending or descending order by some criterion. Parameters: axis{0 or ‘index’} Unused.
GitHub
gist.github.com › HamedMP › 1a821e3bec44e9fa92002794186e29f9
Sort values in a Pandas DataFrame along all axis and get their index · GitHub
Save HamedMP/1a821e3bec44e9fa92002794186e29f9 to your computer and use it in GitHub Desktop. Download ZIP · Sort values in a Pandas DataFrame along all axis and get their index · Raw · sort_elements_all_axis_pandas.py · This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below.
Pandas
pandas.pydata.org › pandas-docs › stable › reference › api › pandas.Series.sort_values.html
pandas.Series.sort_values — pandas 3.0.2 documentation
GitHub · X · Mastodon · Series.sort_values(*, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last', ignore_index=False, key=None)[source]# Sort by the values. Sort a Series in ascending or descending order by some criterion. Parameters: axis{0 or ‘index’} Unused.
Pandas
pandas.pydata.org › docs › dev › reference › api › pandas.DataFrame.sort_values.html
pandas.DataFrame.sort_values — pandas 3.0.0rc2+20.g501c5052ca documentation
GitHub · X · Mastodon · DataFrame.sort_values(by, *, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last', ignore_index=False, key=None)[source]# Sort by the values along either axis. Parameters: bystr or list of str · Name or list of names to sort by.
Pandas
pandas.pydata.org › pandas-docs › stable › reference › api › pandas.DataFrame.sort_values.html
pandas.DataFrame.sort_values — pandas 2.2.2 documentation
GitHub · Twitter · Mastodon · DataFrame.sort_values(by, *, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last', ignore_index=False, key=None)[source]# Sort by the values along either axis. Parameters: bystr or list of str · Name or list of names to sort by.
GitHub
github.com › pandas-dev › pandas › issues › 39877
Why .sort_values() on column containing same values shuffles entire dataframe ? · Issue #39877 · pandas-dev/pandas
February 18, 2021 - df = pd.DataFrame({ 'col1': ['A', 'A', 'A', 'A', 'A', 'A']*15, 'col2': [1.0, 1.0, 1.0, 1.0, 1.0, 1.0]*15, 'col3': [0, 1, 9, 4, 2, 3]*15, 'col4': ['a', 'B', 'c', 'D', 'e', 'F']*15 }) df.sort_values('col2', ascending=True) Why this operati...
Author artsheiko
GitHub
github.com › pandas-dev › pandas › issues › 57312
BUG: `sort_values` should have consistent behavior irrespective of the number of sort columns · Issue #57312 · pandas-dev/pandas
February 9, 2024 - import pandas as pd import datetime df = pd.DataFrame([["", 1], [datetime.date.today(), 2]], columns=['a', 'b']) # column a contains mixed data df.sort_values(['a']) # raises error df.sort_values(['a', 'b']) # no error df.sort_values(['a', 'a']) # no error
Author arpit-goel
pandas
pandas.pydata.org › pandas-docs › dev › reference › api › pandas.DataFrame.sort_values.html
pandas.DataFrame.sort_values — pandas documentation
GitHub · X · Mastodon · DataFrame.sort_values(by, *, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last', ignore_index=False, key=None)[source]# Sort by the values along either axis. This method sorts the DataFrame by the values in one or more columns or by index/column ...
Pandas
pandas.pydata.org › pandas-docs › version › 2.2.0 › reference › api › pandas.DataFrame.sort_values.html
pandas.DataFrame.sort_values — pandas 2.2.0 documentation
GitHub · Twitter · Mastodon · DataFrame.sort_values(by, *, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last', ignore_index=False, key=None)[source]# Sort by the values along either axis. Parameters: bystr or list of str · Name or list of names to sort by.
GitHub
github.com › pandas-dev › pandas › blob › main › pandas › core › sorting.py
pandas/pandas/core/sorting.py at main · pandas-dev/pandas
Callable key function applied to every element in keys before sorting · codes_given: bool, False · Avoid categorical materialization if codes are already provided. · Returns · ------- np.ndarray[np.intp] """ from pandas.core.arrays import Categorical · · if na_position not in ["last", "first"]: raise ValueError(f"invalid na_position: {na_position}") ·
Author pandas-dev
GitHub
github.com › pandas-dev › pandas › issues › 13973
df.sort_values by 2 columns does not work in py3.5.1 but work in py2? · Issue #13973 · pandas-dev/pandas
August 12, 2016 - Code Sample, a copy-pastable example if possible The code above works in py2 but not works in py3. Expected Output should get sorted dataframe. output of pd.show_versions() 0.18.0
Author seanDot7
Pandas
pandas.pydata.org › pandas-docs › version › 2.1 › reference › api › pandas.DataFrame.sort_values.html
pandas.DataFrame.sort_values — pandas 2.1.4 documentation
GitHub · Twitter · Mastodon · DataFrame.sort_values(by, *, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last', ignore_index=False, key=None)[source]# Sort by the values along either axis. Parameters: bystr or list of str · Name or list of names to sort by.
GitHub
gist.github.com › hellpanderrr › 599bce82ecc6934aa9e1
Pandas sort dataframe using custom function · GitHub
April 14, 2017 - def sort_df(df, column_idx, key): '''Takes dataframe, column index and custom function for sorting, returns dataframe sorted by this column using this function''' col = df.iloc[:,column_idx] temp = np.array(col.values.tolist()) order = sorted(range(len(temp)), key=lambda j: key(temp[j])) return df.iloc[order]
Pandas
pandas.pydata.org › pandas-docs › version › 1.3 › reference › api › pandas.DataFrame.sort_values.html
pandas.DataFrame.sort_values — pandas 1.3.5 documentation
Natural sort with the key argument, using the natsort <https://github.com/SethMMorton/natsort> package. >>> df = pd.DataFrame({ ... "time": ['0hr', '128hr', '72hr', '48hr', '96hr'], ... "value": [10, 20, 30, 40, 50] ... }) >>> df time value 0 0hr 10 1 128hr 20 2 72hr 30 3 48hr 40 4 96hr 50 >>> from natsort import index_natsorted >>> df.sort_values( ... by="time", ... key=lambda x: np.argsort(index_natsorted(df["time"])) ... ) time value 0 0hr 10 3 48hr 40 2 72hr 30 4 96hr 50 1 128hr 20 · previous · pandas.DataFrame.sort_index ·
Top answer 1 of 3
199
Dataframes have a sort_index method which returns a copy by default. Pass inplace=True to operate in place.
import pandas as pd
df = pd.DataFrame([1, 2, 3, 4, 5], index=[100, 29, 234, 1, 150], columns=['A'])
df.sort_index(inplace=True)
print(df.to_string())
Gives me:
A
1 4
29 2
100 1
150 5
234 3
2 of 3
19
Slightly more compact:
df = pd.DataFrame([1, 2, 3, 4, 5], index=[100, 29, 234, 1, 150], columns=['A'])
df = df.sort_index()
print(df)
Note:
sorthas been deprecated, replaced bysort_indexfor this scenario- preferable not to use
inplaceas it is usually harder to read and prevents chaining. See explanation in answer here: Pandas: peculiar performance drop for inplace rename after dropna
Pandas
pandas.pydata.org › pandas-docs › version › 1.5 › reference › api › pandas.DataFrame.sort_values.html
pandas.DataFrame.sort_values — pandas 1.5.3 documentation
GitHub · Twitter · DataFrame.sort_values(by, *, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last', ignore_index=False, key=None)[source]# Sort by the values along either axis. Parameters · bystr or list of str · Name or list of names to sort by.