我有一個包含這樣資料的 csv 檔案
PassengerId,Pclass,Name,Sex,Age,SibSp,Parch,Ticket,Fare,Cabin,Embarked
111,1,"Ken, Mr. James",male,34.5,0,0,330911,7.8292,,A
112,2,"Will, Mrs. James",female,47,1,0,363272,7,,B
and so on
我想計算 csv 檔案中這些名字中有多少包括 Mr 和 Mrs 以及其他
并使用“性別”列我想列印男性和女性乘客的數量。
我已經嘗試過了，但它只是列印每一行，夫人為 0，先生為 1，而不是給我先生的姓名計數。
我不知道如何遍歷 csv 資料，有人可以為此添加代碼部分。謝謝。
<script src='https://d3js.org/d3.v7.min.js'></script>
<script>
let mycsv = ' some file name';
d3.csv(mycsv, function(data) {
let count = 0;
var theWord = "Mr";
if (data.Name.includes(theWord))
{
count ;
}
console.log(count);
});
</script>
uj5u.com熱心網友回復：
您需要
then從版本 5let mycsv = 'example.csv'; d3.csv(mycsv) .then(function(data) { /* process data */ })你需要回圈。
這可以通過reduce來完成：
https://plungjan.name/SO/d3csv/
const process = data => {
const counts = data.reduce((acc, { Name, Sex, Age }) => {
acc.mr = Name.toLowerCase().includes("mr.");
acc.mrs = Name.toLowerCase().includes("mrs.");
acc.male = Sex.toLowerCase() === "male";
acc.female = Sex.toLowerCase() === "female";
acc.age = Age
return acc;
}, { mr: 0, mrs: 0, male: 0, female: 0, age: 0 });
console.log("Total age",counts.age)
Object.entries(counts).forEach(([key,val]) => document.getElementById(key).textContent = val)
}
// uncomment when you want to read a file
// let mycsv = 'example.csv';
// d3.csv(mycsv)
//.then(function(data) {
process(data)
//})<script src='https://d3js.org/d3.v7.min.js'></script>
<script>
const data = d3.csvParse(`PassengerId,Pclass,Name,Sex,Age,SibSp,Parch,Ticket,Fare,Cabin,Embarked
111,1,"Ken, Mr. James",male,34.5,0,0,330911,7.8292,,A
112,2,"Will, Mrs. James",female,47,1,0,363272,7,,B`);
</script>
Mr: <span id="mr"></span><br/>
Mrs: <span id="mrs"></span><br/>
Male: <span id="male"></span><br/>
Female: <span id="female"></span><br/>
Sum of Ages <span id="age"></span><br/>如果您只想計算年齡在 30 歲以上的人：
const process = data => {
const ages = data.map(({Age}) => Age) // make sure it is a number
.filter(num => num > 30).length
console.log("Total of ppl with age above 30:",ages)
}
// uncomment when you want to read a file
// let mycsv = 'example.csv';
// d3.csv(mycsv)
//.then(function(data) {
process(data)
//})<script src='https://d3js.org/d3.v7.min.js'></script>
<script>
const data = d3.csvParse(`PassengerId,Pclass,Name,Sex,Age,SibSp,Parch,Ticket,Fare,Cabin,Embarked
111,1,"Ken, Mr. James",male,34.5,0,0,330911,7.8292,,A
112,2,"Will, Mrs. James",female,47,1,0,363272,7,,B`);
</script>轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/416240.html
標籤：