Climate Time Series In a Single CSV File: Update 1

I am pleased to announce my CTS.csv file which includes 18 climate monthly time series in one easy to access csv file. This is part of  my goal of having a user friendly way for do-it-yourself citizen climate scientists to get up-to-date agency climate time series in a painless way.

Update 1: Reader Scott asked if I could provide meta data for the columns in my CTS.csv. This page lists the source agency and data links for the climate data series.

Here’s a snap shot of the first 6 rows of my  CTS.csv file. The data extends from 1880 until the most recent month.  Click image to enlarge

My hope is to make the CTS.csv the go-to file for citizen climate scientists who may want to:

  • Check temperature anomalies trends by series (GISS, HAD, NOAA, RSS, UAH)
  • Assess climate oscillations(AMO, AO, MEI, Nino34,  PDO)  trends
  • Evaluate  CO2 versus temperature anomaly relationships
  • Evaluate relationship between Sunspot numbers and anomaly temperature anomaly trends
  • Compare atmospheric transmission, SATO index  and volcanic activity
  • Assess impact of volcanoes on temperature anomaly trends
  • Compare MEI versus Nino ENSO 34 indicators
  • Assess lower stratospheric trends using RSS’s TLS series

By having these climate time series in a single csv file, R and Excel users can work with up to date data in a convenient form. The file will be automatically updated monthly as the climate agencies release their latest data.

How can CTS.csv Help Do-It-Yourself Citizen Climate Scientists?

Interested climate observers who want to compare global SSTA versus Nino34 trends, for example, have to follow a multiphase process:

  1. Find data file – even with Google this can take time
  2. Download files
  3. Merge 2 or more files to get data  into a usable format – source files all have different formats
  4. Perform analysis

Steps 1-3 can be very time consuming, so many users don’t bother checking out their ideas. Rather, they may rely on climate blog  comments. With CTS.csv and some R or Excel analysis, they can find the facts themselves rather than just having opinions.  They can submit their analysis and charts to blog posts, hopefully increasing the rigor of blog discussions.

Climate bloggers can request that their readers submit charts to back up their climate trend claims.

Data & RClimate Scripts Are All Open Book

All of the RClimate script that I use to produce the CTS.csv is available on-line at this link. Source data links are included in the function for each series.

About these ads

9 responses to “Climate Time Series In a Single CSV File: Update 1

  1. I just downloaded the cts.csv file (actually both CTS.csv and cts.csv since there are two links, one uppercase, on lowercase), and it is missing all of the columns after ‘MEI’.

  2. Hey Kelly,
    I was wondering did you ever work with the JMA data?
    http://ds.data.jma.go.jp/tcc/tcc/products/gwp/temp/map/download.html

    This is where i’ve been told the data is but perhaps you know of another place with a normal format?

    • I saw your work on Skeptical Science.

      Curious, did you use R to get your hands on any of the 10 temperature series?

    • Hey Kelly,

      No that work was done prior to the R stuff and your help. Though I will say that I wish I had talked to you sooner! It woulda made it a LOT easier.

  3. Can you provide metadata for this csv file. Importantly, descriptions of the columns, what units are used, etc.

    • Scott
      I am working on a page that provides all the details. In the meantime, the r script that I use to retrieve and write the data is available online link . You can find the link to the climate agency source file for each column in the csv file.

    • scott

      I have added a page with source agency and data file links here.

      Thanks for the suggestion. Let me know if you have any questions.

      Kelly

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s