Thanks for the post. I have used SQLite and the DB Browser. I may do just
do as you suggested. I would also like to import the data into weewx. It
might make sense to put the data into a SQLite database before trying to
import the data into weewx. I actually coded the python program to create
a single csv file. I have 9 months of 2016 and 1 month of 2017 weather cat
data that I will work with in a single csv file. I will leave 2015 and 2014
data for later, maybe much later.
I still have not decide to use the high values or average the high/low
values. I am looking at some of the data to see if it makes any real
difference. I will need one value if I import into weewx. Any suggestions?
On Sunday, April 23, 2017 at 12:37:41 PM UTC-4, Bob Weber wrote:
>
> 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.
