如何使用不同格式的Csv文件绘制折线图？ [英] How Do I Draw A Line Chart Using Csv File With Different Format?

问题描述

我有一个以下格式的csv文件

 date，openemr 
 23-09-2014 04：56：14,1 
 23 -09-2014 04：56：15,1 
 23-09-2014 04：56：18,1 
 23-09-2014 04：56：18,1 
 23-09 -2014 04：56：19,1 
 23-09-2014 04：56：20,1 
 23-09-2014 04：56：23,1 
 23-09-2014 04：56：26,1 
 23-09-2014 04：56：27,1 
 23-09-2014 04：56：28,1 
 23-09-2014 04： 56：30,1 
 23-09-2014 04：57：03,1 
 23-09-2014 04：57：06,1 
 23-09-2014 04:57： 06,1 
 23-09-2014 04：57：06,1 
 23-09-2014 04：57：07,1 
 23-09-2014 04:57:08， 1 
 23-09-2014 04：57：09,1 
 23-09-2014 04：57：11,1 
 23-09-2014 04：57：13,1 
 23-09-2014 04:57:15,1 

i经历了很多文章，但我无法绘制图表，它在x轴上未定义，我已经使用过图表库，我对java脚本知之甚少，有人可以帮助我使用一些不错的库创建折线图。谢谢提前

解决方案

使用sampl e用于显示折线图的代码：

 HTML代码：
 < asp：label id =Label8 runat =servertext =折线图xmlns：asp =＃unknown>< / asp：label>  
< br /> 
< div id =chart_div8> 
< asp：literal id =lt8runat =serverxmlns：asp =＃unknown>< / asp：literal> 
< / div> 
 
 C＃代码：
 public void Line_Chart1（）
 {
 StringBuilder str4 = new StringBuilder（）; 
 // string sql =select * from tmp_feedback; 
 string sql =select itemid，round（avg（rating））as item from tmp_feedback group by itemid; 
 DataSet ds = new DataSet（）; 
 OracleDataAdapter adp = new OracleDataAdapter（sql，conn）; 
 adp.Fill（ds，tmp_feedback）; 
 DataTable dt = new DataTable（）; 
 dt = ds.Tables [0]; 
尝试
 {
 adp.Fill（dt）; 
 str4.Append（@< script type = text / javascript> google.load（* visualization *，* 1 *，{packages：[* corechart *]}）; 
 google.setOnLoadCallback（ drawChart）; 
函数drawChart（）{
 var data = new google.visualization.DataTable（）; 
 data.addColumn（'string'，'ITEMID'）; 
 data .addColumn（'number'，'RATING'）; 
 
 data.addRows（+ dt.Rows.Count +）;）; 
 
 Int32 i; 
 for（i = 0; i< = dt.Rows.Count  -  1; i ++）
 {
 str4.Append（data.setValue（+ i +，+ 0 +，+'+ dt.Rows [i] [ITEMID]。ToString（）+'）;）; 
 str4.Append（data.setValue（+ i +，+ 1 +，+ dt.Rows [i] [RATING]。ToString（）+）;）; 
} 
 str4.Append（var chart = new google.visualization.LineChart（document.getElementById（'chart_div8'））;）; 
 str4.Append（chart.draw（data，{width：300，height：300，title：'Performance Rating'，）; 
 str4.Append（vAxis：{title：'Rating '，titleTextStyle：{color：'green'}}）; 
 str4.Append（}）;}）; 
 str4.Append（< / script>）; 
 lt8.Text = str4.ToString（）。TrimEnd（'，'）。Replace（'*'，''）; 
 conn.Close（）; 
} 
抓住
 {
 
} 
最后
 {
 conn.Close（）; 
} 
} 

I have a csv file in the following format

date,openemr
23-09-2014 04:56:14,1
23-09-2014 04:56:15,1
23-09-2014 04:56:18,1
23-09-2014 04:56:18,1
23-09-2014 04:56:19,1
23-09-2014 04:56:20,1
23-09-2014 04:56:23,1
23-09-2014 04:56:26,1
23-09-2014 04:56:27,1
23-09-2014 04:56:28,1
23-09-2014 04:56:30,1
23-09-2014 04:57:03,1
23-09-2014 04:57:06,1
23-09-2014 04:57:06,1
23-09-2014 04:57:06,1
23-09-2014 04:57:07,1
23-09-2014 04:57:08,1
23-09-2014 04:57:09,1
23-09-2014 04:57:11,1
23-09-2014 04:57:13,1
23-09-2014 04:57:15,1

i have gone through many articles but am unable to draw a chart it is coming like undefined on x axis, i have used am chart library,i don't have much knowledge on java script, can someone please help me out in creating a line chart using some nice library.Thanks In Advance

解决方案

Use the sample Code for displaying the line chart:

HTML Code:
<asp:label id="Label8" runat="server" text="Line Chart" xmlns:asp="#unknown"></asp:label>
                        <br />
                    <div id="chart_div8">
                        <asp:literal id="lt8" runat="server" xmlns:asp="#unknown"></asp:literal>
                    </div>

C# Code: 
public void Line_Chart1()
    {
        StringBuilder str4 = new StringBuilder();
        //string sql = "select * from tmp_feedback";
        string sql = "select itemid,round(avg(rating)) as rating from tmp_feedback group by itemid";
        DataSet ds = new DataSet();
        OracleDataAdapter adp = new OracleDataAdapter(sql, conn);
        adp.Fill(ds, "tmp_feedback");
        DataTable dt = new DataTable();
        dt = ds.Tables[0];
        try
        {
            adp.Fill(dt);
            str4.Append(@"<script type=text/javascript> google.load( *visualization*, *1*, {packages:[*corechart*]});
            google.setOnLoadCallback(drawChart);
            function drawChart() {
            var data = new google.visualization.DataTable();
            data.addColumn('string', 'ITEMID');
            data.addColumn('number', 'RATING');

            data.addRows(" + dt.Rows.Count + ");");

            Int32 i;
            for (i = 0; i <= dt.Rows.Count - 1; i++)
            {
                str4.Append("data.setValue( " + i + "," + 0 + "," + "'" + dt.Rows[i]["ITEMID"].ToString() + "');");
                str4.Append("data.setValue(" + i + "," + 1 + "," + dt.Rows[i]["RATING"].ToString() + ") ;");
            }
            str4.Append("   var chart = new google.visualization.LineChart(document.getElementById('chart_div8'));");
            str4.Append(" chart.draw(data, {width: 300, height: 300, title: 'Performance Rating',");
            str4.Append("vAxis: {title: 'Rating', titleTextStyle: {color: 'green'}}");
            str4.Append("}); }");
            str4.Append("</script>");
            lt8.Text = str4.ToString().TrimEnd(',').Replace('*', '"');
            conn.Close();
        }
        catch
        {

        }
        finally
        {
            conn.Close();
        }
    }

这篇关于如何使用不同格式的Csv文件绘制折线图？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！