/Python/Convert all date columns using pd.datetime

Convert all date columns using pd.datetime

def lookup(s):
    """
    This is an extremely fast approach to datetime parsing.
    For large data, the same dates are often repeated. Rather than
    re-parse these, we store all unique dates, parse them, and
    use a lookup to convert all dates.
    """
    dates = {date:pd.to_datetime(date) for date in s.unique()}
    return s.apply(lambda v: dates[v])

to_datetime: 5799 ms
dateutil:    5162 ms
strptime:    1651 ms
manual:       242 ms
lookup:        32 ms

Source: stackoverflow.com

Similar codes

66 votes335 views6 answers
Wait function python
Python
0 vote344 views1 answer
Absolute value of int python
Python
0 vote313 views1 answer
Django generate openapi schema command line
Python
5 votes319 views1 answer
Python matplt
Python
2 votes331 views2 answers
Label encoding column pandas
Python
0 vote351 views1 answer
How to make a grid list in python
Python
2 votes330 views3 answers
Find the Runner-Up Score!
Python
1 vote331 views1 answer
Delete files with same extensions
Python
0 vote323 views1 answer
Update profile rasterio pyton
Python
11 votes487 views4 answers
Pytesseract.pytesseract.TesseractError: (2, 'Usage: pytesseract [-l lang] input_file')
Python