just trying to save websockets to CSV’s. But it just doesnt make the file. Nothing in the directory. Tried running VScvode as admin, moving folder out of C: drive to documents .. nothing. no csv file, and no error. and no information on the internet about this either.
So i kept stripping down the code to the most basic, and it still wont create the file
The dataframe is in-tact and working, and printing the dataframe gets this :
e E s k B kline 1659568703134 ETHUSDT 0 L kline 1659568703134 ETHUSDT 920866977 Q kline 1659568703134 ETHUSDT 166707.65228800 T kline 1659568703134 ETHUSDT 1659568739999 V kline 1659568703134 ETHUSDT 103.43430000 c kline 1659568703134 ETHUSDT 1611.00000000
… (continued)
import websocket, json, numpy, pandas from binance.client import Client from binance.enums import * SOCKET = "wss://stream.binance.com:9443/ws/ethusdt@kline_1m/btcusdt@kline_1m" #lol def on_open(ws): print('opened connection') def on_close(ws): print('closed connection') def on_message(ws, message): df = pandas.read_json(message) print(df) df.to_csv('my_new_file.csv') ws = websocket.WebSocketApp(SOCKET, on_open=on_open, on_close=on_close, on_message=on_message) ws.run_forever()
Advertisement
Answer
Try this:
import os print(os.getcwd())
This will give you the file directory that the file is currently running on, so you can drop the file there.