Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

How can i use pandas datetools in python because it removed from newer version

def convert_time(s):
    h, m, s = map(int, s.split(':'))
    return pd.datetools.timedelta(hours=h, minutes=m, seconds=s)
data = pd.read_csv('marathon-data.csv',converters={'split':convert_time, 'final':convert_time})
data.head()
                If you use the solutions provided (pd.to_timedelta), you'll end up with another error related to conversion of the time delta to seconds (assuming you are following this example). Then the solution is to adjust again the code: data['split_sec'] = data['split'].dt.total_seconds(). You should accept the current answer if it helped.
– mins
                Jan 9, 2021 at 13:51
                more explicitly: pd.read_csv('marathon-data.csv', converters={'split':pd.to_timedelta, 'final':pd.to_timedelta}. Note that split is not the string method used in the original custom function, split and final are the names of columns which need to be converted.
– mins
                Jan 9, 2021 at 13:24
Since pd.datetools.timedelta is deprecated, using datetime.timedelta is a possible workaround.
Try this updated code snippet:
import datetime
def convert_time(s):
    h, m, s = map(int, s.split(':'))
    return datetime.timedelta(hours=h, minutes=m, seconds=s)
data = pd.read_csv('marathon-data.csv',
                    converters={'split':convert_time, 'final':convert_time})
data.head()
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.