[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Support #JPH-820450]: Comparing wind datasets in netCDF and MS Excel formats

This archive contains answers to questions sent to Unidata support through mid-2025. Note that the archive is no longer being updated. We provide the archive for reference; many of the answers presented here remain technically correct, even if somewhat outdated. For the most up-to-date information on the use of NSF Unidata software and data services, please consult the Software Documentation first.

  • Subject: [Support #JPH-820450]: Comparing wind datasets in netCDF and MS Excel formats
  • Date: Tue, 20 Jun 2006 07:55:58 -0600
Camille,

re:
> I would like to compare two wind data sets:
> 
> One provided by a platform on the North Sea in the format Excel,
> 
> And the other one, in the format NetCDF, provided from the NCEP/NCAR
> Reanalysis Project.
> 
> Is there any way to convert Excel to NetCDF

There may be a utility to convert data stored in a form usable by eXcel
(e.g., comma separated fields) to netCDF.  Please review the list of
packages that use netCDF:

Unidata HomePage
http://www.unidata.ucar.edu
  netCDF HomePage
  http://www.unidata.ucar.edu/software/netcdf/
    Software for manipulating or displaying netCDF data
    http://www.unidata.ucar.edu/software/netcdf/software.html

The other thing you could do is send a note to the address@hidden
email list asking community members if they know of a package that can do
what you want.  In order to post emails to any of the lists that we maintain,
you must first subscribe to the list.

You can (un)subscribe to any Unidata-maintained email list online
at:

http://www.unidata.ucar.edu/content/support/mailinglist/mailing-list-form.html

If you decide to subscribe to post your message, please wait until
you have received notification of being added to the list before your
post.

> or NetCDF to Excel, is
> there any software for this?

You can use the netCDF utility 'ncdump' to list out the contents of a netCDF
file in ASCII text.  You could then write a script that takes this ASCII
output and reformats it into a comma-separated form that can be imported
into eXcel.

> Thank you,

No worries.  I apologize for taking so long to get back to you.

> Regards,
> Camille Bastide

Cheers,

Tom
****************************************************************************
Unidata User Support                                    UCAR Unidata Program
(303) 497-8642                                                 P.O. Box 3000
address@hidden                                   Boulder, CO 80307
----------------------------------------------------------------------------
Unidata HomePage                       http://www.unidata.ucar.edu
****************************************************************************


Ticket Details
===================
Ticket ID: JPH-820450
Department: Support
Priority: Normal
Status: Closed