/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

1 vote325 views2 answers
Plt.scatter background color
Python
-1 vote311 views2 answers
From html to jupyter notebook
Python
2 votes296 views2 answers
Python PyQt5
Python
16 votes342 views5 answers
Logistic regression python
Python
0 vote361 views1 answer
Check for duplicate values in dataframe
Python
0 vote315 views1 answer
Numpy sort row by
Python
0 vote319 views2 answers
Pandas split tuple column
Python
0 vote294 views1 answer
Find charechtar index in string python
Python
0 vote290 views1 answer
How to check if column has na python
Python
0 vote317 views2 answers
Detect if usb is plugged in python
Python