/Python/Get first not null value from column dataframe

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

Source: stackoverflow.com

Similar codes

0 vote258 views1 answer
Str remove except alphabets
Python
0 vote160 views1 answer
Pandas select only earliest event for duplicates
Python
1 vote166 views1 answer
How to take input complex number in python
Python
1 vote169 views1 answer
Python find string in list
Python
0 vote184 views1 answer
Selenium assert text on page python
Python
-1 vote171 views1 answer
Armstrong number function
Python
0 vote164 views1 answer
Convert list to dataset python
Python
6 votes134 views1 answer
Read from yaml file python
Python
1 vote176 views1 answer
Deleting an object in python
Python
3 votes164 views1 answer
Replace "-" for nan in dataframe
Python