/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

5 votes188 views3 answers
How to coppy a file in python
Python
0 vote174 views1 answer
Pandas describe get mean min max
Python
-1 vote208 views1 answer
Find the area of a circle in python
Python
-1 vote185 views1 answer
Group by data
Python
0 vote171 views1 answer
Robust scaler
Python
0 vote242 views1 answer
Df.sample(frac=1)
Python
16 votes186 views2 answers
Python to excel
Python
3 votes162 views3 answers
Hide turtle
Python
0 vote173 views1 answer
C++ vs python
Python
0 vote172 views1 answer
Remove newline and space characters from start and end of string python
Python