Writing streaming data into dataframe

nithishkailas

rom kiteconnect import WebSocket as wb
kws = wb(api_key, public_token, user_id)
import pandas
def on_tick(tick, ws) : print(tick,"\n")
def on_tick(tick,ws) : new = pandas.DataFrame(tick,ws)
def on_connect(ws): ws.subscribe[408065]
def on_connect(ws):ws.set_mode(ws.MODE_LTP,[408065])
kws.on_tick=on_tick
kws.on_connect=on_connect
kws.connect()

THIS CODE IS SHOWING ME THIS ERROR

ERROR:websocket:error from callback >: 'WebSocket' object is not iterable

ERROR:websocket:error from callback >: 'WebSocket' object is not iterable

ERROR:websocket:error from callback >: 'WebSocket' object is not iterable

guys, please help me fix this code. any other methods to write data into dataframe.

sujith

Hi @nithishkailas,
It seems like Pandas is iterating through websocket object. I would suggest checking Pandas documentation.

Vivek

You should be initializing empty Panda's dataframe for ticks data structure and then append ticks to the frame.

Reference - https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.append.html