I got some help from a colleague.
This appears to solve the problem posted above
pd.to_datetime(df['mydates']).apply(lambda x: x.date())
More Related Contents:
- Convert Excel style date with pandas
- Find the end of the month of a Pandas DataFrame Series
- Splitting timestamp column into separate date and time columns
- Which is the fastest way to extract day, month and year from a given date?
- Clean way to convert quarterly periods to datetime in pandas
- How to combine year, month, and day columns to single datetime column?
- Convert dates to pd.to_datetime where month could be either a number or month name
- Filtering Pandas DataFrames on dates
- Keep only date part when using pandas.to_datetime
- How to print pandas DataFrame without index
- How to convert string to datetime format in pandas python?
- pandas dataframe groupby datetime month
- How to format date string via multiple formats in python
- Add months to a date in Pandas
- Pandas: Subtracting two date columns and the result being an integer
- Python Pandas: Group datetime column into hour and minute aggregations
- How to change the datetime tick label frequency for matplotlib plots
- Matplotlib DateFormatter for axis label not working
- Extract day of year and Julian day from a string date
- Comparing two date strings in Python
- Get week start date (Monday) from a date column in Python (pandas)?
- group by week in pandas
- Python pandas convert datetime to timestamp effectively through dt accessor
- In Pandas how do I convert a string of date strings to datetime objects and put them in a DataFrame?
- Locate first and last non NaN values in a Pandas DataFrame
- pd.to_datetime is getting half my dates with flipped day / months
- Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
- What values are valid in Pandas ‘Freq’ tags?
- Pandas: groupby forward fill with datetime index
- Pandas: select all dates with specific month and day