| 12345678910111213141516171819202122232425262728293031 |
- #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)
|
