How to change the datetime format in Pandas

by

You can use dt.strftime if you need to convert datetime to other formats (but note that then dtype of column will be object (string)):

import pandas as pd

df = pd.DataFrame({'DOB': {0: '26/1/2016', 1: '26/1/2016'}})
print (df)
         DOB
0  26/1/2016 
1  26/1/2016

df['DOB'] = pd.to_datetime(df.DOB)
print (df)
         DOB
0 2016-01-26
1 2016-01-26

df['DOB1'] = df['DOB'].dt.strftime('%m/%d/%Y')
print (df)
         DOB        DOB1
0 2016-01-26  01/26/2016
1 2016-01-26  01/26/2016

More Related Contents:

  1. Format timedelta to string
  2. Fast punctuation removal with pandas
  3. Create Pandas DataFrame from a string
  4. Convert python datetime to epoch with strftime
  5. String concatenation of two pandas columns
  6. Keep only date part when using pandas.to_datetime
  7. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  8. datetime dtypes in pandas read_csv
  9. How to convert string to datetime format in pandas python?
  10. Convert columns to string in Pandas
  11. Find the end of the month of a Pandas DataFrame Series
  12. Get last “column” after .str.split() operation on column in pandas DataFrame
  13. Pandas: Subtracting two date columns and the result being an integer
  14. Splitting timestamp column into separate date and time columns
  15. Left justify string values in a pandas DataFrame
  16. Pandas: Datetime Improperly selecting day as month from date [duplicate]
  17. Filter string data based on its string length
  18. Pandas converting row with unix timestamp (in milliseconds) to datetime
  19. Python pandas convert datetime to timestamp effectively through dt accessor
  20. Which is the fastest way to extract day, month and year from a given date?
  21. Locate first and last non NaN values in a Pandas DataFrame
  22. FutureWarning: The default value of regex will change from True to False in a future version
  23. How to remove numbers from string terms in a pandas dataframe
  24. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  25. What values are valid in Pandas ‘Freq’ tags?
  26. Filtering pandas dataframe rows by contains str
  27. How do I convert timestamp to datetime.date in pandas dataframe?
  28. Convert dates to pd.to_datetime where month could be either a number or month name
  29. Plot pandas dates in matplotlib
  30. Pandas: select all dates with specific month and day

Leave a Comment