/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 votes181 views3 answers
Get last day of month python
Python
3 votes186 views1 answer
Python how to find the highest number in a dictionary
Python
1 vote203 views1 answer
Browser pop up yes no selenium python
Python
2 votes228 views1 answer
Run flask application in development mode stack overflow
Python Flask
14 votes191 views6 answers
If condition python
Python
0 vote222 views1 answer
Check for nat entries pandas
Python
2 votes192 views3 answers
Pandas decimal places
Python
0 vote197 views1 answer
Get time format python2 hours minutes seconds milliseconds
Python
4 votes186 views5 answers
Python code to print prime numbers
Python
0 vote194 views1 answer
Python apply function to dictionary values
Python