Glad you got a converter program going. What I have done is use "DB
Browser for SQLite" (package sqlitebrowser) to import the csv files into a
sqlite database. So it would be much easier if you wrote all the data out
to one csv file (use the write append mode when you open the output file in
python - remember to start out with an empty file). Then using
matplotlib.pyplot plot out the data read from a sqlite file with the sqlite3
library. I wrote a nice little gui with tkinter to select which data to
plot and the time frame. I use spyder3 for a python ide. You can single
step a program and watch variables .. much needed when you are learning how
to use new libraries. I have concentrated on python3 since that seems to
be the way things are going. I have also copied that data into a
postgresql database which uses a full set of sql (with a real date field
type). The thing is that once you learn the sqlite3 library way to program
in python the pgdb library works very similarly. Also look at the datetime
library. It helps
You could write the data to a .sql file with the format like this:
BEGIN TRANSACTION; CREATE TABLE WXDailyHistory (Date TEXT, TemperatureHighF
REAL, TemperatureAvgF REAL, TemperatureLowF REAL, DewpointHighF REAL,
DewpointAvgF REAL, DewpointLowF REAL, HumidityHigh INTEGER, HumidityAvg
INTEGER, HumidityLow INTEGER, PressureMaxIn REAL, PressureMinIn REAL,
WindSpeedMaxMPH INTEGER, WindSpeedAvgMPH INTEGER, GustSpeedMaxMPH INTEGER,
PrecipitationSumIn REAL); INSERT INTO `WXDailyHistory` VALUES
('2008-11-8','64.5','58.4','50.1','60.0','55.2','46.0','96','89','80','29.72','29.60','6','2','0','0.05');
INSERT INTO `WXDailyHistory` VALUES
('2008-11-9','62.7','49.6','39.3','46.0','40.2','36.0','99','73','41','29.96','29.72','11','2','0','0.00');
...
COMMIT;
That creates the table and inserts the data. I use this format to import
into postgresql but it would also work in the sqlite db browser. SQL is
your friend.
I use the package pgadmin3 to view the data in the postgresql database.
Hope this hasn't confused things. I just wanted to explain the various ways
you can use your weather data.
On Friday, April 21, 2017 at 10:42:22 AM UTC-4, MRL wrote:
>
> Weather Cat daily data in a PDF file
> I thought I had a program to convert the PDF file to a text file. The
> conversion is a mess and unusable.
> Any help? I have 3+ years of daily data.
> I still have Weather Cat but have not been able to find an export
> capability.
>
>
--
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.
