Python文件格式转换

 一.csv转geojson

1.将带有点坐标的 csv 转 geojson, 不带其他属性

"""
将带有点坐标的 csv 转 geojson, 不带其他属性
"""
import csv


csv_file = open('E:/test.csv', encoding='gbk')
csv_reader = csv.reader(csv_file)

geojson = '{"type":"FeatureCollection","features":['
for index, row in enumerate(csv_reader):
    print(row[0])
    geojson += '{"geometry":{"coordinates":[%f,%f],"type":"Point"},"properties":{},"type":"Feature"},' % (float(row[0]),float(row[1]))


geojson = geojson[:-1] + ']}'
links_file = open('test.geojson', 'w')
links_file.write(geojson)

2.将带有点坐标的 csv 转 geojson, 带其他属性

"""
将带有点坐标的 csv 转 geojson, 带其他属性
"""
import csv
import json

csv_file = open('test.csv', encoding='utf8')
csv_reader = csv.reader(csv_file)

geojson = '{"type":"FeatureCollection","features":['

lon_index = 0
lat_index = 1
for index, row in enumerate(csv_reader):
    if index == 0:
        header = row
        continue

    property_dict = {}
    for indexJ, j in enumerate(row):
        if indexJ == lon_index or indexJ == lat_index:
            continue
        property_dict[header[indexJ]] = j

    geojson += '{"geometry":{"coordinates":[%f,%f],"type":"Point"},"properties":%s,"type":"Feature"},' \
               % (float(row[lon_index]), float(row[lat_index]), json.dumps(property_dict, ensure_ascii=False))


geojson = geojson[:-1] + ']}'
links_file = open('test.geojson', 'w', encoding='utf8')
links_file.write(geojson)

二.geojson转geojson

geojson转geojson, 并加上一个随机数

"""
geojson转geojson, 并加上一个随机数
"""
import json
import random

file_object = open("D:/random_points.geojson", "r+", encoding='utf8')
file_data_str = file_object.read()
file_object.close()

origin_data = json.loads(file_data_str)

geojson = '{"type":"FeatureCollection","features":['
for i in origin_data["features"]:
    properties = i["properties"]
    properties["counts"] = random.randint(0, 20000)
    geojson += '{"geometry":{"coordinates":%s,"type":"Point"},"properties":%s,"type":"Feature"},' % (
        json.dumps(i["geometry"]["coordinates"]), json.dumps(i["properties"], ensure_ascii=False))

geojson = geojson[:-1] + ']}'
links_file = open('D:/random_points_value.geojson', 'w', encoding='utf8')
links_file.write(geojson)

三.csv转json

"""
将 csv 转为 json
"""
import csv
import json

csv_file = open('F:/test.csv', encoding='utf8')
csv_reader = csv.reader(csv_file)

list_data = []

header = []
for index, row in enumerate(csv_reader):
    if index == 0:
        header = row
    else:
        one_json = {}
        for index_j, j in enumerate(row):
            one_json[header[index_j]] = row[index_j]
        list_data.append(one_json)


json_data = {"data": list_data}

json_file = open('F:/test.json', 'w', encoding='utf8')
json_file.write(json.dumps(json_data, ensure_ascii=False))

 四.json转geojson

1.读取含有点坐标的json文件, 并转为geojson

"""
读取含有点坐标的json文件, 并转为geojson
"""
import json

file_object = open("D:/收费员位置高德.json", "r+", encoding='utf8')
file_data_str = file_object.read()
file_object.close()

origin_data = json.loads(file_data_str)

geojson = '{"type":"FeatureCollection","features":['
for i in origin_data["data"]:
    geojson += '{"geometry":{"coordinates":[%s,%s],"type":"Point"},"properties":{},"type":"Feature"},' % (
            i["longitude"], i["latitude"])

geojson = geojson[:-1] + ']}'
links_file = open('D:/收费员位置高德.geojson', 'w', encoding='utf8')
links_file.write(geojson)

2.逐行读取含有点坐标的json文件, 并逐行写入geojson

"""
逐行读取含有点坐标的json文件, 并逐行写入geojson中
"""
import json

json_str = ""
for line in open("E:/income_province_evsmc.json"):
    json_str += line

json_dict = json.loads(json_str)

file_writer = open("E:/points.geojson", "a+")

geojson = '{"type":"FeatureCollection","features":['
file_writer.write(geojson)
for index, i in enumerate(json_dict["result"]):

    coords = "%f,%f" % (i["lon"], i["lat"])
    file_writer.write('{"geometry": {"type": "Point", "coordinates": [%s]},"properties": {}}' % coords)

    if index != len(json_dict["result"]) - 1:
        file_writer.write(',')

file_writer.write(']}')

 五.文本符处理

1.读取csv,将换行符处理后再插入另一个csv

"""
读取csv,将换行符处理后再插入另一个csv
"""

import csv

csv_file = open("test.csv", encoding='utf-8')
csv_reader_lines = csv.reader(csv_file)

file_object = open("abc.csv", 'w', newline='', encoding='utf-8')
writer = csv.writer(file_object)

for index, i in enumerate(csv_reader_lines):
    i[4] = i[4].replace(" ", "").replace("\r", "").replace("\n", "")
    writer.writerow(i)

file_object.close()

2.去除txt文件中的各种转义符

"""
去除txt文件中的各种转义符
"""
read_object = open("polygon.geojson", "r+", encoding="utf8")
file_data_str = read_object.read()
read_object.close()


data_str = file_data_str.replace("\n", "").replace("\r", "").replace(" ", "").replace(" ", "")
txt_file = open("polygon_format.geojson", 'w', encoding="utf8")
txt_file.write(data_str)
txt_file.close()