How to combine year, month, and day columns to single datetime column?

by

There is an easier way:

In [250]: df['Date']=pd.to_datetime(df[['year','month','day']])

In [251]: df
Out[251]:
    id      lat      lon  year  month  day       Date
0  381  53.3066 -0.54649  2004      1    2 2004-01-02
1  381  53.3066 -0.54649  2004      1    3 2004-01-03
2  381  53.3066 -0.54649  2004      1    4 2004-01-04

from docs:

Assembling a datetime from multiple columns of a DataFrame. The keys
can be common abbreviations like [year, month, day, minute,
second, ms, us, ns]) or plurals of the same

More Related Contents:

  1. Convert Excel style date with pandas
  2. Find the end of the month of a Pandas DataFrame Series
  3. Splitting timestamp column into separate date and time columns
  4. Python pandas convert datetime to timestamp effectively through dt accessor
  5. Which is the fastest way to extract day, month and year from a given date?
  6. Clean way to convert quarterly periods to datetime in pandas
  7. How do I convert timestamp to datetime.date in pandas dataframe?
  8. Convert dates to pd.to_datetime where month could be either a number or month name
  9. How to print a date in a regular format?
  10. Pandas Dataframe line plot display date on xaxis
  11. Adding days to a date in Python
  12. Can pandas automatically read dates from a CSV file?
  13. How to convert integer timestamp to Python datetime
  14. How to convert integer timestamp into a datetime
  15. In Python, how do you convert seconds since epoch to a `datetime` object?
  16. How to group a pandas dataframe by a defined time interval?
  17. How do I round datetime column to nearest quarter hour
  18. Pandas Merge on Name and Closest Date
  19. Python UTC datetime object’s ISO format doesn’t include Z (Zulu or Zero offset)
  20. Pandas: Return Hour from Datetime Column Directly
  21. pandas .plot() x-axis tick frequency — how can I show more ticks?
  22. Leave dates as strings using read_excel function from pandas in python
  23. Combine Date and Time columns using pandas
  24. Convert date to datetime in Python
  25. Converting time zone pandas dataframe
  26. Pandas parse non-english string dates
  27. filter pandas dataframe by time
  28. Average time for datetime list
  29. Pandas datetimes with different formats in the same column
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment