import pandas as pd import sys if sys.version_info[0] < 3: from StringIO import StringIO else: from io import StringIO
pd.read_csv(StringIO(''' col1 col2 col3 col4 1 4.4 99 A 2 4.5 200 B 3 4.7 65 C 4 3.2 140 D '''), delim_whitespace=True)
pd.read_csv(StringIO(''' col1;col2;col3;col4 1;4.4;99;A 2;4.5;200;B 3;4.7;65;C 4;3.2;140;D '''), delimiter=';' # delim_whitespace=True )
df = pd.read_csv(StringIO('''\ from, to, dep, freq, arr, code, mode RGBOXFD,RGBPADTON,127,0,27,99999,2 RGBOXFD,RGBPADTON,127,0,33,99999,2 RGBOXFD,RGBRDLEY,127,0,1425,99999,2 RGBOXFD,RGBCHOLSEY,127,0,52,99999,2 RGBOXFD,RGBMDNHEAD,127,0,91,99999,2 RGBDIDCOTP,RGBPADTON,127,0,46,99999,2 RGBDIDCOTP,RGBPADTON,127,0,3,99999,2 RGBDIDCOTP,RGBCHOLSEY,127,0,61,99999,2 RGBDIDCOTP,RGBRDLEY,127,0,1430,99999,2 RGBDIDCOTP,RGBPADTON,127,0,115,99999,2 '''), index_col=[0, 1], skipinitialspace=True)
df = pd.read_csv(StringIO(''' Male, Male, Male, Female R, R, L, R .86, .67, .88, .78, .81 '''), header=[0, 1])
df = pd.read_csv(StringIO(''' C0,,C_l0_g0,C_l0_g1,C_l0_g2 C1,,C_l1_g0,C_l1_g1,C_l1_g2 C2,,C_l2_g0,C_l2_g1,C_l2_g2 C3,,C_l3_g0,C_l3_g1,C_l3_g2 R0,R1,,, R_l0_g0,R_l1_g0,R0C0,R0C1,R0C2 R_l0_g1,R_l1_g1,R1C0,R1C1,R1C2 R_l0_g2,R_l1_g2,R2C0,R2C1,R2C2 R_l0_g3,R_l1_g3,R3C0,R3C1,R3C2 R_l0_g4,R_l1_g4,R4C0,R4C1,R4C2 '''), header=[0,1,2,3], index_col=[0,1], skipinitialspace=True) df
from IPython.core.display import HTML HTML('<style>{}</style>'.format(''' body { margin: 0; font-family: Helvetica; } table.dataframe { border-collapse: collapse; border: none; } table.dataframe tr { border: none; } table.dataframe td, table.dataframe th { margin: 0; border: 1px solid white; padding-left: 0.25em; padding-right: 0.25em; } table.dataframe th:not(:empty) { background-color: #fec; text-align: left; font-weight: normal; } table.dataframe tr:nth-child(2) th:empty { border-left: none; border-right: 1px dashed #888; } table.dataframe td { border: 2px solid #ccf; background-color: #f4f4ff; }'''))