Me basically a chemist, doing the same analysis almost every day. I hope I can guide you for choosing a perfect water purifier.
From the lab report, first thing you need to see is Conductivity from which the Total Dissolved Solids is interpreted. Mathematically, TDS is approximately 0.52 time of the conductivity which is measured. So your conductivity * 0.52, will give you TDS approximately.So what is the need in knowing this. Conductivity gives you the outline of quantity of ions (impurity) present in you water. But with TDS or conductivity you cannot predict which ion is contributing to the conductivity. In our total hardness, which is the sum of Calcium and Magnesium hardness is more. In fact it is heavy. If calcium is present more in water, it can react with oxalate and form bladder stone. Tomato has oxalate in it. According to BIS standards, conductivity of drinking water should be around 200 - 250 micro siemens. In your water it is more.
Let me put a full stop to all chemistry explanations and suggest you with respect to what you asked. I advice you to buy Reverse Osmosis water purifier (RO) with or with out UV. Pure it or Aqua guard cannot remove ions, then can just reduce the turbidity and foul smell. They have chloride tablets in them to kill germs. This chloride tablet is what used near battery which the manufacturer insist us to change periodically. So Pureit and Aqua guard is not all suitable for you as they cannot remove ions and ultimately the conductivity. Opt for RO purifier, the specialty is that is has membrane which remove ions. Final out put of TDS will be around 50. Its your choice to go for UV or with out UV. UV is to kill germs. In most cases it comes in built, but they charge you extra. You can buy separately and install too.If money is not concern for you buy Kent RO, its best. It has UV and TDS adjuster which means you adjust TDS according to your needs. It is helpful when you have children and old people in your house. Children require more ions where as old people require less. With the adjustment you can adjust TDS. I personally used it. If required I can send show you photo and give lab details of the output of Kent RO.