Replacing dataframe value with array

Question

I have a time series dataframe that i want to predict with LSTM but i cant replace the train and test value with the scaled value.

This is the dataframe

and this is the scaled data

How can i put the scaled value replacing the value in train dataframe ?Since the index is a date and i cant do loop to replacing the data. and i cant replace data in dataframe either.

Thanks in advance

Pablo C · Accepted Answer · 2021-01-27 14:27:53Z

2

You can use pandas.DataFrame.replace:

ts_train.replace(ts_train.values, train_data_scaled)

answered Jan 27, 2021 at 14:27

Pablo C

4,7612 gold badges10 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

David FIM Over a year ago

Thank you! this is what i need

Pablo C Over a year ago

@DavidFIM glad to help :)

zglin · Accepted Answer · 2021-01-27 14:24:39Z

1

You can use a couple of methods, if you want to reassign the data you can create a new dataframe and set the indicies to ts_train_scaled with a command like

pd.Dataframe(data=ts_train_scaled, index=ts_train.index)

If you truly need to replace the value in ts_train, you can use the DataFrame replace command which allows you to replace the value dynamically

answered Jan 27, 2021 at 14:24

zglin

2,9192 gold badges18 silver badges26 bronze badges

1 Comment

David FIM Over a year ago

Thank you! this is what i need

Collectives™ on Stack Overflow

Replacing dataframe value with array

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related