我是Python初学者,我需要读取一个txt文件,其中每一行都有列名,列是无序的,并且并非所有列都被告知。有没有办法用 Pandas 读取这种文件?
这是一个示例(3 行):
[email protected] /cdn-cgi/l/email-protection:{ssha}fiy9XI6d:created="1575487257" fwd="" spf_block="" quota="1024mb" full_name="Full Name" mailaccess="envia" mailstatus="cancelled"
[email protected] /cdn-cgi/l/email-protection:{ssha}Q0H90Rf9:created="1305323967" mailaccess="1" mailstatus="active" admin_access="" quota="" expire="0" full_name="Full Name" pais="CO"
[email protected] /cdn-cgi/l/email-protection:{ssha}sCPC3HOE:created="1550680636" fwd="" pass_question="" pass_answer="" disabled="Y" mailstatus="cancelled" full_name="Name"
您可以使用re
解析文件的模块。
例如:
import re
import pandas as pd
all_data = []
with open('<YOUR FILE>', 'r') as f_in:
for line in f_in:
m = re.search(r'^(.*?):(.*?):', line)
if not m:
continue
data = dict(re.findall(r'([^\s]+)="([^"]+)"', line.split(':', maxsplit=2)[-1]))
data['mail'] = m.group(1)
data['password'] = m.group(2)
all_data.append(data)
df = pd.DataFrame(all_data).fillna('')
print(df)
打印数据框:
created quota full_name mailaccess mailstatus mail password expire pais disabled
0 1575487257 1024mb Full Name envia cancelled [email protected] /cdn-cgi/l/email-protection {ssha}fiy9XI6d
1 1305323967 Full Name 1 active [email protected] /cdn-cgi/l/email-protection {ssha}Q0H90Rf9 0 CO
2 1550680636 Name cancelled [email protected] /cdn-cgi/l/email-protection {ssha}sCPC3HOE Y
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)