Python读取tsv文件数据
生活随笔
收集整理的這篇文章主要介紹了
Python读取tsv文件数据
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
#!/usr/bin/env python3
# -*- coding: utf-8 -*-"""
create_author : 蛙鱖雞鸛貍猿
create_time : 2019-03-19
program : *_* .tsv file handler *_*
"""import codecsclass TSV(object):""".tsv file's handler."""def __init__(self, file):"""TSV init.:param file: .tsv file to handle."""self.file = filedef __repr__(self):return "File {file} under handling......".format(file=self.file)def tsv(self):""".tsv file's column definition and data check.:return: List.lines data from [file] row by row in dict format."""with codecs.open(self.file, 'r', "utf-8") as f:line = f.readline()data = []head = []while line:if line.isspace():line = f.readline()continueelif not line.isspace():# to be compatible between OShead = line.rstrip("\r\n").split('\t')line = f.readline()breakwhile line:if line.isspace():line = f.readline()continueelif not line.isspace():body = line.rstrip("\r\n").split('\t')rows = zip(head, body)tsv_dic = {}for (head_sub, body_sub) in list(rows):tsv_dic[head_sub] = body_subdata.append(tsv_dic)line = f.readline()return dataif __name__ == "__main__":with codecs.open("tsv", 'w', "utf-8") as f:rows = """Id\tContent1\tContent12\tContent23\tContent34\tContent41024\tContent1024"""f.writelines(rows.replace(' ', ''))TSV_Tester = TSV(file="tsv")print(TSV_Tester.tsv())
?
總結
以上是生活随笔為你收集整理的Python读取tsv文件数据的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: SpringBoot在使用测试的时候是否
- 下一篇: 在线TSV转纯文本工具