To standardize the data in the database

There is a table of the database Postgres
The table stores the characteristics of the columns:
"Weight" "2 kg"
"Weight" "300 g"
"Weight" "150 g batteries"
Need to make a script that
1) runs through all groups(eg weight, power, diagonal)