/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 vote312 views1 answer
Loc vs iloc pandas
Python
0 vote282 views1 answer
Print a string with spaces between characters python
Python
4 votes273 views1 answer
Declaring a numpy array with certain size
Python
0 vote293 views1 answer
Enumerate in django templte
Python
0 vote276 views1 answer
# /usr/bin/env python windows
Python
1 vote282 views1 answer
Add age categories pandas dataframe
Python
0 vote333 views1 answer
Save datetime day in seperate column
Python
0 vote284 views1 answer
> not supported between tuple and int
Python
4 votes272 views1 answer
Falsy python
Python
2 votes302 views3 answers
Selenium find element by link text python
Python