Python/Pandas convert string to time only

by

These two lines:

dfc['Time_of_Sail'] = pd.to_datetime(dfc['Time_of_Sail'])
dfc['Time_of_Sail'] = [time.time() for time in dfc['Time_of_Sail']]

Can be written as: 

dfc['Time_of_Sail'] = pd.to_datetime(dfc['Time_of_Sail'],format="%H:%M:%S" ).dt.time

More Related Contents:

  1. How to join two dataframes for which column values are within a certain range?
  2. Filtering Pandas DataFrames on dates
  3. How to print pandas DataFrame without index
  4. datetime dtypes in pandas read_csv
  5. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  6. Python Pandas Group by date using datetime data
  7. Removing the timestamp from a datetime in pandas dataframe
  8. Pandas filter dataframe rows with a specific year
  9. Convert Pandas Series to DateTime in a DataFrame
  10. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  11. Python pandas integer YYYYMMDD to datetime
  12. Group DataFrame in 5-minute intervals
  13. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  14. What values are valid in Pandas ‘Freq’ tags?
  15. Python: Adding hours to pandas timestamp
  16. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  17. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  18. Get weekday/day-of-week for Datetime column of DataFrame
  19. Plot pandas dates in matplotlib
  20. How to identify and label similar rows in a pandas data frame
  21. Renaming column names in Pandas
  22. How can I use the apply() function for a single column?
  23. Pandas select rows and columns based on boolean condition
  24. How to flatten a hierarchical index in columns
  25. AttributeError: ‘DataFrame’ object has no attribute ‘ix’
  26. Writing large Pandas Dataframes to CSV file in chunks
  27. How to merge a Series and DataFrame
  28. Pretty print a pandas dataframe in VS Code
  29. Transpose the data in a column every nth rows in PANDAS
  30. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?

Leave a Comment