/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

22 votes149 views6 answers
Python numpy array to list
Python
10 votes218 views6 answers
How to show a progress bar in python
Python
0 vote150 views1 answer
How to get the number in the tenths place of a integer in python
Python
0 vote131 views1 answer
Run ipython inside pipenv
Python
2 votes163 views1 answer
How to make convert numpy array to string in python
Python
0 vote135 views1 answer
Check if path is a folder python
Python
0 vote162 views1 answer
Static instance and local variables in python
Python
1 vote155 views1 answer
Django filter by date range
Python
2 votes149 views1 answer
How to change background color in python turtle
Python
1 vote146 views2 answers
Cool python imports
Python