Data Science

Sorting and Limiting Data

Senior Data Analyst
April 16, 2026
5 min read

Sorting

df.sort_values('price') # Ascending

df.sort_values('price', ascending=False) # Descending

df.sort_values(['category', 'price']) # Multiple columns

Limiting (Head/Tail)

df.head(10) # First 10 rows (LIMIT 10)

df.tail(5) # Last 5 rows

df.nlargest(3, 'price') # Top 3 by price

*Day 107: Aggregations in Pandas (GROUP BY).*

Ready to put your knowledge into practice?

Join SQL Mastery and learn through interactive exercises.