Welcome to the Cumulus Support forum.

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Cumulus MX V4 beta test release 4.0.0 (build 4018) - 28 March 2024

Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014 (a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

Converting a CSV file

Talk about anything that doesn't fit elsewhere - PLEASE don't put Cumulus queries in here!
Post Reply
User avatar
Paul C
Posts: 538
Joined: Thu 19 Jun 2008 7:45 am
Weather Station: Davis VP2 with solar
Operating System: Windows 10
Location: Brampton, Cumbria, UK
Contact:

Converting a CSV file

Post by Paul C »

Hi
I wonder if anyone can help please.

I have a large CSV file with daily rainfall total from 1910 until present day, yes 1910 !!! to make any sense of it I thought I should put it into monthly amounts. But the only way I can see I can do it is to add each month up separately. As the sheet is one continuous line of data I have to split each month insert a blank line and add up the data and is proving very time consuming.

I wondered if anyone had any thoughts on how to import the CSV file into a database so I can obtain the monthly and yearly data quickly and easy ?

Data is from Coniston in Cumbria and is one of the longest unbroken rainfall stations in Cumbria

Many Thanks
Paul C
Brampton, Cumbria, UK
117m ASL
http://www.bramptonweather.co.uk
Image
User avatar
mcrossley
Posts: 12695
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Converting a CSV file

Post by mcrossley »

Hard to say without seeing the data Paul,

But in general, I'd flip the data into columns, then use a pivot table to summarise by month/year totals.

If you send me the file I enjoy an Excel challenge - weird!
User avatar
Paul C
Posts: 538
Joined: Thu 19 Jun 2008 7:45 am
Weather Station: Davis VP2 with solar
Operating System: Windows 10
Location: Brampton, Cumbria, UK
Contact:

Re: Converting a CSV file

Post by Paul C »

Cheers Mark

I have sent you a message, with the file attached. Hope its works

Paul
Paul C
Brampton, Cumbria, UK
117m ASL
http://www.bramptonweather.co.uk
Image
Post Reply