user16887
user16887
Programming language:Whatever
2021-03-20 11:16:52
0
Q:

filter dataframe based on condition into new dataframe

ib11
ib11
Code: Whatever
2021-06-10 02:59:56 
# importing pandas 
import pandas as pd 
  
record = { 
  
 'Name': ['Ankit', 'Amit', 'Aishwarya', 'Priyanka', 'Priya', 'Shaurya' ], 
 'Age': [21, 19, 20, 18, 17, 21], 
 'Stream': ['Math', 'Commerce', 'Science', 'Math', 'Math', 'Science'], 
 'Percentage': [88, 92, 95, 70, 65, 78] } 
  
# create a dataframe 
dataframe = pd.DataFrame(record, columns = ['Name', 'Age', 'Stream', 'Percentage']) 
  
print("Given Dataframe :\n", dataframe)  
  
# selecting rows based on condition 
rslt_df = dataframe[dataframe['Percentage'] > 80] 
  
print('\nResult dataframe :\n', rslt_df)
0

Tags

Related

New to Communities?

Join the community