C#2019 文本数据分析记录
C#2019 文本数据分析记录
string fileName = Directory.GetCurrentDirectory() + "\\data analysis\\" + "枪.TXT";
using (StreamReader sr = new StreamReader(fileName))
{
using (TextWriter tw = new StreamWriter("5.csv"))
{
string line, cstring, ang = "";
StringBuilder sbn = new StringBuilder();
StringBuilder sbn1 = new StringBuilder();
int cmaxc, centc, fanwei,meantc5, meantc7, meantc10;
double meanc,medianc,maxc,entc,tc;
string []title = new string[] {"ang","d","meanc","medianc","maxc","tc","entc" , "centc",
"maxc > 240", "maxc - tc > 10" , "tc-meanc>5", "tc-meanc>7","tc-meanc>10" };
while ((line = sr.ReadLine()) != null)
{
cmaxc = 0;
centc = 0;
fanwei = 0;
meantc5 = 0;
meantc7 = 0;
meantc10 = 0;
meanc = 0;
medianc = 0;
maxc = 0;
entc = 0;
tc = 0;
string[] parts = line.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
if (parts.Length == 7)
{
ang = parts[0];
meanc = Convert.ToDouble(parts[2]);
medianc = Convert.ToDouble(parts[3]);
maxc = Convert.ToDouble(parts[4]);
tc = Convert.ToDouble(parts[5]);
entc = Convert.ToDouble(parts[6]);
cstring = Convert.ToDouble(parts[1]).ToString() + "," + Convert.ToDouble(parts[2]).ToString("F0")
+ "," + Convert.ToDouble(parts[3]).ToString("F0") + "," + Convert.ToDouble(parts[4]).ToString("F0")
+ "," + Convert.ToDouble(parts[5]).ToString("F0") + "," + Convert.ToDouble(parts[6]).ToString("F4");
if (maxc > 240)
cmaxc += 1;
if (entc < 0.999)
centc += 1;
if ((maxc - tc > 10) || (maxc - tc < -10))
fanwei += 1;
if (tc-meanc > 5)
meantc5 += 1;
if (tc - meanc > 7)
meantc7 += 1;
if (tc - meanc > 10)
meantc10 += 1;
if (parts.Length==7)
{
sbn.Append(ang + "," + cstring + "," + centc + "," + fanwei + "," + cmaxc +"," + meantc5 + "," + meantc7 + "," + meantc10);
sbn.AppendLine();
}
}
}
for (int i = 0; i < title.Length; i++)
{
sbn1.Append(title[i]+",");
}
// sbn1.Append(title);
sbn1.AppendLine();
sbn1.Append(sbn);
sbn1.AppendLine();
tw.WriteLine(sbn1);
}
}
欧克