在Python中旋转而没有Pandas？

Question

没有pandas我一直在努力做到这一点。
有人能帮忙吗？你知道吗

ID,Name,timstamp,IN_OR_OUT,Date
103161,John Alex,15-10-2018 10:51:01,IN,15-10-2018
103161,John Alex,15-10-2018 11:31:00,OUT,15-10-2018
103161,John Alex,15-10-2018 11:32:07,IN,15-10-2018
103161,John Alex,15-10-2018 11:38:07,OUT,15-10-2018
103161,John Alex,15-10-2018 11:43:03,IN,15-10-2018
103161,John Alex,15-10-2018 13:00:08,OUT,15-10-2018 
103161,John Alex,15-10-2018 13:46:07,IN,15-10-2018
103161,John Alex,15-10-2018 14:28:04,OUT,15-10-2018
103161,John Alex,15-10-2018 14:29:04,IN,15-10-2018
103161,John Alex,15-10-2018 15:08:06,OUT,15-10-2018
103161,John Alex,15-10-2018 15:12:03,IN,15-10-2018
103161,John Alex,15-10-2018 15:54:00,OUT,15-10-2018
103161,John Alex,15-10-2018 15:58:00,IN,15-10-2018
103161,John Alex,15-10-2018 16:01:00,OUT,15-10-2018
103161,John Alex,15-10-2018 16:15:06,IN,15-10-2018
103161,John Alex,15-10-2018 17:33:02,OUT,15-10-2018
103161,John Alex,15-10-2018 17:34:02,IN,15-10-2018
103161,John Alex,15-10-2018 17:45:04,OUT,15-10-2018 

所以我希望最终的输出是这样的

ID,Name,timstamp,IN,OUT,Date
103161,John Alex,15-10-2018 10:51:01,15-10-2018 11:31:00,15-10-2018
103161,John Alex,15-10-2018 11:32:07,15-10-2018 11:38:07,15-10-2018
103161,John Alex,15-10-2018 11:43:03,15-10-2018 13:00:08,15-10-2018
103161,John Alex,15-10-2018 13:46:07,15-10-2018 14:28:04,15-10-2018
103161,John Alex,15-10-2018 14:29:04,15-10-2018 15:08:06,15-10-2018

我知道我们可以使用pandas来实现这一点，但是我们是否可以在没有pandas的情况下实现这一点？你知道吗

Answer 1

假设您的所有输入行都存储在lines中，并且它们是有序的，即连续的条目属于一起，那么这就是解决方案：

for k, line in enumerate(lines):
    if not k % 2:
        out_line = line
    else:
        print(out_line.replace('IN', line.split(',')[2]))