import pandas as pd
import datetime
data = pd.DataFrame([['G1', '2018010101'], ['G2', '2018011101']], columns=['a', 'b'])
def convertDateStr(value):
return datetime.datetime.strptime(value, "%Y%m%d%H").strftime("%Y-%m-%d %H:%M:%S.000")
data.b = data.b.apply(convertDateStr)
print(data)
aW1wb3J0IHBhbmRhcyBhcyBwZAppbXBvcnQgZGF0ZXRpbWUKCmRhdGEgPSBwZC5EYXRhRnJhbWUoW1snRzEnLCAnMjAxODAxMDEwMSddLCBbJ0cyJywgJzIwMTgwMTExMDEnXV0sIGNvbHVtbnM9WydhJywgJ2InXSkKCmRlZiBjb252ZXJ0RGF0ZVN0cih2YWx1ZSk6CiAgICByZXR1cm4gZGF0ZXRpbWUuZGF0ZXRpbWUuc3RycHRpbWUodmFsdWUsICIlWSVtJWQlSCIpLnN0cmZ0aW1lKCIlWS0lbS0lZCAlSDolTTolUy4wMDAiKQoKZGF0YS5iID0gZGF0YS5iLmFwcGx5KGNvbnZlcnREYXRlU3RyKQoKcHJpbnQoZGF0YSk=