Answers for "pandas subset where column is null"

3

check if any value is null in pandas dataframe

df.isnull().values.any()
Posted by: Guest on July-23-2020
0

get first not null value from column dataframe

s = pd.Series([np.nan,2,np.nan])
print (s)
0    NaN
1    2.0
2    NaN
dtype: float64

print (s.first_valid_index())
1

print (s.loc[s.first_valid_index()])
2.0

# If your Series contains ALL NaNs, you'll need to check as follows:

s = pd.Series([np.nan, np.nan, np.nan])
idx = s.first_valid_index()  # Will return None
first_valid_value = s.loc[idx] if idx is not None else None
print(first_valid_value)
None
Posted by: Guest on August-09-2021

Code answers related to "pandas subset where column is null"

Python Answers by Framework

Browse Popular Code Answers by Language