/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

39 votes197 views6 answers
Random list python
Python
15 votes195 views2 answers
Python check if variable is string
Python
0 vote189 views2 answers
How to query DNS records using python
Python
0 vote259 views1 answer
Remove hh:mm:ss from pandas dataframe column
Python
0 vote198 views1 answer
A function to create a null matrix in python
Python
39 votes188 views2 answers
Create text in python if not exists
Python
15 votes1.8K views2 answers
Python try else
Python
0 vote205 views1 answer
Add authorization header in python requests
Python
0 vote206 views1 answer
Run git pull from python script
Python
0 vote257 views1 answer
Nested list flask
Python