/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 vote149 views1 answer
Extract all capital words dataframe
Python
2 votes175 views1 answer
Django mysql
Python Django
0 vote151 views1 answer
Configuring tailwindcss, vue and laravel
Python
3 votes152 views2 answers
How to delete a turtle in python
Python
22 votes164 views6 answers
Python how to add to a list
Python
0 vote138 views1 answer
Python datetime subtract seconds
Python
0 vote156 views1 answer
How to set a timer in while loop python
Python
0 vote157 views1 answer
Install open3d jetson nano aarch64
Python
0 vote148 views1 answer
Django reverse accessor clashes for abstract class
Python
13 votes140 views1 answer
What is a slug
Python