这是我的代码

import pandas

log_data  = open('sql_actions_unconnected1.log', 'r')

split1 = []

for line in log_data:

   data = line.split(',')

    print(data)
    ID = data[1]
    time = data[2]
    details = data[3]
split1.append([ID, time, details])

df = pd.DataFrame(split_list, columns=['ID', 'time', 'details'])

This is how my log file looks like
Screen shot

它不包含任何列名

Here is my expected output , I want this kind of output

Screen shot

但是我得到了非常混乱的输出，我使用了大熊猫和“分裂”进行操纵

帮助将不胜感激

pandas dataframe