在Pandas DataFrame中找到第一个和最后一个非NaN值 [英] Locate first and last non NaN values in a Pandas DataFrame

问题描述

我有一个Pandas DataFrame 按日期索引。有许多列，但是很多列只是部分时间序列的填充。我想找到第一个和最后一个值 - NaN 值的位置，以便我可以提取日期，并查看特定列的时间序列的时间长度

I have a Pandas DataFrame indexed by date. There a number of columns but many columns are only populated for part of the time series. I'd like to find where the first and last values non-NaN values are located so that I can extracts the dates and see how long the time series is for a particular column.

有人可以指出我正确的方向，我可以如何去做这样的事情吗？感谢提前。

Could somebody point me in the right direction as to how I could go about doing something like this? Thanks in advance.

推荐答案

@ behzad.nouri的解决方案完美地返回第一个和最后一个非 NaN值使用 Series.first_valid_index 和 Series.last_valid_index 。

@behzad.nouri's solution worked perfectly to return the first and last non-NaN values using Series.first_valid_index and Series.last_valid_index, respectively.

这篇关于在Pandas DataFrame中找到第一个和最后一个非NaN值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！