All geek questions in one place

How to create a histogram with csv file

For my site I need to create a histogram with the following data: 90; 99; 87; 78; 89; 67; 85; 67; 85; one hundred;

These will be estimates of 100, and I would like to place each of them in a bar, next to each other. Do you know how I could do this with php (or javascript)?

I have an image for a line of my chart registered in graphbar.png and my csv file is called websitedvpt.csv

I searched this everywhere, but I really don’t understand how it works, can someone help me?

+4
source share
5 answers

D3.js + C3.js

D3.js C3.js. C3 - D3.

, :

HTML

<div id="chart"></div>

JS

var chart = c3.generate({
    data: {
        columns: [
            ['data1', 90, 99, 87, 78, 89, 67, 85, 67, 85, 100]
        ],
        type: 'bar'
    }
});

JSFIDDLE

D3.js + NVD3.js

NVD3.js - D3.js, C3.js. :

HTML

<div id='chart'>
  <svg style='height:500px'> </svg>
</div>

JS

nv.addGraph(function() {
  var chart = nv.models.discreteBarChart()
      .x(function(d) { return d.label })    //Specify the data accessors.
      .y(function(d) { return d.value })
      .staggerLabels(true)    //Too many bars and not enough room? Try staggering labels.
      .tooltips(false)        //Don't show tooltips
      .showValues(true)       //...instead, show the bar value right on top of each bar.
      .transitionDuration(350)
      ;

  d3.select('#chart svg')
      .datum(exampleData())
      .call(chart);

  nv.utils.windowResize(chart.update);

  return chart;
});

//Each bar represents a single discrete quantity.
function exampleData() {
 return  [ 
    {
      key: "Cumulative Return",
      values: [
        { 
          "label" : "A Label" ,
          "value" : 90
        } , 
        { 
          "label" : "B Label" , 
          "value" : 99
        } , 
        { 
          "label" : "C Label" , 
          "value" : 87
        } , 
        { 
          "label" : "D Label" , 
          "value" : 78
        } , 
        { 
          "label" : "E Label" ,
          "value" : 89
        } , 
        { 
          "label" : "F Label" , 
          "value" : 67
        } , 
        { 
          "label" : "G Label" , 
          "value" : 85
        } , 
        { 
          "label" : "H Label" , 
          "value" : 67
        }, 
        { 
          "label" : "I Label" , 
          "value" : 85
        } , 
        { 
          "label" : "J Label" , 
          "value" : 100
        }
      ]
    }
  ]
}

JSFIDDLE

jQuery Flot

jQuery.flot - jQuery, HTML Canvas.

:

JS

var d1 = [[1,90], [2,99], [3,87], [4,78], [5,89], [6,67], [7,85], [8,67], [9,85], [10,100]];

$(document).ready(function () {
    $.plot($("#placeholder"), [
        {
            data: d1,
            bars: {
                show: true
            }
        }
    ]);
});

HTML

<div id="placeholder"></div>

CSS

#placeholder {
    width: 450px;
    height: 200px;
}

JSFIDDLE

CSV

CSV- , .

+3

D3.JS . : http://bl.ocks.org/mbostock/3885304 - CSV , / . SVG , , , .

:

<!DOCTYPE html>
<meta charset="utf-8">
<style>

.bar {
  fill: steelblue;
}

.bar:hover {
  fill: brown;
}

.axis {
  font: 10px sans-serif;
}

.axis path,
.axis line {
  fill: none;
  stroke: #000;
  shape-rendering: crispEdges;
}

.x.axis path {
  display: none;
}

</style>
<body>
<script src="http://d3js.org/d3.v3.min.js"></script>
<script>

var margin = {top: 20, right: 20, bottom: 30, left: 40},
    width = 960 - margin.left - margin.right,
    height = 500 - margin.top - margin.bottom;

var x = d3.scale.ordinal()
    .rangeRoundBands([0, width], .1);

var y = d3.scale.linear()
    .range([height, 0]);

var xAxis = d3.svg.axis()
    .scale(x)
    .orient("bottom");

var yAxis = d3.svg.axis()
    .scale(y)
    .orient("left")
    .ticks(10, "%");

var svg = d3.select("body").append("svg")
    .attr("width", width + margin.left + margin.right)
    .attr("height", height + margin.top + margin.bottom)
  .append("g")
    .attr("transform", "translate(" + margin.left + "," + margin.top + ")");

d3.tsv("data.tsv", type, function(error, data) {
  x.domain(data.map(function(d) { return d.letter; }));
  y.domain([0, d3.max(data, function(d) { return d.frequency; })]);

  svg.append("g")
      .attr("class", "x axis")
      .attr("transform", "translate(0," + height + ")")
      .call(xAxis);

  svg.append("g")
      .attr("class", "y axis")
      .call(yAxis)
    .append("text")
      .attr("transform", "rotate(-90)")
      .attr("y", 6)
      .attr("dy", ".71em")
      .style("text-anchor", "end")
      .text("Frequency");

  svg.selectAll(".bar")
      .data(data)
    .enter().append("rect")
      .attr("class", "bar")
      .attr("x", function(d) { return x(d.letter); })
      .attr("width", x.rangeBand())
      .attr("y", function(d) { return y(d.frequency); })
      .attr("height", function(d) { return height - y(d.frequency); });

});

function type(d) {
  d.frequency = +d.frequency;
  return d;
}

</script>
+1

, , svg . , PHP php GD, php. , fgetcsv - http://php.net/manual/en/function.fgetcsv.php - , php .

, GD: http://www.phpbuilder.com/columns/nasser20030219.php3?page=2

, .

0

- (. url)

var chart = c3.generate({
        bindto: '#chart_c3_donut',
        data: {
          url: 'c3_donut.csv',
0

I fixed ... this code works well ...

<html>
  <head>
    <link rel="stylesheet" type="text/css" href="c3.css">
  </head>
  <body>
    <div id="chart"></div>

    <script src="d3.min.js" charset="utf-8"></script>
    <script src="c3.min.js"></script>
    <script>
var chart = c3.generate({
    bindto: '#chart',
    data: {
        x: 'Date', 
        x_Format: '%Y-%m-%d', 
        url: 'dates.csv', 
    },
    axis: {
    x: {
        type: 'timeseries', 
    }
}
});

</script>
</body>
</html>
Date,Count
1996-12-20,1
1997-01-31,2
1997-01-31,3
1997-05-07,4
1997-10-03,5
1997-12-02,6
1997-12-02,7
Run codeHide result
0
source

Source: https://habr.com/ru/post/1531944/

More articles:


All Articles