ChatGPT Code Interpreter prompt:

I want to buy one of the EVs from the provided dataset. Give me the top ten options based on the following weights.

wltp, higher is better: 35% price, lower is better: 35% km, lower is better: 20% year, higher is better: 10%

Ignore anomalies in the dataset such as WLTPs larger than 1500.