/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 vote156 views1 answer
Screen size tkinter
Python
0 vote149 views1 answer
Create a dictionary from index and column pandas
Python
33 votes152 views6 answers
Merge dataframe
Python
0 vote157 views1 answer
Numpy histogram 0 to 100 percent
Python
0 vote151 views2 answers
Python convert long floats to usd
Python
1 vote150 views1 answer
Python copy file to new filename
Python
0 vote168 views1 answer
Python get array length
Python
6 votes159 views5 answers
Discord.py get channel object from id
Python
6 votes154 views1 answer
Check 32 or 64 bit python
Python
-1 vote153 views1 answer
Map numpy array
Python