Pandas Drop Rows With Condition Code Example

Snippet 1
  # import pandas library 
import pandas as pd 
  
# dictionary with list object in values 
details = { 
    'Name' : ['Ankit', 'Aishwarya', 'Shaurya', 
              'Shivangi', 'Priya', 'Swapnil'], 
    'Age' : [23, 21, 22, 21, 24, 25], 
    'University' : ['BHU', 'JNU', 'DU', 'BHU',  
                    'Geu', 'Geu'], 
} 
  
# creating a Dataframe object  
df = pd.DataFrame(details, columns = ['Name', 'Age', 
                                      'University'], 
                  index = ['a', 'b', 'c', 'd', 'e', 'f']) 
  
# get names of indexes for which 
# column Age has value >= 21 
# and column University is BHU 
index_names = df[ (df['Age'] >= 21) & (df['University'] == 'BHU')].index 
  
# drop these given row 
# indexes from dataFrame 
df.drop(index_names, inplace = True) 
  
df 
 
Snippet 2
  # importing pandas as pd 
import pandas as pd 
  
# Read the csv file and construct the  
# dataframe 
df = pd.read_csv('nba.csv') 
  
# First filter out those rows which 
# does not contain any data 
df = df.dropna(how = 'all') 
  
# Filter all rows for which the player's 
# age is greater than or equal to 25 
df.drop(df[df['Age'] < 25].index, inplace = True) 
  
# Print the modified dataframe 
print(df.head(15)) 
  
# Print the shape of the dataframe 
print(df.shape) 
 
Snippet 3
  # Filter all rows for which the player's 
# age is greater than or equal to 25 
df_filtered = df[df['Age'] >= 25] 
  
# Print the new dataframe 
print(df_filtered.head(15) 
  
# Print the shape of the dataframe 
print(df_filtered.shape) 
 

Similar Snippets


Pandas Count Rows With Value Code Example - pandas

Pandas Ttable With Sum Totals Code Example - pandas

Pandas Show Top 10 Rows Code Example - pandas

How To Drop Columns In Pandas Code Example - pandas

Pandas Read Excel With Two Headers Code Example - pandas

Add An Index Column Pandas Code Example - pandas

Remove 1st Column Pandas Code Example - pandas

Pandas Iterrows Code Example - pandas

Slicing In Pandas Code Example - pandas

Convert Pandas Data Frame To Latex File Code Example - pandas

Append New Data On Pandas Dataframe Code Example - pandas

Getting Dummies And Input Them To Pandas Dataframe Code Example - pandas

Pandas Dataframe Froms String Code Example - pandas

Combine Two Dataframe In Pandas Code Example - pandas

Str_Count On Pandas Series Code Example - pandas

Rename Row Pandas Code Example - pandas

Dictionary To A Dataframe Pandas Arrays Must All Be Same Length Code Example - pandas

Pandas Select All Columns Except One Code Example - pandas

How To Change Column Name In Pandas Code Example - pandas

Creating A Pandas Df Code Example - pandas

Pandas Read From Website Code Example - pandas

Index Max Pandas Code Example - pandas

Pandas Cumulative Sum Column Code Example - pandas

Onehot Encode List Of Columns Pandas Code Example - pandas

How To Set Pandas Dataframe As Global Code Example - pandas

Pandas Merge Two Columns From Different Dataframes Code Example - pandas

Pandas Frame Convert String Code Example - pandas

How To Merge Two Column Pandas Code Example - pandas

Reshape Wide To Long In Pandas Code Example - pandas