Remove time portion of DateTime index in pandas

by

With the date attribute:

df.index = df.index.date

Example:

>>> df = pd.DataFrame([1, 2, 3, 4], index=pd.date_range('2018', periods=4, freq='H'))
>>> df.index = df.index.date
>>> df
            0
2018-01-01  1
2018-01-01  2
2018-01-01  3
2018-01-01  4

Note: that this will get you object dtype in Pandas. All attributes are here. It’s technically an array of native Python datetime.date objects. See ALollz’s answer to keep the dtype datetime-like.

More Related Contents:

  1. Select nan column in pandas
  2. How to identify and label similar rows in a pandas data frame
  3. How do I read a large csv file with pandas?
  4. How can I use the apply() function for a single column?
  5. Pandas filtering for multiple substrings in series
  6. Remove duplicates by columns A, keeping the row with the highest value in column B
  7. How can I display full (non-truncated) dataframe information in HTML when converting from Pandas dataframe to HTML?
  8. Pandas: conditional rolling count
  9. pandas: to_numeric for multiple columns
  10. group by pandas dataframe and select latest in each group
  11. Selection with .loc in python
  12. Access to table objects on Webpage Using Python Selenium
  13. How to flatten a hierarchical index in columns
  14. Most efficient way to sort an array into bins specified by an index array?
  15. splitting at underscore in python and storing the first value
  16. UnicodeDecodeError: (‘utf-8’ codec) while reading a csv file [duplicate]
  17. Transform vs. aggregate in Pandas
  18. Background with range on seaborn based on two columns
  19. Pandas: Shift down values by one row within a group
  20. Pandas max value index
  21. Opposite of melt in python pandas
  22. Pandas read_csv dtype leading zeros
  23. pandas.read_csv from string or package data
  24. Adding image to pandas DataFrame
  25. Get first letter of a string from column
  26. dask dataframe how to convert column to to_datetime
  27. Read a zipped file as a pandas DataFrame
  28. Pandas df.to_csv(“file.csv” encode=”utf-8″) still gives trash characters for minus sign
  29. Output data from all columns in a dataframe in pandas [duplicate]
  30. Good alternative to Pandas .append() method, now that it is being deprecated?

Leave a Comment