Solved

Convert NETCDF to CSV

Posted on 2015-01-26
6
1,639 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
jdbc error in jsp application 20 71
ejb wildfly example 2 69
Which non-HTML GUI front end to use with Java? 3 50
CSV file parsing thru Java 13 39
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…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

680 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