/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

5 votes188 views4 answers
While true loop python
Python
0 vote188 views2 answers
Django form formatting
Python Django
0 vote184 views1 answer
Export high resolution .png matplotlib
Python
0 vote150 views1 answer
Remove tab space from string in python
Python
-1 vote158 views1 answer
Save a file as a pickle
Python
0 vote151 views1 answer
Heatmap choos format for annotation
Python
2 votes156 views1 answer
Tkinter info box
Python
4 votes195 views4 answers
Use python3 as default mac
Python
0 vote161 views1 answer
Python create local list
Python
4 votes201 views2 answers
Python press any key to continue
Python