Pandas – convert strings to time without date

by

After performing the conversion you can use the datetime accessor dt to access just the hour or time component:

In [51]:

df['hour'] = pd.to_datetime(df['time'], format="%H:%M").dt.hour
df
Out[51]:
        time  hour
index             
1      10:53    10
2      12:17    12
3      14:46    14
4      16:36    16
5      18:39    18
6      20:31    20
7      22:28    22

Also your format string H%:M% is malformed, it’s likely to raise a ValueError: ':' is a bad directive in format 'H%:M%'

Regarding your last comment the dtype is datetime.time not datetime:

In [53]:
df['time'].iloc[0]

Out[53]:
datetime.time(10, 53)

More Related Contents:

  1. Split / Explode a column of dictionaries into separate columns with pandas
  2. How to split a dataframe string column into two columns?
  3. Annotate bars with values on Pandas bar plots
  4. Comparing two dataframes and getting the differences [duplicate]
  5. plot different color for different categorical levels using matplotlib
  6. Counting consecutive positive values in Python/pandas array
  7. Pandas GroupBy and select rows with the minimum value in a specific column
  8. Parallelize apply after pandas groupby
  9. Python Pandas Group by date using datetime data
  10. Populate a Pandas SparseDataFrame from a SciPy Sparse Matrix
  11. ValueError: Wrong number of items passed – Meaning and suggestions?
  12. How to suppress Pandas Future warning ?
  13. pandas style background gradient both rows and columns
  14. Convert list into a pandas data frame
  15. Convert pandas data frame to series
  16. Pandas DataFrame merge summing column
  17. Mapping ranges of values in pandas dataframe [duplicate]
  18. Pandas can’t read hdf5 file created with h5py
  19. Plotting a stacked Bar Chart
  20. Get first row value of a given column
  21. ValueError: view limit minimum -35738.3640567 is less than 1 and is an invalid Matplotlib date value
  22. Convert month int to month name in Pandas
  23. Pandas Passing Variable Names into Column Name
  24. How to plot percentage with seaborn distplot / histplot / displot
  25. Python pandas integer YYYYMMDD to datetime
  26. MemoryError when I merge two Pandas data frames
  27. How to unpack a Series of tuples in Pandas?
  28. pandas to_sql all columns as nvarchar
  29. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?
  30. How to GroupBy a Dataframe in Pandas and keep Columns

Leave a Comment