In which we study Pandas



In [1]:

    
import pandas as pd



In [2]:

    
data = pd.ExcelFile("intro_pandas.xls")



In [3]:

    
print data.sheet_names









    



[u'Sheet1', u'Sheet2', u'Sheet3']



In [4]:

    
data_sheet1 = data.parse(u'Sheet1')



In [5]:

    
data_sheet1



In [6]:

    
data_sheet1.sort('Age')



In [7]:

    
data_sheet1.sort('Salary')



In [8]:

    
%pylab inline









    



Populating the interactive namespace from numpy and matplotlib



In [9]:

    
data_sheet1.plot('Name', 'Age')
plt.show()



In [10]:

    
data_sheet1.plot('Name', 'Salary')
plt.show()



In [ ]:

	Name	Age	Salary
0	Bob	18	100
1	Rob	55	500
2	Mike	37	770

	Name	Age	Salary
0	Bob	18	100
2	Mike	37	770
1	Rob	55	500

	Name	Age	Salary
0	Bob	18	100
1	Rob	55	500
2	Mike	37	770