Hardik Pandya was the hero as India claimed a thrilling six-wicket victory to take an unassailable 2-0 series lead over Australia.