/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

0 vote348 views1 answer
Python how to add a string to a list in the begining
Python
0 vote362 views1 answer
Python count lines in string
Python
0 vote339 views2 answers
Loop through list of tuples python
Python
0 vote346 views1 answer
Use nltk to remove stop words
Python
0 vote315 views2 answers
Crontab python script
Python
0 vote352 views1 answer
Git ignore everything but python files
Python
0 vote337 views1 answer
Python - How To Check if a String Contains Word
Python
4 votes332 views2 answers
Code server
Python
0 vote349 views1 answer
Vim run python current file
Python
0 vote363 views1 answer
How to find number of categories in python
Python