What is the easiest way to get this Date and Time in two separate columns into a Pandas to_datetime (with the correct formatting) and set it as the index?
Date Time Open High Low Close Volume
20180316 1935 178.15 178.24 178.15 178.24 5000.0
20180316 1937 178.04 178.04 178.04 178.04 80.0
20180316 1939 178.06 178.06 178.06 178.06 300.0
20180316 1946 178.01 178.01 178.01 178.01 50.0
Here are the dtypes for reference
Date int64
Time int64
Open float64
High float64
Low float64
Close float64
Volume float64