Solved

Convert NETCDF to CSV

Posted on 2015-01-26
6
1,545 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 62

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 16

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 62

Assisted Solution

by:gheist
gheist earned 200 total points
ID: 40580785
Another is max-planck-institut CDO software.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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 62

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Strings in Python are the set of characters that, once defined, cannot be changed by any other method like replace. Even if we use the replace method it still does not modify the original string that we use, but just copies the string and then modif…
Flask is a microframework for Python based on Werkzeug and Jinja 2. This requires you to have a good understanding of Python 2.7. Lets install Flask! To install Flask you can use a python repository for libraries tool called pip. Download this f…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

790 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