Thanks again Bob. I now have a python program to convert the Weather Cat txt file (generated from pdftotext) to a CSV file I am sure sure when I will attempt to convert 900 files. How do I deal with 900 import files or do I need to merge the files into larger files? Marc
datetime,TempHi,HeatHi,DewPHi,HumHi,PresHi,Rain,AvWsHi,GustHi,WDir 2017-04-17 0:00:00,73.1,73.1,56.0,55,29.96,0.00,1,10,259 2017-04-17 1:00:00,72.1,72.1,55.0,57,29.96,0.00,1,7,271 2017-04-17 2:00:00,70.7,70.7,55.6,61,29.95,0.00,0,3,273 2017-04-17 3:00:00,69.3,69.3,55.9,66,29.94,0.00,0,4,268 2017-04-17 4:00:00,68.1,68.1,57.4,70,29.94,0.00,0,6,279 2017-04-17 5:00:00,67.3,67.3,57.3,72,29.95,0.00,0,6,279 2017-04-17 6:00:00,66.9,66.9,58.1,74,29.97,0.00,1,7,258 2017-04-17 7:00:00,66.8,66.8,57.2,72,29.99,0.00,1,6,270 2017-04-17 8:00:00,67.1,67.1,57.9,73,30.01,0.00,0,6,255 2017-04-17 9:00:00,66.5,66.5,60.2,84,30.03,0.01,0,3,91 2017-04-17 10:00:00,64.7,64.7,59.8,90,30.05,0.08,0,2,167 2017-04-17 11:00:00,62.0,62.0,59.3,91,30.07,0.03,0,3,257 2017-04-17 12:00:00,63.1,63.1,61.0,93,30.07,0.03,0,1,298 2017-04-17 13:00:00,63.3,63.3,61.2,93,30.06,0.00,1,8,56 2017-04-17 14:00:00,65.2,65.2,56.3,81,30.06,0.00,0,2,31 2017-04-17 15:00:00,67.0,67.0,55.7,69,30.05,0.15,0,3,327 2017-04-17 16:00:00,71.6,71.6,55.9,66,30.05,0.01,1,9,48 2017-04-17 17:00:00,71.4,71.4,50.7,48,30.05,0.00,1,5,41 2017-04-17 18:00:00,69.4,69.4,45.2,43,30.06,0.00,1,6,281 2017-04-17 19:00:00,67.9,67.9,45.2,51,30.08,0.00,0,0,282 2017-04-17 20:00:00,63.6,63.6,48.6,68,30.11,0.00,0,0,282 2017-04-17 21:00:00,58.8,58.8,48.4,71,30.13,0.00,0,0,282 2017-04-17 22:00:00,56.8,56.8,48.4,75,30.15,0.00,0,0,292 2017-04-17 23:00:00,57.8,57.8,47.7,75,30.16,0.00,0,4,22 On Saturday, April 22, 2017 at 7:43:26 PM UTC-4, MRL wrote: > > Thanks Bob > I have a script that processed the 4 days in April 2017 that I have > converting to text files. Hard to believe pdftotext did a better job than > Adobe Acrobat Standard 9 (very old). > Now to code a python program to transform data. > I am thinking of TempHi as temperature, DewPHi as dewpoint, HumHi as > humidity, PressHi as pressure and Rain for the rain each hour > This should be good enough. I guess I could average the high and low and > use that value. > What do you think? > Marc > > > On Friday, April 21, 2017 at 6:09:42 PM UTC-4, Bob Weber wrote: >> >> That's great. pdftotext just copies the pdf text to the same file name >> but with a .txt extension. So a second for loop would run your conversion >> program to create the csv file(s) from each .txt file. You could just >> create individual csv files or just append to one single file. Either way >> once you get a conversion program working doing 900 files will be a piece >> of cake. >> >> ...bob >> >> -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
