Skip to main content

Sorting

import pandas as pd

df_cars = pd.read_csv("data/cars.csv", sep=";")
df_cars.sort_values(by="Car")
Car MPG Cylinders Displacement Horsepower Weight Acceleration Model Origin
104 AMC Ambassador Brougham 13.0 8 360.0 175.0 3821. 11.0 73 US
10 AMC Ambassador DPL 15.0 8 390.0 190.0 3850. 8.5 70 US
74 AMC Ambassador SST 17.0 8 304.0 150.0 3672. 11.5 72 US
265 AMC Concord 19.4 6 232.0 90.00 3210. 17.2 78 US
323 AMC Concord 24.3 4 151.0 90.00 3003. 20.1 80 US
... ... ... ... ... ... ... ... ... ...
84 Volvo 145e (sw) 18.0 4 121.0 112.0 2933. 14.5 72 Europe
187 Volvo 244DL 22.0 4 121.0 98.00 2945. 14.5 75 Europe
215 Volvo 245 20.0 4 130.0 102.0 3150. 15.7 76 Europe
283 Volvo 264gl 17.0 6 163.0 125.0 3140. 13.6 78 Europe
369 Volvo Diesel 30.7 6 145.0 76.00 3160. 19.6 81 Europe

407 rows × 9 columns

df_cars.sort_values(by="Car", ascending=False)
Car MPG Cylinders Displacement Horsepower Weight Acceleration Model Origin
369 Volvo Diesel 30.7 6 145.0 76.00 3160. 19.6 81 Europe
283 Volvo 264gl 17.0 6 163.0 125.0 3140. 13.6 78 Europe
215 Volvo 245 20.0 4 130.0 102.0 3150. 15.7 76 Europe
187 Volvo 244DL 22.0 4 121.0 98.00 2945. 14.5 75 Europe
84 Volvo 145e (sw) 18.0 4 121.0 112.0 2933. 14.5 72 Europe
... ... ... ... ... ... ... ... ... ...
323 AMC Concord 24.3 4 151.0 90.00 3003. 20.1 80 US
265 AMC Concord 19.4 6 232.0 90.00 3210. 17.2 78 US
74 AMC Ambassador SST 17.0 8 304.0 150.0 3672. 11.5 72 US
10 AMC Ambassador DPL 15.0 8 390.0 190.0 3850. 8.5 70 US
104 AMC Ambassador Brougham 13.0 8 360.0 175.0 3821. 11.0 73 US

407 rows × 9 columns

df_cars.sort_values(by=["Car", "Model"])
Car MPG Cylinders Displacement Horsepower Weight Acceleration Model Origin
104 AMC Ambassador Brougham 13.0 8 360.0 175.0 3821. 11.0 73 US
10 AMC Ambassador DPL 15.0 8 390.0 190.0 3850. 8.5 70 US
74 AMC Ambassador SST 17.0 8 304.0 150.0 3672. 11.5 72 US
265 AMC Concord 19.4 6 232.0 90.00 3210. 17.2 78 US
323 AMC Concord 24.3 4 151.0 90.00 3003. 20.1 80 US
... ... ... ... ... ... ... ... ... ...
84 Volvo 145e (sw) 18.0 4 121.0 112.0 2933. 14.5 72 Europe
187 Volvo 244DL 22.0 4 121.0 98.00 2945. 14.5 75 Europe
215 Volvo 245 20.0 4 130.0 102.0 3150. 15.7 76 Europe
283 Volvo 264gl 17.0 6 163.0 125.0 3140. 13.6 78 Europe
369 Volvo Diesel 30.7 6 145.0 76.00 3160. 19.6 81 Europe

407 rows × 9 columns

df_cars.sort_values(by=["Car", "Model"], ascending=[False, True])
Car MPG Cylinders Displacement Horsepower Weight Acceleration Model Origin
369 Volvo Diesel 30.7 6 145.0 76.00 3160. 19.6 81 Europe
283 Volvo 264gl 17.0 6 163.0 125.0 3140. 13.6 78 Europe
215 Volvo 245 20.0 4 130.0 102.0 3150. 15.7 76 Europe
187 Volvo 244DL 22.0 4 121.0 98.00 2945. 14.5 75 Europe
84 Volvo 145e (sw) 18.0 4 121.0 112.0 2933. 14.5 72 Europe
... ... ... ... ... ... ... ... ... ...
265 AMC Concord 19.4 6 232.0 90.00 3210. 17.2 78 US
323 AMC Concord 24.3 4 151.0 90.00 3003. 20.1 80 US
74 AMC Ambassador SST 17.0 8 304.0 150.0 3672. 11.5 72 US
10 AMC Ambassador DPL 15.0 8 390.0 190.0 3850. 8.5 70 US
104 AMC Ambassador Brougham 13.0 8 360.0 175.0 3821. 11.0 73 US

407 rows × 9 columns

df_cars.sort_index
<bound method DataFrame.sort_index of                            Car     MPG Cylinders Displacement Horsepower  \
0                       STRING  DOUBLE       INT       DOUBLE     DOUBLE   
1    Chevrolet Chevelle Malibu    18.0         8        307.0      130.0   
2            Buick Skylark 320    15.0         8        350.0      165.0   
3           Plymouth Satellite    18.0         8        318.0      150.0   
4                AMC Rebel SST    16.0         8        304.0      150.0   
..                         ...     ...       ...          ...        ...   
402            Ford Mustang GL    27.0         4        140.0      86.00   
403          Volkswagen Pickup    44.0         4        97.00      52.00   
404              Dodge Rampage    32.0         4        135.0      84.00   
405                Ford Ranger    28.0         4        120.0      79.00   
406                 Chevy S-10    31.0         4        119.0      82.00   

     Weight Acceleration Model  Origin  
0    DOUBLE       DOUBLE   INT     CAT  
1     3504.         12.0    70      US  
2     3693.         11.5    70      US  
3     3436.         11.0    70      US  
4     3433.         12.0    70      US  
..      ...          ...   ...     ...  
402   2790.         15.6    82      US  
403   2130.         24.6    82  Europe  
404   2295.         11.6    82      US  
405   2625.         18.6    82      US  
406   2720.         19.4    82      US  

[407 rows x 9 columns]>
df_cars["Car"].sort_values()
104    AMC Ambassador Brougham
10          AMC Ambassador DPL
74          AMC Ambassador SST
265                AMC Concord
323                AMC Concord
                ...           
84             Volvo 145e (sw)
187                Volvo 244DL
215                  Volvo 245
283                Volvo 264gl
369               Volvo Diesel
Name: Car, Length: 407, dtype: object