Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10.216.113.172 - - [04/Sep/2009:02:57:16 -0700] 10.211.47.159 - - [03/Sep/2009:22:19:49 -0700] I have multible datetimes in a column of dataframe of pandas and I have to

10.216.113.172 - - [04/Sep/2009:02:57:16 -0700]

10.211.47.159 - - [03/Sep/2009:22:19:49 -0700]

I have multible datetimes in a column of dataframe of pandas and I have to subtract them and convert them in to UTC time and then sort them. #10.216.113.172 - - 04/Sep/2009:02:57:16 -0700 have to subtract 0700 after subtract 10.216.113.172 - - 03/Sep/2009

My dataFrame is right here :

df['timestamp].strptime it has str : 04/Sep/2009:02:57:16 -0700,03/Sep/2009:22:19:49 -0700 in it but I have to subtract them first -0700 like that. after subtract it will go back to the previous day

I tried to use datetime.strptime but is not desired output

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analysis Using SQL And Excel

Authors: Gordon S Linoff

2nd Edition

111902143X, 9781119021438

More Books

Students also viewed these Databases questions