protected void Button1_Click(object sender, EventArgs e)
{
string filepath = txtFilePath.Text;
classCSVHelper csh = new classCSVHelper();
filepath = Server.MapPath(filepath);
DataTable dt1 = csh.readCsvSql(filepath);
DataTable dt = csh.readCsvTxt(filepath, Encoding.Default);
int i = 0;
double[] closingPrice = new double[dt1.Rows.Count];
foreach (DataRow dr in dt1.Rows)
{
closingPrice[i++] = double.Parse(dr[3].ToString());
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string filepath = @"某公司统计的开机时间17000条左右.csv";
classCSVHelper csh = new classCSVHelper();
filepath = Server.MapPath(filepath);
DataTable dt = csh.readCsvTxt(filepath, Encoding.Default);
double[] Time = new double[dt.Rows.Count];
int j = 0;
//数据清洗
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][1].ToString() != "" && double.Parse(dt.Rows[i][1].ToString()) > 0)
{
Time[j] = double.Parse(dt.Rows[i][1].ToString());
j++;
}
}
//建立新数组，防止出现null值
double[] openTime = new double[j];
for (int i = 0; i < j; i++)
{
openTime[i] = Time[i];
}
double mean = calMean(openTime);
double devar = Caldevar(openTime);
try
{
double second = double.Parse(TextBox1.Text);
double z = (second - mean) / devar;
double rate = 1 - ClassStatistics.selfCaculate(z);
Response.Write(string.Format("你的开机速度击败了{0:F}%的成员！", rate * 100));
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}