isnull
and notnull
work with NaT
so you can handle them much the same way you handle NaNs
:
>>> df
a b c
0 1 NaT w
1 2 2014-02-01 g
2 3 NaT x
>>> df.dtypes
a int64
b datetime64[ns]
c object
just use isnull
to select:
df[df.b.isnull()]
a b c
0 1 NaT w
2 3 NaT x
Related Contents:
- Create a Pandas Dataframe by appending one row at a time
- Combine two columns of text in pandas dataframe
- How do I count the NaN values in a column in pandas DataFrame?
- Import multiple csv files into pandas and concatenate into one DataFrame
- How to apply a function to two columns of Pandas dataframe
- UnicodeDecodeError when reading CSV file in Pandas with Python
- how to sort pandas dataframe from one column
- How to reset index in a pandas dataframe? [duplicate]
- Pandas index column title or name
- Get column index from column name in python pandas
- How to take column-slices of dataframe in pandas
- Find row where values for column is maximal in a pandas DataFrame
- Logical operators for Boolean indexing in Pandas
- Add x and y labels to a pandas plot
- Pandas dataframe get first row of each group
- Pandas dataframe fillna() only some columns in place
- How do I retrieve the number of columns in a Pandas data frame?
- getting the index of a row in a pandas apply function
- Extract column value based on another column in Pandas
- How to access pandas groupby dataframe by key
- Drop columns whose name contains a specific string from pandas DataFrame
- Get total of Pandas column
- How to get the first column of a pandas DataFrame as a Series?
- Making heatmap from pandas DataFrame
- selecting from multi-index pandas
- Forcing pandas .iloc to return a single-row dataframe?
- pandas groupby without turning grouped by column into index
- pandas .at versus .loc
- How to open and convert sqlite database to pandas dataframe
- Pandas get the most frequent values of a column
- Elegant way to create empty pandas DataFrame with NaN of type float
- Select only one index of multiindex DataFrame
- Trouble passing in lambda to apply for pandas DataFrame
- How do I get the name of the rows from the index of a data frame?
- How to join two dataframes for which column values are within a certain range?
- Remove NaN/NULL columns in a Pandas dataframe?
- Conditionally fill column values based on another columns value in pandas
- Set value on an entire column of a pandas dataframe
- TypeError: first argument must be an iterable of pandas objects, you passed an object of type “DataFrame”
- Python Pandas update a dataframe value from another dataframe
- Sorting by absolute value without changing the data
- Python Pandas iterate over rows and access column names
- Ranking order per group in Pandas
- How to insert a pandas dataframe to an already existing table in a database?
- Python pandas: how to remove nan and -inf values
- Remove first x number of characters from each row in a column of a Python dataframe
- Reset a column’s MultiIndex levels
- assigning column names to a pandas series
- Convert Pandas Series to DateTime in a DataFrame
- how to reset index pandas dataframe after dropna() pandas dataframe