/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

-1 vote164 views2 answers
How to apply lower string dataframe python
Python
0 vote197 views2 answers
Get random vowel python
Python
3 votes201 views2 answers
Python list copy
Python
0 vote208 views1 answer
Django.core.exceptions.ImproperlyConfigured: Field name is not valid for model
Python Django
25 votes168 views6 answers
Uninstall all packages python
Python
0 vote173 views1 answer
Pandas isolate data lower than a certain percentage
Python
1 vote144 views1 answer
For loop counting down python
Python
1 vote122 views1 answer
Nan in python what?
Python
7 votes273 views3 answers
Decode base64 password python
Python
9 votes210 views3 answers
Multiline input in python
Python