/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

13 votes133 views1 answer
Check strings last letter python
Python
2 votes178 views2 answers
Csv manipulation python
Python
0 vote141 views1 answer
Swap two columns python
Python
0 vote139 views1 answer
Selenium how to handle element not found python
Python
0 vote146 views2 answers
Write a program to check whether a character is vowel or consonant in python
Python
0 vote146 views1 answer
Python random real
Python
0 vote147 views1 answer
Performance of extend vs append loop
Python
4 votes136 views2 answers
Print format python
Python
3 votes143 views1 answer
Python array delete last column
Python
0 vote180 views1 answer
Fromhex python 2.7
Python