Python 文件和数据格式化

最新推荐文章于 2024-06-20 21:50:00 发布

Bing_Lingbing

最新推荐文章于 2024-06-20 21:50:00 发布

阅读量430

点赞数

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

本文链接：https://blog.csdn.net/qq_41728719/article/details/109997912

版权

Python 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

Python数据格式转换

1. WriteD2toCSV

fr = open("./资源/price2016.csv", "r")
fw = open("./资源/pirce2016out.csv", "w")
ls = []
for line in fr:
    line = line.replace("\n", "")
    ls.append(line.split(","))
for i in range(len(ls)):
    for j in range(len(ls[i])):
        if ls[i][j].replace(".", "").isnumeric():
            ls[i][j] = "{:.2}%".format(float(ls[i][j])/100)
for row in ls:
    print(row)
    fw.write(",".join(row)+"\n")
fr.close()
fw.close()

['城市', '环比', '同比', '定基']
['北京', '1.0%', '1.2%', '1.2%']
['上海', '1.0%', '1.3%', '1.3%']
['广州', '1.0%', '1.2%', '1.2%']
['深圳', '1.0%', '1.4%', '1.5%']
['沈阳', '1.0%', '1.0%', '1.0%']

2. csv2html

seg1 = '''
<!DOCTOYPE HTML>\n<html>\n<body>\n<meta charset = gb2312>
<h2 align = center>2016年7月部分大中城市新建住宅价格指数</h2>
<table border='1' align = "center" width = "70%">
<tr bgcolor = 'orange'>\n'''
seg2 = "</tr>\n"
seg3 = "</table>\n</body>\n</html>"
def fill_data(locls):
    seg = '<tr><td align = "center">{}</td><td align = "center">\
    {}</td><td align = "center">{}</td><td align = "center">\
    {}</td></tr>\n'.format(*locls)
    return seg
fr = open("./资源/price2016.csv","r")
ls = []
for line in fr:
    line = line.replace("\n","")
    ls.append(line.split(","))
fr.close()
fw = open("./资源/pirce2016.html","w")
fw.write(seg1)
fw.write('<th width = "25%">{}</th>\n<th width = "25%">{}</th>\n<th width = "25%">{}</th>\n<th width = "25%">{}</th>\n'.format(*ls[0]))
fw.write(seg2)
for i in range(len(ls)-1):
    fw.write(fill_data(ls[i+1]))
fw.write(seg3)
fw.close()

在这里插入图片描述

3. csv2json

import json
fr = open("./资源/price2016.csv", "r")
ls = []
for line in fr:
    line = line.replace("\n", "")
    ls.append(line.split(","))
fr.close()
fw = open("./资源/price2016.json", "w")
for i in range(1, len(ls)):
    ls[i] = dict(zip(ls[0], ls[i]))
json.dump(ls[1:], fw, sort_keys=True, indent=4, ensure_ascii = False)
fw.close()

在这里插入图片描述

4. json2csv

import json
fr = open("./资源/price2016.json", "r")
ls = json.load(fr)
data = [list(ls[0].keys())]
for item in ls:
    data.append(list(item.values()))
fr.close()
fw = open("./资源/price2016_from_json.csv", "w")
for item in data:
    fw.write(",".join(item)+"\n")
fw.close()

在这里插入图片描述

Bing_Lingbing

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
Python 文件和数据格式化

Python数据格式转换1. WriteD2toCSV2. csv2html3. csv2json4. json2csv1. WriteD2toCSVfr = open("./资源/price2016.csv", "r")fw = open("./资源/pirce2016out.csv", "w")ls = []for line in fr: line = line.replace("\n", "") ls.append(line.split(","))for i in rang
复制链接

扫一扫

专栏目录