#coding:utf8

import pandas as pd

if __name__=="__main__":
    file = "relation.txt"
    id = []
    name = []
    step_host = []
    type_host = []
    step_guest = []
    type_guest = []
    with open(file,"r",encoding="utf8") as f:
        while(True):
            line = f.readline().strip()
            if not line:
                break
            line_split = line.split(";")
            if len(line_split)!=6:
                continue
            print(line_split)
            id.append(line_split[0])
            name.append(line_split[1])
            step_host.append(line_split[2])
            type_host.append(line_split[3])
            step_guest.append(line_split[4])
            type_guest.append(line_split[5])
        
    dataframe = pd.DataFrame({'id':id,'name':name,'step_host':step_host,'type_host':type_host,'step_guest':step_guest,'type_guest':type_guest})
    columns = ['id','name','step_host','type_host','step_guest','type_guest']
    dataframe.to_csv("relation.csv",index=False,header=False,sep=",",encoding="utf8",columns=columns)