nodejs json csv 装换 生成 Python

#encoding=utf-8
import json
import csv


def csv_json():
    json_fp = open("data.json", "r",encoding='UTF-8')
    csv_fp = open("data.csv", "w",encoding='UTF-8')

    data_list = json.load(json_fp)

    sheet_title = data_list[0].keys()
    # sheet_title = {"姓名","年龄"}  # 将表头改为中文
    sheet_data = []
    for data in data_list:
        sheet_data.append(data.values())

    writer = csv.writer(csv_fp)

    writer.writerow(sheet_title)
    writer.writerows(sheet_data)

    json_fp.close()
    csv_fp.close()

if __name__ == "__main__":
    csv_json()

 

 

 

// demo.js
const { promises: { readFile, appendFile, mkdir } } = require('fs');

(async () => {
  // 创建模拟数据
  let list = []
  for (let i = 0; i < 10; i += 1) {
    list.push({
      id: i,
      name: '小明',
      age: 18,
      address: 'cccccccc',
      phone: '13313366789',
    })
  }
  /*
   * 生成表头，\ufeff 是防止乱码
   * csv中以 `,` 换列，`\n`换行
   */
  let title = Object.keys(list[1])
  let csvContent = '\ufeff' + title.join(',') + '\n'

  // 添加表体
  list.forEach((item, index) => {
    let c = Object.values(item).join(',') + '\n'
    csvContent += c
  })

  // 生成csv文件
  await appendFile('./data.csv', csvContent)

})()