import pandas as pd data = {'Name':['Tom', 'Jack', 'Steve', 'Ricky', 'Prit'],'Age':[28,34,29,42,24]} df = pd.DataFrame(data, index=['rank1','rank2','rank3','rank4','rank5']) print df