CSV parse_dates not working if multiline header is specified. (original) (raw)
I can't seem to be able to parse dates of multiheader files... Here's an example illustrating the problem I'm facing:
import pandas as pd from io import StringIO
csv = """date,time,value YYYY/MM/DD,HH:MM,Smp 2014/12/01,00:00,1 2014/12/01,01:00,2"""
pd.read_csv(StringIO(csv), header=[0,1], parse_dates=[['date','time']])