Cleaning data

"H22.1.4" have to be converted to like this, "2010.1.4"

Then, turn the expression like "2010.1.4" into date value using "as.Date()" function

I wanna turn "H21" into "2009", "1.4" into "01.04" for as.Date() conversion.

So, what should I do?

Using Python

I try to do my mission by using Python.

My Python program should read the file ("something.csv" file suppose) and convert texts of date in the file into ideal way of expression.