RL-Bitcoin-trading-bot icon indicating copy to clipboard operation
RL-Bitcoin-trading-bot copied to clipboard

Nomalizing data

Open crazypythonista opened this issue 4 years ago • 0 comments

Here's the full traceback call I am getting in nomalizing the data; I made the column_list print. ['Unnamed: 0', 'Date', 'Open', 'Close', 'High', 'Low', 'Volume', 'sma7', 'sma25', 'sma99', 'bb_bbm', 'bb_bbh', 'bb_bbl', 'psar', 'MACD', 'RSI'] Traceback (most recent call last): File "D:\RL-Bitcoin-trading-bot_7\tazz\lib\site-packages\pandas\core\ops\array_ops.py", line 143, in na_arithmetic_op result = expressions.evaluate(op, left, right) File "D:\RL-Bitcoin-trading-bot_7\tazz\lib\site-packages\pandas\core\computation\expressions.py", line 233, in evaluate return _evaluate(op, op_str, a, b) # type: ignore File "D:\RL-Bitcoin-trading-bot_7\tazz\lib\site-packages\pandas\core\computation\expressions.py", line 68, in _evaluate_standard return op(a, b) TypeError: unsupported operand type(s) for -: 'str' and 'float'

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "RL-Bitcoin-trading-bot_7.py", line 563, in df_nomalized = Normalizing(df[99:])[1:].dropna() File "D:\RL-Bitcoin-trading-bot_7\utils.py", line 290, in Normalizing df[column] = df[column] - df[column].shift(1) File "D:\RL-Bitcoin-trading-bot_7\tazz\lib\site-packages\pandas\core\ops\common.py", line 65, in new_method return method(self, other) File "D:\RL-Bitcoin-trading-bot_7\tazz\lib\site-packages\pandas\core\ops_init_.py", line 343, in wrapper result = arithmetic_op(lvalues, rvalues, op) File "D:\RL-Bitcoin-trading-bot_7\tazz\lib\site-packages\pandas\core\ops\array_ops.py", line 190, in arithmetic_op res_values = na_arithmetic_op(lvalues, rvalues, op) File "D:\RL-Bitcoin-trading-bot_7\tazz\lib\site-packages\pandas\core\ops\array_ops.py", line 150, in na_arithmetic_op result = masked_arith_op(left, right, op) File "D:\RL-Bitcoin-trading-bot_7\tazz\lib\site-packages\pandas\core\ops\array_ops.py", line 92, in masked_arith_op result[mask] = op(xrav[mask], yrav[mask]) TypeError: unsupported operand type(s) for -: 'str' and 'str'

Any sort of help would be appreciated. Thanks.

crazypythonista avatar Jun 17 '21 18:06 crazypythonista