removing time from date&time variable in pandas?

by

Assuming all your datetime strings are in a similar format then just convert them to datetime using to_datetime and then call the dt.date attribute to get just the date portion:

In [37]:

df = pd.DataFrame({'date':['2015-02-21 12:08:51']})
df
Out[37]:
                  date
0  2015-02-21 12:08:51
In [39]:

df['date'] = pd.to_datetime(df['date']).dt.date
df
Out[39]:
         date
0  2015-02-21

EDIT

If you just want to change the display and not the dtype then you can call dt.normalize:

In[10]:
df['date'] = pd.to_datetime(df['date']).dt.normalize()
df

Out[10]: 
        date
0 2015-02-21

You can see that the dtype remains as datetime:

In[11]:
df.dtypes

Out[11]: 
date    datetime64[ns]
dtype: object

More Related Contents:

  1. change column name in pandas, which will be used to change name for 1 column
  2. How to save a new sheet in an existing excel file, using Pandas?
  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. pandas dataframe str.contains() AND operation
  8. How to determine the length of lists in a pandas dataframe column
  9. Pandas fill missing values in dataframe from another dataframe
  10. Filter a pandas dataframe using values from a dict
  11. What is the difference between a pandas Series and a single-column DataFrame?
  12. Get column index from column name in python pandas
  13. AttributeError: Can only use .dt accessor with datetimelike values
  14. removing newlines from messy strings in pandas dataframe cells?
  15. pandas: replace string with another string
  16. Selecting pandas column by location
  17. How to upsert pandas DataFrame to Microsoft SQL Server table?
  18. How to set the hue order in Seaborn plots
  19. Getting Google Spreadsheet CSV into A Pandas Dataframe
  20. Python Pandas merge only certain columns
  21. Pandas read_csv dtype read all columns but few as string
  22. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  23. Python: Datetime to season
  24. Merging two tables with millions of rows in Python
  25. How to set the xlim and ylim of a FacetGrid
  26. Problem in combining bar plot and line plot
  27. Get weekday/day-of-week for Datetime column of DataFrame
  28. Plot all pandas dataframe columns separately
  29. Python pandas equivalent for replace
  30. Pandas data frame to dictionary of lists

Leave a Comment