import pandas as pd
data =pd.read_excel("f:\\Book1.xlxs")
print("**display data from dataframe")
print(data)
print("**OPERATION ON dataframe**")
print("\n1.view first few roes and columns in dataframe")
print(data.head())
print("\n2.number of rows and columns in dataframe")
print("data.shape")
print("\n3.Filtered data['age'] col<20)")
Filtered_data=data[data ['age']<20]
print("Filtered_data")
print("\n4.sort dataframe based on 'age' col(by='age',ascending=True")
sorted_data=data.sort_value()
print(sorted_data)