Link to the previous post : https://statinfer.com/104-2-5-subsetting-data-with-variable-filter-condition-in-python/
In the previous post we created subsets of data by condition filtering, in this post we will create the new subsets by sorting one or more column values.
We will use Online retail dataset.
Online_Retail=pd.read_csv("datasets\\Online Retail Sales Data\\Online Retail.csv", encoding = "ISO-8859-1")
Online_Retail.head(5)
Online_Retail.columns.values
Online_Retail_sort=Online_Retail.sort('UnitPrice')
Online_Retail_sort.head(5)
ascending=False
for descending orderOnline_Retail_sort=Online_Retail.sort('UnitPrice',ascending=False)
Online_Retail_sort.head(5)
auto_data.columns.values
auto_data_sort=auto_data.sort( ' length')
auto_data_sort.head(5)
auto_data_sort1=auto_data.sort( ' length',ascending=False)
auto_data_sort1.head(5)