/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

14 votes108 views6 answers
Binary search in python
Python
0 vote126 views1 answer
Pandas ta quick start example
Python
4 votes137 views1 answer
Any python
Python
17 votes72 views1 answer
Merge 4 dataframes pandas
Python
0 vote127 views1 answer
How to modify name of email from divi
Python
1 vote120 views2 answers
How to access cookies in django
Python
7 votes108 views3 answers
Python print exception type and message
Python
28 votes113 views6 answers
Flatten list python
Python
6 votes118 views5 answers
Mean python
Python
-1 vote107 views1 answer
Python input().strip()
Python