Pandas Time Series Analysis 6: Timezone Handling

Timezone handling is important while doing time series analysis. Pandas provides a way to create timezone aware datetimeIndex. Use tz_localize on dataframe or dataframe index to convert naive datetimes to timezone aware datetimes. You can also perform arithmetic between series having different time zones.

Topics that are covered in this Python Pandas Video:
0:00 Introduction
1:42 Time objects in python
1:57 Convert Naive timezone to time zone aware datetime using tz_localize()
4:00 Use tz_convert() function
7:04 How you can use timezone in date_range() function
8:30 Use dateutil time zone

Next Video:

Popular Playlist:

[codebasics]

Machine learning tutorials with exercises are available at:

[codebasics]

Machine learning tutorials with exercises:

[flamboyantperson]

Best tutorial on time series. So easy to understand your teaching.

[skkkks]

Wow, great example in a simple way, excellent job.

[philiperiskallaleal]

Dear all, thank you for the awesome video. It is amazing what pandas has to offer.

Regarding timezone operations within python, I was wondering if pandas allows one to slice a dataframe (or a series) based on localized datetime objects which may (or may not) be in the same timezone as the dataframe (series) index.

If pandas allows such slicing operation, how does it do? Does it disregard the timezone of the datetime object during the slicing operation (therefore, it assumes that the datetime objects have the same timezone as the pandas index); or does it detect the timezone from the datetime objects, converts them into the same timezone of the pandas index, and, only then, apply the slicing operation?

Sincerely,

[ad]

Great Video. One doubt. How do you handle data with multple timezone values? Convert to UTC, Analyze and reconvert back when reporting? Or is there a better way ?

[Daddyy-cy]

It is a lot more easy to make an Excel file of the stock price by looking at yours and then converting it to CSV by converters than to search and download it 😅

[UMESHDAVEY]

Me too... for me the end time is coming in "2017-03-31 format but i want in "2017-03-31" format.
How do i change it.

[suprabhatkumara]

for me the end time is coming in "2017-03-31 format but i want in "2017-03-31" format.
How do i change it.

[colesudkamp-walker]

How can you do this when Datetime isn't your index? Currently my date and time is a column and I would like to keep it that way.

[UMESHDAVEY]

me also for me the end time is coming in "2017-03-31 format but i want in "2017-03-31" format.
How do i change it.