Python datetime Time Processing

Source: Internet
Author: User
Tags month name string format

Time data is read in string format, converted to datetime format

data['time1'= pd.to_datetime (data['time1'],format="  %h:%m:%s:%f")

Calculate the time difference:

data['time_interval']=pd.to_datetime (data['time2')- Pd.to_datetime (data['time1')

Result: Unit or millisecond

To convert it further into seconds

Supplemental Learning:

Python Time Strptime () methodDescribe

The Python time strptime () function resolves a timing string to a time tuple based on the specified format.

Grammar

Strptime () method syntax:

Time.  Strptime(string[, format])      
Parameters
    • String--time string.
    • Format--a formatted string.
return value

Returns the Struct_time object.

Description

Python format symbols in time Date:

    • %y Two-digit year representation (00-99)
    • %Y Four-digit year representation (000-9999)
    • %m Month (01-12)
    • One day in%d months (0-31)
    • %H 24-hour hours (0-23)
    • %I 12-hour hours (01-12)
    • %M minutes (00=59)
    • %s seconds (00-59)
    • %a Local Simplified Week name
    • %A Local Full week name
    • %b a locally simplified month name
    • %B Local Full month name
    • %c Local corresponding date representation and time representation
    • %j Day of the Year (001-366)
    • %p the equivalent of a local a.m. or p.m.
    • %u weeks of the year (00-53) Sunday is the beginning of the week
    • %w Week (0-6), Sunday for the beginning of the week
    • %W Week of the Year (00-53) Monday is the beginning of the week
    • %x Local corresponding date representation
    • %x Local corresponding time representation
    • %Z the name of the current time zone
    • Percent% of the number itself
Instance

The following example shows how the Strptime () function is used:

Instance (Python 2.0+)< Span class= "Hl-code" > struct _time = time. Strptime ( "30 Nov 00 "" %d%b%y ")  

Python datetime Time Processing

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.