/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

4 votes141 views1 answer
Render audio content without page view in flask
Python Flask
5 votes111 views2 answers
Check if dataframe contains infinity
Python
5 votes108 views3 answers
Python is not
Python
0 vote117 views1 answer
Os file size python
Python
2 votes63 views1 answer
Python how to retain newlines
Python
7 votes64 views1 answer
Dataframe count null values
Python
11 votes112 views1 answer
Ndarray to pil image
Python
0 vote100 views1 answer
New paragraph python
Python
0 vote112 views1 answer
Sphinx, where to write the glossary of a sofware project
Python
1 vote117 views1 answer
The user to enter their name and display each letter in their name on a separate line python
Python