pandas drop columns that are all nan code example

Example 1: drop if nan in column pandas

df = df[df['EPS'].notna()]

Example 2: dropping nan in pandas dataframe

df.dropna(subset=['name', 'born'])

Example 3: remove row if all are the same value pandas

print (df['S'] != df['T'])
0    False
1     True
2     True
3     True
4    False
5     True
6     True
7     True
8    False
dtype: bool

df = df[df['S'] != df['T']]
print (df)
   S  T  W           U
1  A  B  0  Undirected
2  A  C  1  Undirected
3  B  A  0  Undirected
5  B  C  1  Undirected
6  C  A  1  Undirected
7  C  B  1  Undirected

Example 4: select only some rows pandas

df.loc[df['column_name'].isin(some_values)]