Filtering Pandas DataFrames on dates

by

If date column is the index, then use .loc for label based indexing or .iloc for positional indexing.

For example:

df.loc['2014-01-01':'2014-02-01']

See details here http://pandas.pydata.org/pandas-docs/stable/dsintro.html#indexing-selection

If the column is not the index you have two choices:

  1. Make it the index (either temporarily or permanently if it’s time-series data)
  2. df[(df['date'] > '2013-01-01') & (df['date'] < '2013-02-01')]

See here for the general explanation

Note: .ix is deprecated.

More Related Contents:

  1. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  2. Logical operators for Boolean indexing in Pandas
  3. Detect and exclude outliers in a pandas DataFrame
  4. How to join two dataframes for which column values are within a certain range?
  5. How to print pandas DataFrame without index
  6. datetime dtypes in pandas read_csv
  7. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  8. Python Pandas Group by date using datetime data
  9. Removing the timestamp from a datetime in pandas dataframe
  10. Pandas filter dataframe rows with a specific year
  11. Python/Pandas convert string to time only
  12. Convert Pandas Series to DateTime in a DataFrame
  13. How do I filter a pandas DataFrame based on value counts?
  14. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  15. Python pandas integer YYYYMMDD to datetime
  16. Group DataFrame in 5-minute intervals
  17. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  18. What values are valid in Pandas ‘Freq’ tags?
  19. Python: Adding hours to pandas timestamp
  20. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  21. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  22. Get weekday/day-of-week for Datetime column of DataFrame
  23. Plot pandas dates in matplotlib
  24. Convert DataFrame column type from string to datetime
  25. How to convert an XML file to nice pandas dataframe?
  26. How to calculate mean values grouped on another column in Pandas
  27. Generating random dates within a given range in pandas
  28. Count occurrences of each of certain words in pandas dataframe
  29. Anti-Join Pandas
  30. Remove ends of string entries in pandas DataFrame column

Leave a Comment