Convert dataframe index to datetime

by

It should work as expected. Try to run the following example.

import pandas as pd
import io

data = """value          
"2015-09-25 00:46"    71.925000
"2015-09-25 00:47"    71.625000
"2015-09-25 00:48"    71.333333
"2015-09-25 00:49"    64.571429
"2015-09-25 00:50"    72.285714"""

df = pd.read_table(io.StringIO(data), delim_whitespace=True)

# Converting the index as date
df.index = pd.to_datetime(df.index)

# Extracting hour & minute
df['A'] = df.index.hour
df['B'] = df.index.minute
df

#                          value  A   B
# 2015-09-25 00:46:00  71.925000  0  46
# 2015-09-25 00:47:00  71.625000  0  47
# 2015-09-25 00:48:00  71.333333  0  48
# 2015-09-25 00:49:00  64.571429  0  49
# 2015-09-25 00:50:00  72.285714  0  50

More Related Contents:

  1. Filtering Pandas DataFrames on dates
  2. Keep only date part when using pandas.to_datetime
  3. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  4. How to print pandas DataFrame without index
  5. Convert Excel style date with pandas
  6. datetime dtypes in pandas read_csv
  7. How to convert string to datetime format in pandas python?
  8. pandas dataframe groupby datetime month
  9. Find the end of the month of a Pandas DataFrame Series
  10. Create a day-of-week column in a Pandas dataframe using Python
  11. Pandas: Subtracting two date columns and the result being an integer
  12. How to change the datetime tick label frequency for matplotlib plots
  13. Converting between datetime and Pandas Timestamp objects
  14. Splitting timestamp column into separate date and time columns
  15. Pandas: Datetime Improperly selecting day as month from date [duplicate]
  16. Pandas converting row with unix timestamp (in milliseconds) to datetime
  17. Python pandas convert datetime to timestamp effectively through dt accessor
  18. Specifying date format when converting with pandas.to_datetime
  19. Which is the fastest way to extract day, month and year from a given date?
  20. Locate first and last non NaN values in a Pandas DataFrame
  21. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  22. Datetime conversion – How to extract the inferred format?
  23. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  24. What values are valid in Pandas ‘Freq’ tags?
  25. Clean way to convert quarterly periods to datetime in pandas
  26. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  27. Convert dates to pd.to_datetime where month could be either a number or month name
  28. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  29. Pandas: groupby forward fill with datetime index
  30. Pandas: select all dates with specific month and day

Leave a Comment