如何从github解析csv? [英] how to parse csv from github?
本文介绍了如何从github解析csv?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
jQuery.ajax({
url: "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Confirmed.csv",
type: 'get',
dataType: 'json',
success: function(data) {
console.log(data);
},
error: function(jqXHR, textStatus, errorThrow){
alert("Error: " + jqXHR['responseText']);
}
});
我需要将输出格式化为json,但这会出错,基本上是试图解析此
更新
他们更改了链接
解决方案
您必须将dataType
用作text
,然后使用double for循环运行split
,以将数据作为JS对象数组获得:/p>
jQuery.ajax({
url: "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Confirmed.csv",
type: 'get',
dataType: 'text',
success: function(data) {
let lines = data.split('\n');
let fields = lines[0].split(',');
let output = [];
for(let i = 1; i < lines.length; i++){
let current = lines[i].split(',');
let doc = {};
for(let j = 0; j < fields.length; j++){
doc[fields[j]] = current[j];
}
output.push(doc);
}
console.log(output);
},
error: function(jqXHR, textStatus, errorThrow){
console.log(textStatus);
}
});
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
jQuery.ajax({
url: "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Confirmed.csv",
type: 'get',
dataType: 'json',
success: function(data) {
console.log(data);
},
error: function(jqXHR, textStatus, errorThrow){
alert("Error: " + jqXHR['responseText']);
}
});
I need the output as formatted json but It's going to error, basically trying to parse this
UPDATE
They've changed the link
解决方案
You have to use dataType
as text
and then run split
with double for loop to get the data as an array of JS objects:
jQuery.ajax({
url: "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Confirmed.csv",
type: 'get',
dataType: 'text',
success: function(data) {
let lines = data.split('\n');
let fields = lines[0].split(',');
let output = [];
for(let i = 1; i < lines.length; i++){
let current = lines[i].split(',');
let doc = {};
for(let j = 0; j < fields.length; j++){
doc[fields[j]] = current[j];
}
output.push(doc);
}
console.log(output);
},
error: function(jqXHR, textStatus, errorThrow){
console.log(textStatus);
}
});
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
这篇关于如何从github解析csv?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文