首页 / JAVASCRIPT / javascript – 将json转换为csv格式

javascript – 将json转换为csv格式

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了javascript – 将json转换为csv格式，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含8851字，纯文字阅读大概需要13分钟。

内容图文

我尝试使用json格式的文件作为输入.这是一个示例数据片段.

[
{
id: 1671349531,
name: "A Wild Restaurant Expansion",
blurb: "We are looking to expand from our current location to a new and better facility. One that will be available for our our followers!",
goal: 17000,
pledged: 0,
state: "live",
slug: "a-wild-restaurant-expansion",
disable_communication: false,
country: "US",
currency: "USD",
currency_symbol: "$",
currency_trailing_code: true,
deadline: 1425185940,
state_changed_at: 1422373209,
created_at: 1422141288,
launched_at: 1422373209,
backers_count: 0,
photo: {
full: "https://s3.amazonaws.com/ksr/projects/1619167/photo-full.jpg?1422144440",
ed: "https://s3.amazonaws.com/ksr/projects/1619167/photo-ed.jpg?1422144440",
med: "https://s3.amazonaws.com/ksr/projects/1619167/photo-med.jpg?1422144440",
little: "https://s3.amazonaws.com/ksr/projects/1619167/photo-little.jpg?1422144440",
small: "https://s3.amazonaws.com/ksr/projects/1619167/photo-small.jpg?1422144440",
thumb: "https://s3.amazonaws.com/ksr/projects/1619167/photo-thumb.jpg?1422144440",
1024x768: "https://s3.amazonaws.com/ksr/projects/1619167/photo-1024x768.jpg?1422144440",
1536x1152: "https://s3.amazonaws.com/ksr/projects/1619167/photo-1536x1152.jpg?1422144440"
},
creator: {
id: 602131664,
name: "Chef James Nelson",
avatar: {
thumb: "https://s3.amazonaws.com/ksr/avatars/13830182/logo3.thumb.jpg?1422143536",
small: "https://s3.amazonaws.com/ksr/avatars/13830182/logo3.small.jpg?1422143536",
medium: "https://s3.amazonaws.com/ksr/avatars/13830182/logo3.medium.jpg?1422143536"
},
urls: {
web: {
user: "https://www.kickstarter.com/profile/602131664"
},
api: {
user: "https://api.kickstarter.com/v1/users/602131664?signature=1422460143.21cd79c238aeae43e8a4311c18bf8e8cd2c3a39a"
}
}
},
location: {
id: 2433186,
name: "Kissimmee",
slug: "kissimmee-fl",
short_name: "Kissimmee, FL",
displayable_name: "Kissimmee, FL",
country: "US",
state: "FL",
type: "Town",
is_root: false,
urls: {
web: {
discover: "https://www.kickstarter.com/discover/places/kissimmee-fl",
location: "https://www.kickstarter.com/locations/kissimmee-fl"
},
api: {
nearby_projects: "https://api.kickstarter.com/v1/discover?signature=1422447847.04d19a9efbe31a0d300969276d5d6f5ffa88a776&woe_id=2433186"
}
}
},
category: {
id: 312,
name: "Restaurants",
slug: "food/restaurants",
position: 9,
parent_id: 10,
urls: {
web: {
discover: "http://www.kickstarter.com/discover/categories/food/restaurants"
}
}
},
urls: {
web: {
project: "https://www.kickstarter.com/projects/602131664/a-wild-restaurant-expansion?ref=newest",
rewards: "https://www.kickstarter.com/projects/602131664/a-wild-restaurant-expansion/rewards"
}
}
},
{
id: 267033207,
name: "The Razors Edge ~ (based on the book Giggling in Fairmont).",
blurb: "An indie film to follow up on the recently published book. In it's first few weeks of release it has taken a strong grip on the world.",
goal: 5000,
pledged: 0,
state: "live",
slug: "the-razors-edge-based-on-the-book-giggling-in-fair",
disable_communication: false,
country: "US",
currency: "USD",
currency_symbol: "$",
currency_trailing_code: true,
deadline: 1424964564,
state_changed_at: 1422372564,
created_at: 1421465861,
launched_at: 1422372564,
backers_count: 0,
photo: {
full: "https://s3.amazonaws.com/ksr/projects/1599522/photo-full.jpg?1421465884",
ed: "https://s3.amazonaws.com/ksr/projects/1599522/photo-ed.jpg?1421465884",
med: "https://s3.amazonaws.com/ksr/projects/1599522/photo-med.jpg?1421465884",
little: "https://s3.amazonaws.com/ksr/projects/1599522/photo-little.jpg?1421465884",
small: "https://s3.amazonaws.com/ksr/projects/1599522/photo-small.jpg?1421465884",
thumb: "https://s3.amazonaws.com/ksr/projects/1599522/photo-thumb.jpg?1421465884",
1024x768: "https://s3.amazonaws.com/ksr/projects/1599522/photo-1024x768.jpg?1421465884",
1536x1152: "https://s3.amazonaws.com/ksr/projects/1599522/photo-1536x1152.jpg?1421465884"
},
creator: {
id: 198971258,
name: "Jesse Gerken",
avatar: {
thumb: "https://s3.amazonaws.com/ksr/avatars/12370207/author_pic.thumb.jpg?1411309933",
small: "https://s3.amazonaws.com/ksr/avatars/12370207/author_pic.small.jpg?1411309933",
medium: "https://s3.amazonaws.com/ksr/avatars/12370207/author_pic.medium.jpg?1411309933"
},
urls: {
web: {
user: "https://www.kickstarter.com/profile/198971258"
},
api: {
user: "https://api.kickstarter.com/v1/users/198971258?signature=1422460143.dd7e5606db2806a10e516e1def16575c3aae41e1"
}
}
},
location: {
id: 2401584,
name: "Fairmont",
slug: "fairmont-wv",
short_name: "Fairmont, WV",
displayable_name: "Fairmont, WV",
country: "US",
state: "WV",
type: "Town",
is_root: false,
urls: {
web: {
discover: "https://www.kickstarter.com/discover/places/fairmont-wv",
location: "https://www.kickstarter.com/locations/fairmont-wv"
},
api: {
nearby_projects: "https://api.kickstarter.com/v1/discover?signature=1422448035.58aff9025d72453411d574df4707a417d4b7b970&woe_id=2401584"
}
}
},
category: {
id: 297,
name: "Horror",
slug: "film & video/horror",
position: 10,
parent_id: 11,
urls: {
web: {
discover: "http://www.kickstarter.com/discover/categories/film%20&%20video/horror"
}
}
},
urls: {
web: {
project: "https://www.kickstarter.com/projects/198971258/the-razors-edge-based-on-the-book-giggling-in-fair?ref=newest",
rewards: "https://www.kickstarter.com/projects/198971258/the-razors-edge-based-on-the-book-giggling-in-fair/rewards"
}
}
},
{
id: 1791731386,
name: "PulseAuction",
blurb: "Seeking promotional funding for PulseAuction.com - a PATENTED online auction site. We've banished Per-Bid Fees! Join The Revolution.",
goal: 7000,
pledged: 0,
state: "live",
slug: "pulseauction",
disable_communication: false,
country: "US",
currency: "USD",
currency_symbol: "$",
currency_trailing_code: true,
deadline: 1424964553,
state_changed_at: 1422372553,
created_at: 1419635170,
launched_at: 1422372553,
backers_count: 0,
photo: {
full: "https://s3.amazonaws.com/ksr/projects/1559949/photo-full.jpg?1421250474",
ed: "https://s3.amazonaws.com/ksr/projects/1559949/photo-ed.jpg?1421250474",
med: "https://s3.amazonaws.com/ksr/projects/1559949/photo-med.jpg?1421250474",
little: "https://s3.amazonaws.com/ksr/projects/1559949/photo-little.jpg?1421250474",
small: "https://s3.amazonaws.com/ksr/projects/1559949/photo-small.jpg?1421250474",
thumb: "https://s3.amazonaws.com/ksr/projects/1559949/photo-thumb.jpg?1421250474",
1024x768: "https://s3.amazonaws.com/ksr/projects/1559949/photo-1024x768.jpg?1421250474",
1536x1152: "https://s3.amazonaws.com/ksr/projects/1559949/photo-1536x1152.jpg?1421250474"
},
creator: {
id: 835111372,
name: "WW Pulse Inc. dba PulseAuction.com",
avatar: {
thumb: "https://s3.amazonaws.com/ksr/avatars/13524481/rick_head_shot_Cleaned.thumb.jpg?1420034475",
small: "https://s3.amazonaws.com/ksr/avatars/13524481/rick_head_shot_Cleaned.small.jpg?1420034475",
medium: "https://s3.amazonaws.com/ksr/avatars/13524481/rick_head_shot_Cleaned.medium.jpg?1420034475"
},
urls: {
web: {
user: "https://www.kickstarter.com/profile/835111372"
},
api: {
user: "https://api.kickstarter.com/v1/users/835111372?signature=1422460143.e75af1301e433dc803f3f929249d0c45ce3eaebd"
}
}
},
location: {
id: 23689683,
name: "South Florida",
slug: "south-florida-fl",
short_name: "South Florida, FL",
displayable_name: "South Florida, FL",
country: "US",
state: "FL",
type: "Town",
is_root: false,
urls: {
web: {
discover: "https://www.kickstarter.com/discover/places/south-florida-fl",
location: "https://www.kickstarter.com/locations/south-florida-fl"
},
api: {
nearby_projects: "https://api.kickstarter.com/v1/discover?signature=1422447780.143e234a4af62e7d8366fad3b204044920bcbc66&woe_id=23689683"
}
}
},
category: {
id: 342,
name: "Web",
slug: "technology/web",
position: 15,
parent_id: 16,
urls: {
web: {
discover: "http://www.kickstarter.com/discover/categories/technology/web"
}
}
},
urls: {
web: {
project: "https://www.kickstarter.com/projects/835111372/pulseauction?ref=newest",
rewards: "https://www.kickstarter.com/projects/835111372/pulseauction/rewards"
}
}
}

可以在r中使用这种复杂的json格式制作一个csv,以便处理数据更顺畅吗？

例如,有以下基本类别：
基本信息
照片
创造者
位置
类别
网址

是否可以制作一个包含子类别类别的csv文件,如basic_information.id,creator.id等？

解决方法:

当我在研究你的答案时,我在评论中发布了几个链接,但现在我非常确信this is the way to do it.

安装节点包,然后将以下内容与您自己的json字符串一起使用(我刚从上面的链接中解除了它).

var converter = require('json-2-csv');

var documents = [
    {
        Make: 'Nissan',
        Model: 'Murano',
        Year: '2013',
        Specifications: {
            Mileage: '7106',
            Trim: 'S AWD'
        }
    },
    {
        Make: 'BMW',
        Model: 'X5',
        Year: '2014',
        Specifications: {
            Mileage: '3287',
            Trim: 'M'
        }
    }
];

var json2csvCallback = function (err, csv) {
    if (err) throw err;
    console.log(csv);
};

converter.json2csv(documents, json2csvCallback);

这将返回：

Make,Model,Year,Specifications.Mileage,Specifications.Trim
Nissan,Murano,2013,7106,S AWD
BMW,X5,2014,3287,M

内容总结

以上是互联网集市为您收集整理的javascript – 将json转换为csv格式全部内容，希望文章能够帮你解决javascript – 将json转换为csv格式所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/703051.html

来源：【匿名】

【上一篇】javascript – 根据另一个下拉选项过滤下拉列表【下一篇】javascript 怎么调用php方法

更多 ►

【javascript – 将json转换为csv格式】教程文章相关的互联网学习教程文章

JavaScript 字符串转数字（整数，浮点数，进制转换）【代码】

下面是使用parseFloat()方法的示例： parseFloat("1234blue"); //returns 1234.0 parseFloat("0xA"); //returns NaN parseFloat("22.5"); //returns 22.5 parseFloat("22.34.5"); //returns 22.34 parseFloat("0908"); //returns 908 parseFloat("blue"); //returns NaNparseInt进行转换时，将字符串转成相应的整数。浮点数以后的数字都不要了。 parseInt("1234blue"); //returns 1234 parseInt("22.5"); //...

javascript之类型转换

JavaScript是一种无类型语言，但同时JavaScript提供了一种灵活的自动类型转换的处理方式。基本规则是，如果某个类型的值用于需要其他类型的值的环境中，JavaScript就自动将这个值转换成所需要的类型。以下列出JavaScript一种特定类型用于一种特定环境下时所执行的转换。类型转换　值　　字符串　　　数字　　　布尔值　　　　　对象未定义　 "undefined" 　 NaN 　　　 false 　　　　　 Errornull 　 "nu...

JavaScript学习笔记（五）——类型、转换、相等、字符串【代码】

第六章类型相等转换等一、类型1 typeof();typeof是一个内置的JavaScript运算符，可用于探测其操作数的类型。例： 1 <script language="JavaScript" type="text/JavaScript">2 3var test1="abcdef"; //string 4 5var test2=123; //number 6 7var test3=true; //boolean 8 9var test4={...

JavaScript将输入的数字金额转换成对应的中文大写金额【代码】【图】

// 将输入的数字金额转换成对应的中文大写金额 // idNumber输入的数字金额，idCHN输出的中文大写金额function TransformNumberIntoCHN(idNumber, idCHN) {var number = document.getElementById(idNumber).value;if (!/^(0|[1-9]\d*)(\.\d{1,2})?$/.test(number)) {document.getElementById(idCHN).value = "";document.getElementById(idNumber).value = "";returnfalse;}var unit = "仟佰拾亿仟佰拾万仟佰拾元角分", str = "";nu...

Javascript类型转换的规则【图】

数据类型：原文：http://www.cnblogs.com/PowellZhao/p/5815738.html

javascript Date与string之间的转换

JavaScript 方法date to stringlet s = new Date().toLocaleString();console/log(s) ====string to datevar date = new Date("2018-9-21 14:58:43");//就是这么简单原文：https://www.cnblogs.com/javalinux/p/14592665.html

js 简繁转换【代码】【图】

js 简繁转换 1function copy(ob) {2var obj=findObj(ob); if (obj) {3 obj.select();js=obj.createTextRange();js.execCommand("Copy");}4 }5 6function paste(ob) {7var obj=findObj(ob); if (obj) {8 obj.select();js=obj.createTextRange();js.execCommand("Paste");}9 } 1011function cut(ob) { 12var obj=findObj(ob); if (obj) { 13 obj.select();js=obj.createTextRange();js.execCommand("...

黑马程序员_JavaScript变量转换和Jquery对象的转换

在实际编程过程中，有很多对字符串进行判断、拆分、比较、转换类型、校验等操作，下面我会总结下JavaScript变量转换和Jquery对象的转换。1.JavaScript 变量转换及字符串操作1.字符串变成int类型使用函数：parseInt();使用此函数，可将string类型变量转换为int类型。而且只能够对string类型变量使用。如果待转换string类型变量无发转换为int类型时，函数会返回NaN。实例如下：var v_Num = parseInt(‘256ok‘); // 赋值为 256var v_...

Javascript中的类型转换【代码】

第一部分：Javascript中类型转换的常用场景1.在使用运算符进行操作时，常用的运算符就是 + 运算符使用+运算符做运算时，由于只有字符串和数字才能够使用+运算符，那么使用时，会根据情况，将不同的数据类型，转换为字符串或者数字当+运算符左边的数据类型是数字时， 1 + null === 1 // 这里将null转为了数字0 1 + undefined // NaN undefined无法转为数字，那么就会 NaN 1 + NaN // NaN 注意的是 NaN === NaN 以及 NaN == ...

JavaScript数据容量单位转换（KB B MB GB....）【代码】

数据容量单位转换（KB B MB GB....）function bytesToSize(bytes) { if (bytes === 0) return '0 B'; var k = 1000, // or 1024 sizes = ['B', 'KB', 'MB', 'GB', 'TB', 'PB', 'EB', 'ZB', 'YB'], i = Math.floor(Math.log(bytes) / Math.log(k)); return (bytes / Math.pow(k, i)).toPrecision(3) + ' ' + sizes[i]; }原文：http://blog.51cto.com/dd118/2136481

javascript数据类型判断及数据隐式和显示转换【代码】

数据类型判断数据类型有 number string boolean null undefined function object 这些，那如何去判断数据对应的是哪种类型呢typeof可以判断对应数据类型写法： typeof data 或者 typeof(data) ，一般习惯写后面这种返回值有 number string boolean object undefined function 这些代码如下：console.log(typeof(123)) //number console.log(typeof(‘true‘)) //string console.log(typeof(true)) //boolean console.log(...

细说JavaScript数据类型及转换【代码】

细说JavaScript数据类型及转换JavaScript数据类型 1.Boolean（布尔）布尔：（值类型）var b1=true;//布尔类型 2.Number（数字）数值：（值类型）var n1=3.1415926;//数值类型 n1.toFixed(3);//四舍五入保留3位小数。 3.String（字符串）var s1=‘hello‘;//字符串类型字符串：（值类型，字符串不可变特性） 4.Undefined（未定义） undefined属于值类型，与其他值计算得到的结果不是我们想要的，但与数据库中的null稍有区别，比如...

带你玩转JavaScript中的隐式强制类型转换【代码】

正题开始前我想先抛出一个问题，==和===有什么区别？可能一般人会想，不就是后者除了比较值相等之外还会比较类型是否相等嘛，有什么好问的，谁不知道？！但是这样说还不够准确，两者的真正区别其实是==在比较的时候允许做强制类型转换，而===不允许。好了终于引出了今天的重点，我们平时肯定遇到过强制类型转换的时候，死活想不通为什么要这样转换（为什么这两个相等）的情况。那么下面我就以==为例，来说明一下其中强制类型转换的...

Razor 将C#对象转换成Javascript对象， json还原被转码的字符 &quot·· HTML转义符【代码】

Razor 将C#对象转换成Javascript对象在Razor中使用Json字符串，特殊字符被自动转义（如：\"->"）@{var jsonStr = Html.Raw(JsonUtil.ToJson(VieBag.data)); } <script> var data = JSON.parse(@jsonStr); </script> ViewBag.Data = list;<script type="text/javascript">//将数据对象转换为 JSON 格式，是为了在网页中通过使用JS将数据作为文本进行处理var data = @Html.Raw(Json.Encode(ViewBag.Data));for (var i = 0; i < ...

javaScript转换日期合格式【代码】【图】

javascript如何将时间日期转换为Date对象:有时候需要讲一个字符串型的时间日期转换为Date时间对象，下面就通过一个简单的实例提供一种解决方案，当然也是一种思路，可以进行一定的变通，以达到举一反三的效果。例如这里有一个时间日期字符串:2013-9-15 8：25：30下面就将它们转换为时间对象。代码如下:var timeStr="2013-9-15 8:25:30"; var strArray=timeStr.split(" "); var strDate=strArray[0].split("-"); var strTime=strA...

首页 / JAVASCRIPT / javascript – 将json转换为csv格式

javascript – 将json转换为csv格式

内容导读

内容图文

内容总结

内容备注

内容手机端

【javascript – 将json转换为csv格式】教程文章相关的互联网学习教程文章

JAVASCRIPT - 相关标签

JSON - 相关标签

格式 - 相关标签

JAVASCRIPT - 技术教程分类

JAVASCRIPT - 最新教程

JAVASCRIPT - 最热教程