Want to add new column to a pandas dataframe after resampling the api tick data

Asked Aug 01 '22 at 16:05

Active Aug 01 '22 at 16:05

Viewed 36 times

I have a program that convert api live tick data to a 15 Sec time Dataframe. But in the new dataframe some old columns are missing which is very much necessary from my further work. How can fetch those old columns to my new dataframe. I want to add ts, tk ...which are very important for me.

def df_tech(df, interval):
    df = df[['ts','tk','lp', 'pc', 'ltq']]
    df.index = pd.to_datetime(df['ft'], format='%Y-%m-%d %H:%M:%S')
    df1 = df['lp'].resample(interval).ohlc().bfill()
    df1['ShortEMA'] = df1.close.ewm(span=10, adjust=False).mean()
    df1['LongEMA']  = df1.close.ewm(span=21, adjust=False).mean()
    return df1

asked Aug 01 '22 at 16:05

Arunava Datta

can you share the code where u r fetching the data from api – Himanshu Poddar Aug 01 '22 at 16:10
I am getting this data from finvasia api – Arunava Datta Aug 01 '22 at 16:15
can you post the data that you directly are getting from the API, and then the code where u r processing it – Himanshu Poddar Aug 01 '22 at 16:27
sent you message in your fb messenger – Arunava Datta Aug 01 '22 at 16:32
fb messeneger, how did you get my id? – Himanshu Poddar Aug 01 '22 at 16:37
check message at request and then spam – Arunava Datta Aug 01 '22 at 16:50
nope don't see it, mail me(check my profile) – Himanshu Poddar Aug 01 '22 at 16:54
mail sent as well as my fb id......try to connect me there. – Arunava Datta Aug 01 '22 at 16:57

Want to add new column to a pandas dataframe after resampling the api tick data

0 Answers0