/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 vote123 views1 answer
Dt.weekday_name
Python
0 vote126 views2 answers
Unpacking tuples in python
Python
3 votes119 views2 answers
How to find the path of a python module
Python
2 votes143 views1 answer
How to make custom buttons tkinter
Python
0 vote124 views1 answer
Pyspark reduce a list
Python
10 votes122 views3 answers
Image to text python
Python
0 vote119 views1 answer
Generate unique id from given string python
Python
-1 vote123 views1 answer
Randoomforest sklearn
Python
23 votes274 views6 answers
Flask getting started
Python Flask
0 vote120 views1 answer
Pythpn data tyoe
Python