/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 vote184 views1 answer
Flask template split string
Python
2 votes171 views2 answers
Python obtain data from pandas dataframe without index name
Python
0 vote242 views1 answer
Extract text from span python
Python
20 votes198 views2 answers
Python list of paths
Python
0 vote162 views1 answer
Ppcm python
Python
1 vote161 views1 answer
Python load pandas from pickle
Python
3 votes168 views2 answers
Find location of max value in python list
Python
-1 vote189 views1 answer
Python port forwarding
Python
0 vote165 views1 answer
Install formio data python library
Python
25 votes186 views6 answers
Pip uninstall all packages
Python