/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

2 votes141 views1 answer
Variable in regex python
Python
0 vote162 views1 answer
How to make a nice login django form
Python Django
1 vote161 views1 answer
How to get sum specific columns value in machine learning
Python
1 vote160 views1 answer
How do you create a countdown using turtle python
Python
2 votes142 views1 answer
Django template capitalize equivalent
Python
0 vote148 views1 answer
Columns overlap but no suffix specified: Index(['zpid'], dtype='object')
Python
2 votes164 views2 answers
Numpy print full array to srdout
Python
0 vote141 views1 answer
A string varible in python
Python
0 vote148 views1 answer
Python wifi moudel [WinError 2] The system cannot find the file specified
Python
1 vote171 views1 answer
Pandas row where value in list
Python