/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

0 vote232 views1 answer
Matplotlib add text to axes
Python
34 votes221 views5 answers
How to install tkinter
Python
76 votes221 views6 answers
Select a random element from a list python
Python
7 votes217 views2 answers
Mongodb aggregate group
Python
0 vote262 views1 answer
Then generate Django project from the project template of cookiecutter
Python Django
0 vote237 views1 answer
Ensure string length 2 python
Python
0 vote234 views1 answer
Find the 15th term of the series?0,0,7,6,14,12,21,18, 28
Python
34 votes247 views6 answers
Pip install from jupyter notebook
Python
-1 vote288 views3 answers
Numpy savetext
Python
0 vote222 views1 answer
Python generate sine wave pyaudio
Python