Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

You can use the function tz_localize to make a Timestamp or DateTimeIndex timezone aware, but how can you do the opposite: how can you convert a timezone aware Timestamp to a naive one, while preserving its timezone?

An example:

In [82]: t = pd.date_range(start="2013-05-18 12:00:00", periods=10, freq="s", tz="Europe/Brussels")

In [83]: t
Out[83]: 
<class "pandas.tseries.index.DatetimeIndex">
[2013-05-18 12:00:00, ..., 2013-05-18 12:00:09]
Length: 10, Freq: S, Timezone: Europe/Brussels

I could remove the timezone by setting it to None, but then the result is converted to UTC (12 o"clock became 10):

In [86]: t.tz = None

In [87]: t
Out[87]: 
<class "pandas.tseries.index.DatetimeIndex">
[2013-05-18 10:00:00, ..., 2013-05-18 10:00:09]
Length: 10, Freq: S, Timezone: None

Is there another way I can convert a DateTimeIndex to timezone naive, but while preserving the timezone it was set in?

Some context on the reason I am asking this: I want to work with timezone naive timeseries (to avoid the extra hassle with timezones, and I do not need them for the case I am working on).
But for some reason, I have to deal with a timezone-aware timeseries in my local timezone (Europe/Brussels). As all my other data are timezone naive (but represented in my local timezone), I want to convert this timeseries to naive to further work with it, but it also has to be represented in my local timezone (so just remove the timezone info, without converting the user-visible time to UTC).

I know the time is actually internal stored as UTC and only converted to another timezone when you represent it, so there has to be some kind of conversion when I want to "delocalize" it. For example, with the python datetime module you can "remove" the timezone like this:

In [119]: d = pd.Timestamp("2013-05-18 12:00:00", tz="Europe/Brussels")

In [120]: d
Out[120]: <Timestamp: 2013-05-18 12:00:00+0200 CEST, tz=Europe/Brussels>

In [121]: d.replace(tzinfo=None)
Out[121]: <Timestamp: 2013-05-18 12:00:00> 

So, based on this, I could do the following, but I suppose this will not be very efficient when working with a larger timeseries:

In [124]: t
Out[124]: 
<class "pandas.tseries.index.DatetimeIndex">
[2013-05-18 12:00:00, ..., 2013-05-18 12:00:09]
Length: 10, Freq: S, Timezone: Europe/Brussels

In [125]: pd.DatetimeIndex([i.replace(tzinfo=None) for i in t])
Out[125]: 
<class "pandas.tseries.index.DatetimeIndex">
[2013-05-18 12:00:00, ..., 2013-05-18 12:00:09]
Length: 10, Freq: None, Timezone: None

👻 Read also: what is the best laptop for engineering students?

Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone __del__: Questions

import time
time.sleep(5)   # Delays for 5 seconds. You can also use a float value.

import time
while True:
    print("This prints once a minute.")
    time.sleep(60) # Delay for 1 minute (60 seconds).

from time import sleep
sleep(0.1) # Time in seconds

Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone __del__: Questions

We hope this article has helped you to resolve the problem. Apart from Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone, check other __del__-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

• Italiano Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
• Deutsch Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
• Français Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
• Español Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
• Türk Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
• Русский Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
• Português Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
• Polski Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
• Nederlandse Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
• 中文 Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
• 한국어 Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
• 日本語 Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
• हिन्दी Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone