Hi Group,
Need some help. I'm performing some statistics on a txt file that has multiple columns using a collection list (vb.net 2008). My files can contain 100,000+ samples per file.
How would I code my function to have it perform work on the first 3000 samples and continue the calculations on every 3000 samples thereafter? Thx!
Private Sub decimationButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles decimationButton.Click
Dim lines() As String = System.IO.File.ReadAllLines(inputFileName) '("TEXT_FILE")
Dim list As New List(Of Double())
For Each str As String In lines
Dim ele() As Double = Array.ConvertAll(str.Split(vbTab), Function(k) Double.Parse(k))
list.Add(ele)
Next
'Output an ASCII Text File EDA Analysis
Dim FILE_NAME As String = "C:\Output.txt"
Dim objWriter As New System.IO.StreamWriter(FILE_NAME, False) '
objWriter.WriteLine("Easting " & vbTab & "Northing " & vbTab & "Depth" & vbTab & "East Mean" & vbTab & "D Mean" & _
vbTab & "E StDev" & vbTab & "D StDev" & vbCrLf)
For Each d As Double() In list 'THIS DOES WORK ON THE ENTIRE FILE
'Perform Exploratory Data Analysis on every 3000 samples
'Calculate Mean Values
Dim depthMeanVal As Double
Me.calcMean(list, eastMeanVal, depthMeanVal)
'Calc Standard Deviation
Dim eastStDev As Double
Dim depthStDev As Double
Me.calcStDev(list, eastStDev, depthStDev, eastMeanVal, depthMeanVal)
Next 'For Each Loop
objWriter.Close()
End Sub