How to write data of a pandas Data frame into the pre defined condition row's of excel
Budget: ₹600 – ₹1,500 INR
def callback_method(message):
df = pd.DataFrame(message).T
xw.Book('Live_Data.xlsx').sheets['Data'].range('B2').value = df
client.subscribe(input_tokens="14226,113470", callback=callback_method,
broadcast_host="https://wstreamer.kotaksecurities.com/feed")
This code prints data of 14226,113470 tokens alternately into excel at the same B2 row. I need the data write-in to excel in two different rows B2 & B3 matching some conditions if the A2 cell value is 14226 then print this token data into B2 and if the A3 cell value is 113470 print this token data into the B3 row.
The output of the codes attached here
df = pd.DataFrame(message).T
xw.Book('Live_Data.xlsx').sheets['Data'].range('B2').value = df
client.subscribe(input_tokens="14226,113470", callback=callback_method,
broadcast_host="https://wstreamer.kotaksecurities.com/feed")
This code prints data of 14226,113470 tokens alternately into excel at the same B2 row. I need the data write-in to excel in two different rows B2 & B3 matching some conditions if the A2 cell value is 14226 then print this token data into B2 and if the A3 cell value is 113470 print this token data into the B3 row.
The output of the codes attached here