python - 将特定列表放入数据框

Question

我在将列表放入数据框时遇到问题。

数据列表=

 ["'2018-05-15 15:35:57\t\n', 'A', 'xtre','retle ",' 105.0 (C)\n'],
 ["'2018-05-15 15:35:57\t\n', 'A', 'xtre','retla ",' 0 (s*C)\n'],
 ["'2018-05-15 15:35:57\t\n', 'A', 'xtre','retla",' 0 (s*C)\n'],
 ["'2018-05-15 15:35:57\t\n', 'A', 'xtre','retke",' 0 (s)\n'],
 ["'2018-05-15 15:35:57\t\n', 'A', 'xtre','retds",' 0 (s)\n'],
 ["'2018-05-15 15:35:57\t\n', 'A', 'xtre','rewr",' 0 (s)\n'],
 ["'2018-05-15 15:35:57\t\n', 'A', 'xtre','sdff",' 0 (s)\n']

df = pd.DataFrame(dataInList) 仅将两个样本点识别为产生以下结果的列:

                                                   0             1
1  '2018-05-15 15:35:57\t\n', 'A', 'xtre','..............'   101.5 (C)\n
2  '2018-05-15 15:35:57\t\n', 'A', 'xtre','..............'   105.0 (C)\n
3  '2018-05-15 15:35:57\t\n', 'A', 'xtre','..............'   118.0 (C)\n
4  '2018-05-15 15:35:57\t\n', 'A', 'xtre','..............'   110.0 (C)\n
5  '2018-05-15 15:35:57\t\n', 'A', 'xtre','..............'   110.0 (C)\n

我应该如何进行？

预先感谢!

Answer 1

使用list理解与split列表的第一个值，然后添加strip以删除尾随空格:

df = pd.DataFrame([[y.strip() for y in x[0].split(',') + [x[1]]] for x in dataInList])
print (df)
                           0    1       2       3          4
0  '2018-05-15 15:35:57\t\n'  'A'  'xtre'  'retle  105.0 (C)
1  '2018-05-15 15:35:57\t\n'  'A'  'xtre'  'retla    0 (s*C)
2  '2018-05-15 15:35:57\t\n'  'A'  'xtre'  'retla    0 (s*C)

编辑:

问题是有一些列表没有长度2，所以需要过滤它:

dataInList = [["'2018-05-15 15:35:57\t\n', 'A', 'xtre','retle ",' 105.0 (C)\n'],
 ["'2018-05-15 15:35:57\t\n', 'A', 'xtre','retla ",' 0 (s*C)\n'],
 ["'2018-05-15 15:35:57\t\n', 'A', 'xtre','retla",' 0 (s*C)\n'],
 [ "aaa"]]

df = pd.DataFrame([[y.strip() for y in x[0].split(',') + [x[1]]] for x in dataInList if len(x) == 2])
print (df)
                           0    1       2       3          4
0  '2018-05-15 15:35:57\t\n'  'A'  'xtre'  'retle  105.0 (C)
1  '2018-05-15 15:35:57\t\n'  'A'  'xtre'  'retla    0 (s*C)
2  '2018-05-15 15:35:57\t\n'  'A'  'xtre'  'retla    0 (s*C)