/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

1 vote186 views4 answers
Get python script path
Python
0 vote166 views1 answer
Erreude code Can't open /dev/mem: Permission denied Traceback (most recent call last):
Python
0 vote175 views1 answer
Pyfiglet not coming up
Python
3 votes132 views1 answer
Null coalescing assignment operators python
Python
0 vote170 views1 answer
How to print a matrix in python
Python
3 votes188 views2 answers
Python remove all occurrence of an items from list
Python
5 votes196 views2 answers
Conda install spacy
Python
35 votes178 views6 answers
Create pandas dataframe from dictionary
Python
0 vote180 views1 answer
Pandas check if column is sorted
Python
8 votes167 views2 answers
Python float print 2 digits
Python