Parse a Pandas column to Datetime when importing table from SQL database and filtering rows by date

by

Pandas is aware of the object datetime but when you use some of the import functions it is taken as a string. So what you need to do is make sure the column is set as the datetime type not as a string. Then you can make your query. 

df['date']  = pd.to_datetime(df['date'])
df_masked = df[(df['date'] > datetime.date(2012,4,1)) & (df['date'] < datetime.date(2012,4,4))]

More Related Contents:

  1. How to map numeric data into categories / bins in Pandas dataframe
  2. Convert timedelta64[ns] column to seconds in Python Pandas DataFrame
  3. ImportError: cannot import name NUMPY_MKL
  4. Most efficient way to sort an array into bins specified by an index array?
  5. Populate a Pandas SparseDataFrame from a SciPy Sparse Matrix
  6. Improve Row Append Performance On Pandas DataFrames
  7. Python Pandas: remove entries based on the number of occurrences
  8. Convert Pandas dataframe to Sparse Numpy Matrix directly
  9. Python returns "SyntaxError: invalid syntax sys module" [closed]
  10. How to write to an existing excel file without overwriting data (using pandas)?
  11. How can I split a column of tuples in a Pandas dataframe?
  12. Import Error: No module named numpy
  13. Group duplicate column IDs in pandas dataframe
  14. calling dot products and linear algebra operations in Cython?
  15. Numpy: Fix array with rows of different lengths by filling the empty elements with zeros
  16. Suppressing scientific notation in pandas? [duplicate]
  17. How to one hot encode variant length features?
  18. How to add a new row to an empty numpy array
  19. pandas equivalent of np.where
  20. how to read certain columns from Excel using Pandas – Python
  21. which is faster for load: pickle or hdf5 in python
  22. Saving Matplotlib graphs to image as full screen
  23. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  24. How to calculate cumulative normal distribution?
  25. Concatenate sparse matrices in Python using SciPy/Numpy
  26. Filling in date gaps in MultiIndex Pandas Dataframe
  27. I want to multiply two columns in a pandas DataFrame and add the result into a new column
  28. Fitting a Weibull distribution using Scipy
  29. How to do a polynomial fit with fixed points
  30. Getting days since last occurence in Pandas DataFrame?

Leave a Comment