event2state

convert.py

#!/usr/bin/python
# coding: UTF-8

def convert(node, rec_set):
    if node == None:
        return (rec_set[1], rec_set[2], "", "") # いきなり休会とか退会がくることは考慮しない
    if node[0] == rec_set[1]:
        return node
    if rec_set[1] == "signup":
        return (rec_set[1], rec_set[2], "", "")     
    if rec_set[1] == "suspend":
        return (rec_set[1], node[1], rec_set[2], "")
    if rec_set[1] == "resign":
        return (rec_set[1], node[1], node[2], rec_set[2])        
    
st = {} # 1 : ('suspend', '8/1', '9/1', '')
f = open('input.csv')
line = f.readline() # line = "1,signup,8/1"
while line:
    l = line.replace('\n','').split(",") 
    n = st[l[0]] if st.has_key(l[0]) else None
    st[l[0]] = convert(n, l)
    line = f.readline()
f.close
print st