/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

4 votes327 views5 answers
Min max python
Python
0 vote348 views6 answers
Django wht post save signal not firing
Python Django
0 vote293 views1 answer
Accessing list inside dict python
Python
2 votes280 views1 answer
Timeout exception in selenium python
Python
1 vote270 views1 answer
Python sqlite dict
Python
10 votes275 views4 answers
How to print all items in a list python
Python
0 vote294 views1 answer
Line plotly with shaded area
Python
10 votes286 views4 answers
Dataframe column in list
Python
0 vote286 views2 answers
Meme command discord.py
Python
0 vote262 views1 answer
Python Program to Count the Occurrences of a Word in a Text File
Python