movieprodw
asked on
Javascript d3, get first row only
Hello,
I have the following code and I would like to get just the titles not the other values.
Can you please let me know how to edit this to work OR if there is a better way.
Please note that the csv delimiter is different in a couple of my files.
Thank you!
Matt
I have the following code and I would like to get just the titles not the other values.
Can you please let me know how to edit this to work OR if there is a better way.
Please note that the csv delimiter is different in a couple of my files.
<script src="http://d3js.org/d3.v3.min.js" charset="utf-8"></script>
<script type="text/javascript">
/*
Example cars.csv:
Year;Make;Model;Length
1997,Ford,E350,2.34
2000,Mercury,Cougar,2.38
*/
d3.csv('cars.csv', function(csv) {
csv.forEach(function(row) {
document.write(Object.keys(row));
});
});
</script>Thank you!
Matt
ASKER
Sorry, the column names
Then what is wrong with what you have?
If you mean you have semicolons then use
https://github.com/mbostock/dsv
If you mean you have semicolons then use
https://github.com/mbostock/dsv
ASKER
Well I JUST want the first row with the names, I do not want it to repeat for every row, I am good at php but not javascript.
<script src="http://d3js.org/d3.v3.min.js" charset="utf-8"></script>
<script type="text/javascript">
d3.csv('cars.csv', function(data){
d3.keys(data[0]).forEach(function(item){
console.log(item)
})
});
</script>ASKER
Hello Gary,
That worked.
I am confused because the page never stops loading, any ideas?
That worked.
I am confused because the page never stops loading, any ideas?
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>RSS Feed Manager</title>
<script src="http://d3js.org/d3.v3.min.js" charset="utf-8"></script>
</head>
<body>
<script type="text/javascript">
d3.csv('cars.csv', function(data){
d3.keys(data[0]).forEach(function(item){
document.write(item);
})
});
</script>
</body>
</html>ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You are the man!
The code works but the titles should be seperated by commas.