|
本帖最后由 sheeboard 于 2019-7-22 17:15 编辑
笨办法做的,仅作参考,具体应用还需完善。肯定还会有更好的办法的。
- str=''
- with open('colon.txt') as f:
- for line in f.readlines():
- str+=line
- mylist=re.split(r'(\w\d?\d?\w?\d?\/?\d?\d?\d?:)',str)
- mylist=[i.strip() for i in mylist if i!='']
- lista=mylist[::2]
- listb=mylist[1::2]
- listb=[i.replace('\n',' ') for i in listb]
- for i in range(len(lista)):
- if re.match(r'\w\d\d:',lista[i]):
- lista[i]='?'+lista[i]
- elif re.match(r'\w\d\d\w:',lista[i]):
- lista[i]='??'+lista[i]
- elif re.match(r'\w\d\d\w\d\/\d+:',lista[i]):
- lista[i]='???'+lista[i]
- df=pd.DataFrame({'A':lista,'B':listb})
- df.to_excel('result.xlsx',index=False)
复制代码
结果 |
|