/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 vote250 views1 answer
Sowpods python
Python
0 vote265 views1 answer
Django request.data example
Python
3 votes258 views1 answer
Rotate 2 dimensional list python
Python
-1 vote242 views2 answers
Jupyter matplotlib
Python
11 votes241 views2 answers
How to import a module in python
Python
0 vote247 views1 answer
Django models for existing database
Python
-1 vote274 views9 answers
Django for Beginners
Python Django
0 vote238 views1 answer
Python return statemet
Python
5 votes242 views3 answers
Python sys
Python
5 votes258 views1 answer
Shift elements in list python
Python