Specify Multi-level Columns Using Pd.read_clipboard?

Here's some data from another question: main Meas1 Meas2 Meas3 Meas4 Meas5 sublvl Value Value Value Value Value count 7.000000 1.0 1.0 582.00 97

Solution 1:

In [17]: pd.read_clipboard(sep='\s+', index_col=[0], header=[0,1])
Out[17]: 
main   Meas1 Meas2 Meas3   Meas4     Meas5
sublvl Value Value Value   Value     Value
count    7.0   1.0   1.0  582.00  97.00000
mean    30.0  37.0  26.0   33.03  16.63535