Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do you de-normalise?

Once you do normalisation of your data so the values are between 0-1, how do you de-normalise it so you can interpret the result?

So when you normalise your data, and feed it to your network and get an output which is normalised data. How do you reverse normalisation to get the original data?

like image 823
Sam Avatar asked Jul 22 '17 18:07

Sam


People also ask

How do you do denormalization?

Denormalization is done after normalization for improving the performance of the database. The data from one table is included in another table to reduce the number of joins in the query and hence helps in speeding up the performance.

How do I Denormalize data in mysql?

It is a database optimization technique where we can add redundant data to one or more tables and optimize the efficiency of the database. It is applied after doing normalization. It also avoids costly joins in a relational database.


1 Answers

If you have some data d that you normalize to 0-1 by doing (something like)

min_d = np.min(d)
max_d = np.max(d)
normalized_d = (d - min_d) / (max_d - min_d)

you can de-normalize this by inverting the normalization. In this case

denormalized_d = normalized_d * (max_d - min_d) + min_d
like image 59
Jonas Adler Avatar answered Oct 27 '22 07:10

Jonas Adler