changing all dates to standard date time in dataframe

by

Referencing How to convert a given ordinal number (from Excel) to a date, convert the ordinal values to datetime using from_excel_ordinal –

m = df['Plan Start Date'].str.isdigit()

Or, if you have a column of objects – 

df['Plan Start Date'].astype(str).str.isdigit()

Next, apply the function on a subset of the rows using apply – 

df.loc[m, 'Plan Start Date'] = \
df.loc[m, 'Plan Start Date']\
  .astype(int)\
  .apply(from_excel_ordinal)

Finally, convert the entire column to datetime using pd.to_datetime, giving a uniform result – 

df['Plan Start Date'] = pd.to_datetime(df['Plan Start Date'], errors="coerce")


df

   Plan Start Date
0       2017-08-16
1       2017-05-31
2       2017-05-31
3       2017-05-31
4       2017-05-31
5       2016-04-21
6       2016-02-25
7       2016-12-15
8       2016-12-15
9       2016-12-15
10      2016-01-04
11      2016-01-04
12      2015-12-29
13      2015-12-29
14      2015-12-29
15      2015-12-29
16      2016-03-31
17      2016-03-31
18      2016-03-31
19      2016-03-31
20      2016-03-31
21      2017-01-24
22      2015-11-25

More Related Contents:

  1. Add missing dates to pandas dataframe
  2. Convert Excel style date with pandas
  3. Can pandas automatically read dates from a CSV file?
  4. Find the end of the month of a Pandas DataFrame Series
  5. Add months to a date in Pandas
  6. How do I convert strings in a Pandas data frame to a ‘date’ data type?
  7. python/pandas: convert month int to month name
  8. Python Pandas: Group datetime column into hour and minute aggregations
  9. Sort a pandas dataframe series by month name
  10. Matplotlib DateFormatter for axis label not working
  11. Splitting timestamp column into separate date and time columns
  12. Pandas – Number of Months Between Two Dates
  13. Get week start date (Monday) from a date column in Python (pandas)?
  14. Pandas Merge on Name and Closest Date
  15. group by week in pandas
  16. Convert month int to month name in Pandas
  17. Which is the fastest way to extract day, month and year from a given date?
  18. Extracting dates that are in different formats using regex and sorting them – pandas
  19. Getting days since last occurence in Pandas DataFrame?
  20. Resample time series in pandas to a weekly interval
  21. Clean way to convert quarterly periods to datetime in pandas
  22. How to combine year, month, and day columns to single datetime column?
  23. How do I convert timestamp to datetime.date in pandas dataframe?
  24. Convert dates to pd.to_datetime where month could be either a number or month name
  25. Split / Explode a column of dictionaries into separate columns with pandas
  26. plot different color for different categorical levels using matplotlib
  27. Counting consecutive positive values in Python/pandas array
  28. Pandas Dataframe: Replacing NaN with row average
  29. Plotting a stacked Bar Chart
  30. Drop row in pandas dataframe if any value in the row equals zero

Leave a Comment