@jonathan.legrand

The pythonic way is to utilize vectorized methods wherever possible instead of your own loops. The main reason is that vectorized methods are optimized for runtime and typically run faster than your own loops (sometimes by an order of magnitude faster). Vectorized methods also improve readability of the code by making the code more compact.

@jaredd.matutina01

Please see an example of of converting the timezone in the dataframe index from UTC to the timezone of your choice on this thread.

Hi @jaredd.matutina01 ,

I would suggest looking this up on StackOverflow:

https://stackoverflow.com/questions/4770297/convert-utc-datetime-string-to-local-datetime

Does this provide the answer you're looking for?

E.g.:

import datetime
from pytz import timezone

ist = []
for i in data.index:
    try:
        _ist = datetime.datetime.strptime(str(i), '%Y-%m-%d %H:%M:%S.%f')
        _ist = _ist.astimezone(timezone('Asia/Kolkata'))
        _ist = _ist.strftime("%Y-%m-%d %H:%M:%S.%f")
    except:
        _ist = datetime.datetime.strptime(str(i), '%Y-%m-%d %H:%M:%S')
        _ist = _ist.astimezone(timezone('Asia/Kolkata'))
        _ist = _ist.strftime("%Y-%m-%d %H:%M:%S")
    ist.append(_ist)

data.index = ist

Thank you guys for these inputs!

@jaredd.matutina01 @Alex Putkov. @jonathan.legrand

Hi, I tried this code but got the following error:

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-14-bcd1c96da781> in <module>
      1 import pytz
      2 ----> 3 data.index = data.index.tz_localize(pytz.utc).tz_convert('Asia/Kolkata')

AttributeError: 'Index' object has no attribute 'tz_localize

@jonathan.legrand here's the full code

import eikon as ek

import datetime as dt

from datetime import time

import pytz

ek.set_app_key('.....')

data=ek.get_timeseries('SBI.NS', interval='tick')

data.index = data.index.tz_localize(pytz.utc).tz_convert('Asia/Kolkata')

data.tail()