/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

123 votes131 views6 answers
Input python
Python
7 votes122 views1 answer
// meaning in python
Python
0 vote132 views1 answer
Regrid ntdcf file usig xarray
Python
0 vote174 views1 answer
Django filter word count greater than
Python Django
0 vote255 views1 answer
Django force download file
Python Django
0 vote125 views1 answer
Python string caps lock
Python
0 vote137 views1 answer
Sum of positive numbers in array with negative python
Python
41 votes128 views2 answers
Print backwards python
Python
0 vote121 views1 answer
My Skile
Python
4 votes125 views4 answers
How to change django admin text
Python