pandas filtering and comparing dates

by

I would do a mask like:

a = df[df['newest_date_available'] < date_before]

If date_before = datetime.date(2016, 1, 19), this returns:

        id  code newest_date_available
0  9793708  3514            2015-12-24
1  9792282  2399            2015-12-25
2  9797602  7452            2015-12-25

More Related Contents:

  1. change column name in pandas, which will be used to change name for 1 column
  2. How do I select rows from a DataFrame based on column values?
  3. Pandas read in table without headers
  4. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  5. Can pandas automatically read dates from a CSV file?
  6. Pandas cannot open an Excel (.xlsx) file
  7. Python Pandas: Check if string in one column is contained in string of another column in the same row
  8. First non-null value per row from a list of Pandas columns
  9. Pandas: Filtering multiple conditions
  10. How to determine the length of lists in a pandas dataframe column
  11. Pandas fill missing values in dataframe from another dataframe
  12. Filter a pandas dataframe using values from a dict
  13. Fastest way to populate QTableView from Pandas data frame
  14. Get data from pandas into a SQL server with PYODBC
  15. Pivoting a Pandas Dataframe containing strings – ‘No numeric types to aggregate’ error
  16. how do I calculate a rolling idxmax
  17. binning a dataframe in pandas in Python [duplicate]
  18. What is the difference between pandas agg and apply function?
  19. Pandas: Return Hour from Datetime Column Directly
  20. Pandas: combining header rows of a multiIndex DataFrame
  21. pandas groupby and join lists
  22. Selecting pandas column by location
  23. Row-wise average for a subset of columns with missing values
  24. Plot multiple columns of pandas DataFrame using Seaborn
  25. Pandas: Creating aggregated column in DataFrame
  26. Pandas combining rows based on dates
  27. Collapsing rows in a Pandas dataframe if all rows have only one value in their columns
  28. Preserving column order in Python Pandas DataFrame
  29. start index at 1 for Pandas DataFrame
  30. Multi Index Sorting in Pandas

Leave a Comment