Solved

Convert NETCDF to CSV

Posted on 2015-01-26
6
1,308 Views
Last Modified: 2015-02-19
Dear all,

I've been looking into this for a while, I'm wondering if anyone has used the netCDF java library or python to read a NETCDF file and convert it to CSV. I haven't used python before, I've downloaded Anaconda.

Would you also have any examples and how difficult would it be to output the data into the table described below.

The data in the NETCDF file is time (date), longitude, latitude and value.  

Longitude,  Latitude,  Date1, Date2 etc
** Values **
** Values **

We can't use Netcdf4excel our machines are 2010 64 bit, also tried nc2text,
http://www.narccap.ucar.edu/data/ascii-howto.html it won't work for us either, each variable would be in a separate file (wrote the VB script to combine them) then when it comes to outputting the *values* it isn't  in a form we can use (comma delimited in a single cell).

I've also looked into these options without success  https://www.unidata.ucar.edu/software/netcdf/software.html#Java interface

I'm using ArcMap however not all the users will have access to the software.

Thanks
0
Comment
Question by:AndyC1000
  • 3
  • 2
6 Comments
 
LVL 61

Assisted Solution

by:gheist
gheist earned 200 total points
ID: 40572815
Try this: https://en.wikipedia.org/wiki/NCAR_Command_Language
It converts between many file types
0
 
LVL 15

Accepted Solution

by:
Walter Ritzel earned 300 total points
ID: 40580763
I think this library will do the work for you:
http://netcdf4-python.googlecode.com/svn/trunk/docs/netCDF4-module.html
0
 
LVL 61

Assisted Solution

by:gheist
gheist earned 200 total points
ID: 40580785
Another is max-planck-institut CDO software.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:AndyC1000
ID: 40583281
Thanks, I will look into it after I can't go further with Java.

Does anyone have experience using the java netcdf library?



I've opened the file, I'm having troubles finding the data within the object model.
0
 

Author Comment

by:AndyC1000
ID: 40583284
Here's the link for the netcdf java library I'm using.
http://www.unidata.ucar.edu/software/thredds/current/netcdf-java/documentation.htm
0
 
LVL 61

Expert Comment

by:gheist
ID: 40583371
None of that helps. You need Linux to run NCL or CDO. Cygwin may or may not work.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction On September 29, 2012, the Python 3.3.0 was released; nothing extremely unexpected,  yet another, better version of Python. But, if you work in Microsoft Windows, you should notice that the Python Launcher for Windows was introduced wi…
Dictionaries contain key:value pairs. Which means a collection of tuples with an attribute name and an assigned value to it. The semicolon present in between each key and values and attribute with values are delimited with a comma.  In python we can…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now