Scaling data with different importance

I have 9 attributes: x1,x2,x3,x4,...,x9 and I know that the attributes x9 must have the same value in a cluster and the attribute X1 have more importance than others (x2,...,x8)

I'm using Euclidean distance and I normalized the data in order to have values between 0 and 1. I'm also using "One-Hot Encode Data" method in attributes x3,x4,x5,x6,x7,x8,x9.

I'm correlating within columns.

What do you recommend to scale my dataset properly?

For clarity here's what some of the input data looks like

Raw Input -Example 0.0.1

          x1,   x2, x3_1, x3_2, x3_3, x3_4, x3_5, x3_6, x3_7, x3_8, x3_9, x3_10, x3_11, x3_12, x3_13, x3_14, x3_15, x4_1, x4_2, x4_3, x4_4, x4_5, x4_6, x4_7, x4_8, x4_9, x5_1, x6_1, x7_1, x7_2, x7_3, x8_1, x8_2, x8_3, x9_1, x9_2, x9_3, x9_4

1553803283.0,  8.0,  1.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,   0.0,   0.0,   0.0,   0.0,  1.0,  0.0,  0.0,  1.0,  1.0,  1.0,  0.0,  0.0,  0.0,  0.0,  1.0,  0.0,  0.0,  0.0,  1.0
1553803286.0,  8.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  1.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,   0.0,   0.0,   0.0,   0.0,  1.0,  0.0,  0.0,  1.0,  1.0,  1.0,  0.0,  0.0,  0.0,  0.0,  1.0,  0.0,  0.0,  0.0,  1.0
1553803287.0,  8.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  1.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,   0.0,   0.0,   0.0,   0.0,  1.0,  0.0,  0.0,  1.0,  1.0,  1.0,  0.0,  0.0,  0.0,  0.0,  1.0,  0.0,  0.0,  0.0,  1.0
1553803343.0, 24.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  1.0,  0.0,  0.0,  0.0,  0.0,  0.0,   0.0,   0.0,   0.0,   0.0,  0.0,  1.0,  0.0,  1.0,  1.0,  0.0,  1.0,  0.0,  0.0,  1.0,  0.0,  0.0,  1.0,  0.0,  0.0
1553803349.0, 24.0,  0.0,  0.0,  0.0,  0.0,  0.0,  1.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,  0.0,   0.0,   0.0,   0.0,   0.0,  0.0,  1.0,  0.0,  1.0,  1.0,  0.0,  1.0,  0.0,  0.0,  1.0,  0.0,  0.0,  1.0,  0.0,  0.0


Abridged Input -Example 0.0.2

          x1,  x2,                 x3,                  x4,                 x5,                 x6,                 x7,                 x8,                 x9

1553803283.0, 8.0, <one-hot-length-15>, <one-hot-length-9>, <one-hot-length-1>, <one-hot-length-1>, <one-hot-length-3>, <one-hot-length-3>, <one-hot-length-4>
1553803286.0, 8.0, <one-hot-length-15>, <one-hot-length-9>, <one-hot-length-1>, <one-hot-length-1>, <one-hot-length-3>, <one-hot-length-3>, <one-hot-length-4>
1553803287.0, 8.0, <one-hot-length-15>, <one-hot-length-9>, <one-hot-length-1>, <one-hot-length-1>, <one-hot-length-3>, <one-hot-length-3>, <one-hot-length-4>


• This is nearly identical to a question I ran across less than 24 hours ago... yeah the questions be different, but the set-up's the same... it would probably help answerers if either of ya provided more information, eg. what's the raw input look like? Doesn't have to be copied, just give people a better idea of your problem space with something similar. Specifically for scaling heard rumors in other questions that this may not necessarily be required... but that might be hear-say. – S0AndS0 Apr 18 at 17:11
• Thank you for your help. The help of all of you is always very appreciated. The question you mentioned is from my brother, I created another question because they are different questions. My "raw data" (after using one hot encoding): pastebin.com/fRv4U9BU – Mario Apr 18 at 17:44
• I already know that I can use different scales to give more importance to some attributes. However I am afraid to use scales that make no sense. How can I give more importance to a numeric and nominal (category) variables? In my dataset I have 2 numeric attributes and the others are nominal. I can give you more information if necessary @S0AndS0 – Mario Apr 18 at 17:52
• Most welcome @Mario! Please edit the edits I've made, specifically the second formatted block, I think it'll help with getting readers up-to-speed with the things your asking. Also are you training for correlation within columns, between, columns, across all columns, etc...? In other words, having a sample of what is being fed to your NN is great, knowing how it feeds too will likely be even better for getting solid suggestions. And side note, I recognized that there where different questions, it was more to validate that feeling of déjà vu that other readers may have had. – S0AndS0 Apr 18 at 18:34
• Thanks @S0AndS0 . I have just edited my post. I'm correlating within columns. – Mario Apr 18 at 19:35

Side note; looks like you've got three extra columns of data... somewhere... oh ya may have got that on the last edit, aside from the slightly wonky spacing it's far more comprehensible.

Recommendations based off information so far provided;

• consider leveraging Word-2-Vec for some of the encoding, eg. x3 through x9, as it's a simple way of dealing with novel inputs; there'd still be the same number of columns, but the benefits may outweigh the costs of restructuring the network some.

• in regards to columns x1 and x2, maybe take another glance at the paper linked to the other question I commented about. If I read it correctly they had some special sauce for feeding raw inputs into their network that maybe inspirational.

Information that will likely help with better answers or updates to this one would be;

• what are you trying to model, eg. are you trying to predict, recognize/categorize, etc.?

• what's the behavior of the network currently and what are you looking to improve?

• what libraries, if any, are you using?

Simply put, I've found no fool proof, "proper" or the way for massaging inputs, however, depending upon how you frame what you want modeled there maybe options that are an easy fit.

Furthermore it may help in being flexible in what it is that you want modeled, try to frame things from a few different angles so to speak. Or for a more tangible example check this Q&A, in particular how the linked to researchers re-framed genetic data into a time-series problem; by being a bit flexible in mindset they where able to do some interesting things swiftly.

Hopefully with a little more information someone can come along and do better at providing a direct answer with less hand waving.

Side note, if ya add more information (such as what I pointed out) to your question it'll definitely help those writing better answers than I.