/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

17 votes338 views2 answers
Import "rest_framework.views" could not be resolved
Python
0 vote323 views1 answer
Python clean all .pyc
Python
0 vote304 views1 answer
Matlab filter in python
Python
1 vote314 views1 answer
Django get id of newly created object
Python
1 vote342 views1 answer
How to add special token to bert tokenizer
Python
0 vote337 views2 answers
Connect to mysql database jupyter
Python
0 vote347 views2 answers
Python open google
Python
1 vote309 views1 answer
Dictionaries to http data python
Python
0 vote339 views1 answer
Simple graph in matplotlib categorical variables
Python
0 vote338 views1 answer
Example of a simple function that takes in parameters in python
Python