/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 vote241 views1 answer
Django collectstatic with auto yes
Python
0 vote233 views1 answer
Calculate pearson's r | calculate graph correlation
Python
8 votes247 views1 answer
Pandas series to list
Python
0 vote266 views1 answer
Python get item from list by index
Python
0 vote234 views1 answer
Urllib.error.HTTPError: HTTP Error 403: Forbidden
Python
27 votes229 views2 answers
What value do we get from NULL database python
Python
1 vote208 views3 answers
Char list to string python
Python
0 vote217 views1 answer
Python get the last element from the list
Python
2 votes226 views1 answer
Tensorflow math python
Python
5 votes245 views4 answers
How to input comma separated int values in python
Python