/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 vote174 views3 answers
Unsplash source
Python
10 votes160 views1 answer
Create dataframe with column names pandas
Python
0 vote165 views1 answer
Keras functional api embedding layer
Python
13 votes208 views2 answers
How to flip a list backwards in python
Python
9 votes164 views2 answers
Pandas to convert null values to mean in numeric column
Python
5 votes175 views1 answer
Python convert remove spaces from beginning of string
Python
1 vote207 views1 answer
An array of dates python
Python
0 vote164 views1 answer
Change python from 3.8 to 3.7
Python
0 vote190 views1 answer
How to find in which directory my python code is running
Python
0 vote172 views2 answers
How to make a bill in python
Python