1/4/2010,08:01:00,5982.8
1/4/2010,08:02:00,5992.2
1/4/2010,08:03:00,5990.2
...
1/4/2010,22:00:00,6000.1
import pandas as pd
# Settings, Index & Columns Initializationfilename = 'Germany30-2.csv'
# Load data from CSVdataFrame = pd.read_csv(filename,names=['date','time','price'],header=None)
# Set DateTime indexdataFrame.index = pd.to_datetime(dataFrame['date'],format='%m/%d/%Y')dataFrame=dataFrame.drop('date',1)
# Pivotdata = dataFrame.pivot(columns='time',values='price')print(data)
time 08:01:00 08:02:00 08:03:00 08:04:00 08:05:00 08:06:00 \date 2010-01-04 5982.8 5992.2 5990.2 5989.8 5993.7 5993.7
time 07:01:00 07:03:00 07:04:00 07:05:00 07:06:00 07:07:00 \date 2010-01-04 NaN NaN NaN NaN NaN NaN 2010-01-05 NaN NaN NaN NaN NaN NaN 2010-01-06 NaN NaN NaN NaN NaN NaN 2010-01-07 NaN NaN NaN NaN NaN NaN