Convert a column of timestamps into periods in pandas

by

I came across this thread today, and after further digging found that Pandas .15 affords an easier option use .dt, you can avoid the step of creating an index and create the column directly. You can use the following to get the same result:

df[1] = df[0].dt.to_period('M')

More Related Contents:

  1. Converting between datetime, Timestamp and datetime64
  2. Pandas: Subtracting two date columns and the result being an integer
  3. Pandas: How to create a datetime object from Week and Year?
  4. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  5. Binning a column with Python Pandas
  6. Convert DataFrame column type from string to datetime
  7. Pandas Dataframe line plot display date on xaxis
  8. Best way to join / merge by range in pandas
  9. float64 with pandas to_csv
  10. Recursive definitions in Pandas
  11. How do I round datetime column to nearest quarter hour
  12. Pandas filter dataframe rows with a specific year
  13. how do I calculate a rolling idxmax
  14. binning a dataframe in pandas in Python [duplicate]
  15. Pandas: Return Hour from Datetime Column Directly
  16. pandas .plot() x-axis tick frequency — how can I show more ticks?
  17. Leave dates as strings using read_excel function from pandas in python
  18. Combine Date and Time columns using pandas
  19. Converting time zone pandas dataframe
  20. Using datetime as ticks in Matplotlib
  21. Plot the x-axis as a date
  22. Pandas parse non-english string dates
  23. Store numpy.array in cells of a Pandas.DataFrame
  24. Python pandas: how to remove nan and -inf values
  25. Filtering pandas dataframe with multiple Boolean columns
  26. Parse a Pandas column to Datetime when importing table from SQL database and filtering rows by date
  27. A faster alternative to Pandas `isin` function
  28. Why is NaN considered as a float?
  29. Clean way to convert quarterly periods to datetime in pandas
  30. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

Leave a Comment