/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 vote129 views1 answer
Optimize images using pillow
Python
0 vote127 views1 answer
Text files to words generator
Python
1 vote168 views1 answer
Log base 2 python
Python
3 votes281 views2 answers
List images in directory python
Python
0 vote141 views4 answers
Randome Word generator from consonant, vowel and specific string
Python
0 vote137 views1 answer
Highlighting the shortest path in a Networkx graph
Python
0 vote140 views2 answers
Python list to string with spaces
Python
0 vote135 views1 answer
All classification algorithim compare
Python
1 vote138 views1 answer
Get number of key in dictionary python
Python
0 vote132 views1 answer
How to find determinant in numpy
Python