python的一道小习题

最新推荐文章于 2018-12-25 11:45:52 发布

侠之大者为国为民

最新推荐文章于 2018-12-25 11:45:52 发布

阅读量441

点赞数

分类专栏： python 文章标签： python

本文链接：https://blog.csdn.net/sofeien/article/details/49127169

版权

python 专栏收录该内容

68 篇文章 1 订阅

订阅专栏

将CSV格式数据转换成网页表格

#!/usr/bin/env python3
# coding=utf-8

with open("test.txt","r") as f:
    txt = f.read()

lines=[]
words=[]
in_word = False
temp_word = ""
for c in txt:
    if c==',' and not in_word:
        if temp_word[0]=='s':
            words.append(temp_word[1:])
        else:
            words.append(int(temp_word))
        temp_word=""
        continue
    if c=='"' and not in_word:
        in_word = True
        temp_word += 's'
        continue
    if c=='"' and in_word:
        in_word = False
        continue
    if c=='\n':
        if temp_word[0]=='s':
            words.append(temp_word[1:])
        else:
            words.append(int(temp_word))
        temp_word=""
        lines.append(words)
        words=[]
        in_word=False
        continue
    temp_word += c
if temp_word:
    if temp_word[0]=='s':
        words.append(temp_word[1:])
    else:
        words.append(int(temp_word))
    lines.append(words)

with open("make_html.html","w+") as fw:
    fw.write(r"<html>")
    fw.write(r"<body>")
    fw.write(r"<h1>数据提取</h1>")
    fw.write(r'<table border="1">')
    line_count=0
    for line in lines:
        fw.write(r"<tr>")
        fw.write(r'<th bgcolor="green">{0!r}</th>'.format(line[0]))
        for word in line[1:]:
            if line_count%2==0:
                fw.write(r'<td bgcolor="yellow">{!r}</td>'.format(word))
            else:
                fw.write(r'<td>{!r}</td>'.format(word))
        fw.write(r"</tr>")
        line_count += 1
    fw.write(r"</table>")
    fw.write(r"</body>")
    fw.write(r"</html>")

侠之大者为国为民

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
python的一道小习题

将CSV格式数据转换成网页表格#!/usr/bin/env python3# coding=utf-8with open("test.txt","r") as f: txt = f.read()lines=[]words=[]in_word = Falsetemp_word = ""for c in txt: if c==',' and not in_word
复制链接

扫一扫