/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

2 votes135 views2 answers
Fibonacci sequence python 2.7
Python
1 vote178 views1 answer
Python reload lib jupyter notebook %reload
Python
3 votes199 views1 answer
Django user group check
Python Django
1 vote141 views1 answer
Python - count values that contain special characters
Python
1.2K votes328 views10 answers
Twitch
Python
1 vote128 views1 answer
Learningrate scheduler tensorflow
Python
0 vote136 views1 answer
Python terminate program after specific time
Python
3 votes141 views2 answers
Return df.iloc[1:]
Python
10 votes136 views2 answers
Merge 2 dataframes in python
Python
44 votes144 views3 answers
Python bytes to string
Python