python读取txt，处理为excel格式【利用pandas数据处理】

应用场景：读取txt文件，处理存储为excel格式

1.数据准备 data.txt

{specid:40611, phone_sptd_24:-100}
{specid:32427, phone_sptd_24:-100, area_180:1, area_1:1}
{ts:1565573013137, ip_iii_29:-100}
{ phone_sptd_24:-100}
{specid:40192, phone_sptd_24:-100,00}
{specid:40611, phone_sptd_24:0.0}

2.使用python对txt文件进行格式化处理

import pandas as pd
data = []
title = []
info = []

with