'After standardization I got much larger values for columns with small standard deviation? How should I unified the data

I have a data set that I would like to clean it. Among these data I have some columns with small mean and small std. When I try to standrize it the elements of those columns getting very large. Ho should I solve the problem? Am I allowed to first normalise each column and then standrized whole data set? The figure for comparing their mean before and after is attached. enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source