Why are you creating this Series and then iterating over the index? Surely there is an easier way of doing this.