import pandas as pd
data=pd.read_excel(r'C:\Users\bca\AppData\Local\Programs\Python\Python310\shree.xlsx')
print("\n**Display data from dataframes**")
print(data)
print("\  operation on dataframes")
print("\n1.view the first few rows of the dataframes")
print(data.head())
print("\n2.number of rows and columns in the dataframes:",end="")
print(data.shape)
print("\n3.filtered data(age column<25):")
filtered_data=data[data['age']<25]
print(filtered_data)
print("\n4. sort dataframes based on'age' col in ascendingorder")
sorted_data=data.sort_values(by='age',ascending=True)
print(sorted_data)
print("\n pgm end..")