In [1]:
import pandas as pd
import sys
%matplotlib inline
In [2]:
print 'Python version ' + sys.version
print 'Pandas version ' + pd.__version__
Python version 2.7.5 |Anaconda 2.1.0 (64-bit)| (default, Jul  1 2013, 12:37:52) [MSC v.1500 64 bit (AMD64)]
Pandas version 0.15.2

Sort

How do I sort a column ascending?

In [3]:
# dataframe
df = pd.DataFrame(data={'col1':[0,10,2,30,4]})
df
Out[3]:
col1
0 0
1 10
2 2
3 30
4 4
In [4]:
# Sort by col1 ascending
df.sort(columns='col1')
Out[4]:
col1
0 0
2 2
4 4
1 10
3 30

How do I sort by the index?

In [5]:
# Unordered index

d = {'col2':[22,10,113]}

i = [pd.Timestamp('20130102'),
     pd.Timestamp('2013-01-01'),
     pd.Timestamp('1/3/2013')]
                 

df = pd.DataFrame(data=d, index = i)
df
Out[5]:
col2
2013-01-02 22
2013-01-01 10
2013-01-03 113
In [6]:
# Index sorted ascending
df.sort_index()
Out[6]:
col2
2013-01-01 10
2013-01-02 22
2013-01-03 113

Author: David Rojas