I have many text files numbered from 1 to 1 million in numerical order. Within each text file is 5 columns of data (TAB spaced) with many rows. I effectively want to take the minimum value from each column from each file and then plot them on a graph in order of the file name so that i can see how the minimum value of each column changes as the file name increases. This is my current code
This seems to work for me however it is plotting the results in the wrong order as i think it is reading the file names not in a numerical order but numerical order of each character so this order 1,10,1000,10000,2,20,30. Which is muddling up the order of the alldata matrix i'm creating. I am pretty new to mathematica so i apologise if anything i have done seems an odd way of going about it. My second issue is speed somewhere i think it is changing the values to floating point numbers with many .0000s which is slowing down the process.
My files are named 1.txt, 2.txt, ect...
Thank you for your time.
SortBy[FileNames[..],ToExpression[First@StringCases[#,__~~n:NumberString~~__:->n]]&](sorry cant test here but that should be close ) $\endgroup$