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 7 from 0700 after subtract for the first lane it change to 10.216.113.172 - - 03/Sep/2009

I dont need the hours mins and secs anymore My dataFrame is right here : df['timestamp].strptime it has dataframe column like : 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

In python language pandas thanks!

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_2

Step: 3

blur-text-image_3

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

AutoCAD Database Connectivity

Authors: Scott McFarlane

1st Edition

0766816400, 978-0766816404

More Books

Students also viewed these Databases questions

Question

7. Where Do We Begin?

Answered: 1 week ago