[gradsusr] gradsusr Digest, Vol 42, Issue 4
Sushant Das
sushant_models at yahoo.com
Tue Aug 6 08:54:19 EDT 2013
Thank you all for the suggestions...
I am going through it..
----------------------------------------------------------------------------------------------------------------------------------------------------------------
SUSHANT DAS,
CSIR Research Fellow,
Centre for Atmospheric Sciences,Block VI
Indian Institute of Technology, Delhi
New Delhi-110016,
INDIA
----------------------------------------------------------------------------------------------------------------------------------------------------------------
________________________________
From: "gradsusr-request at gradsusr.org" <gradsusr-request at gradsusr.org>
To: gradsusr at gradsusr.org
Sent: Sunday, August 4, 2013 9:30 PM
Subject: gradsusr Digest, Vol 42, Issue 4
Send gradsusr mailing list submissions to
gradsusr at gradsusr.org
To subscribe or unsubscribe via the World Wide Web, visit
http://gradsusr.org/mailman/listinfo/gradsusr
or, via email, send a message with subject or body 'help' to
gradsusr-request at gradsusr.org
You can reach the person managing the list at
gradsusr-owner at gradsusr.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of gradsusr digest..."
Today's Topics:
1. Re: Gradstoexcel (Stephen McMillan)
2. Re: Gradstoexcel (Rupak Rajbhandari)
3. Re: Gradstoexcel (Jayakrishnan P.R)
----------------------------------------------------------------------
Message: 1
Date: Sat, 3 Aug 2013 14:03:25 -0400
From: Stephen McMillan <smcmillan at planalytics.com>
Subject: Re: [gradsusr] Gradstoexcel
To: Sushant Das <sushant_models at yahoo.com>, GrADS Users Forum
<gradsusr at gradsusr.org>
Message-ID:
<CA+exxN3Jt6ga9Z8bOKwtJHT4xEwijiGjzhUNjOYV6sA4jtOpUQ at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Sushant,
You might find useful this "cookbook" document on opengrads.org:
http://cookbooks.opengrads.org/index.php?title=Recipe-002:_Saving_GrADS_variable_data_to_a_text_file
In it, there is a section on writing data to CSV files suitable for import
into Excel. Hope this helps.
Stephen McMillan
On Sat, Aug 3, 2013 at 11:01 AM, Sushant Das <sushant_models at yahoo.com>wrote:
>
> Dear GrADS Users,
>
> I need to know how to extract data from .nc format and write it in excel
> gridded format file?
> For eg.
> I have a netcdf file consisting of 180 by 360 data. Now i have to extract
> for the Indian domain say 60-100E and 5-40N
> so total grids would would be 40*35.
> After extracting the data it has to be written in excel sheet having
> format with varying lat in y axis and varying lon in x axis containing
> 40*35 data cells.
>
> Thanks in advance,
>
> Regards,
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------
> SUSHANT DAS,
> CSIR Research Fellow,
> Centre for Atmospheric Sciences,Block VI
> Indian Institute of Technology, Delhi
> New Delhi-110016,
> INDIA
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> _______________________________________________
> gradsusr mailing list
> gradsusr at gradsusr.org
> http://gradsusr.org/mailman/listinfo/gradsusr
>
>
***************************************************
The information contained in this e-mail message is intended only for the use of the recipient(s) named above and may contain information that is privileged, confidential, and/or proprietary.
If you are not the intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify the sender immediately by e-mail, and delete the original message.
***************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gradsusr.org/pipermail/gradsusr/attachments/20130803/9bea3661/attachment-0001.html
------------------------------
Message: 2
Date: Sun, 4 Aug 2013 07:54:00 +0545
From: Rupak Rajbhandari <rupak.rajbhandari at gmail.com>
Subject: Re: [gradsusr] Gradstoexcel
To: Sushant Das <sushant_models at yahoo.com>, GrADS Users Forum
<gradsusr at gradsusr.org>
Message-ID:
<CAPUBxUQSyEFV2sP=yGuRAbpkRSZi13s2fX9iP+E=TLaNoFVPTA at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Hi,
Attached is the GrADS script which extract information from 360x180 per
record file (exactly your file size) and writes ASCII file which you can
import into excel very easily.
In the file "ifp" is the input file path where your .nc file is located.
"ofp" is the output file path where you want to put the newly written ASCII
file.
The script writes variable 'tmin' (minimum temperature) and creates a daily
file. The naming convention is "tminYYYYDDMM.dat"
Edit x1 and x2 to 60 & 100 and y1, y2 to 5 & 40, ncol=41 (in your case).
My nc file is "tmin_daily_1965-1965.nc"
I have replaced 1965 or whatever year it is by variable "i' through the
script.
In short, "fprintf" function does what you are looking for. All you have to
do is manage accordingly to your needs.
Hope the script solves your problem and useful to you.
-rupak
++++++++++++++++++++++++++++++++++
Rupak Rajbhandari
Department of Meteorology
TriChandra College
Kathmandu
On Sat, Aug 3, 2013 at 8:46 PM, Sushant Das <sushant_models at yahoo.com>wrote:
>
> Dear GrADS Users,
>
> I need to know how to extract data from .nc format and write it in excel
> gridded format file?
> For eg.
> I have a netcdf file consisting of 180 by 360 data. Now i have to extract
> for the Indian domain say 60-100E and 5-40N
> so total grids would would be 40*35.
> After extracting the data it has to be written in excel sheet having
> format with varying lat in y axis and varying lon in x axis containing
> 40*35 data cells.
>
> Thanks in advance,
>
> Regards,
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------
> SUSHANT DAS,
> CSIR Research Fellow,
> Centre for Atmospheric Sciences,Block VI
> Indian Institute of Technology, Delhi
> New Delhi-110016,
> INDIA
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> _______________________________________________
> gradsusr mailing list
> gradsusr at gradsusr.org
> http://gradsusr.org/mailman/listinfo/gradsusr
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gradsusr.org/pipermail/gradsusr/attachments/20130804/ac52eda3/attachment-0001.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: nc2ascDD.gs
Type: application/octet-stream
Size: 1238 bytes
Desc: not available
Url : http://gradsusr.org/pipermail/gradsusr/attachments/20130804/ac52eda3/attachment-0001.obj
------------------------------
Message: 3
Date: Sun, 4 Aug 2013 20:40:59 +0530
From: "Jayakrishnan P.R" <prjayakrishnan at gmail.com>
Subject: Re: [gradsusr] Gradstoexcel
To: Sushant Das <sushant_models at yahoo.com>, GrADS Users Forum
<gradsusr at gradsusr.org>
Message-ID:
<CA+P5ZEGzvhQBnfUO-V78d0y1crgV6rch2KVdBtk=hROTiANEkQ at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Use the commands fwrite or subwrd.
--
Sincerely
***********************************************
Jayakrishnan.P.R
Teaching Associate (Atmospheric Science)
Academy of Climate Change Education and Research
Kerala Agricultural University
Vellanikkara-680 656
and also
Research Fellow (Part Time)
Department of Atmospheric Sciences
CUSAT, Cochin-682 016
Kerala, India.
Mob: 09496026547
***********************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gradsusr.org/pipermail/gradsusr/attachments/20130804/5a0e2663/attachment-0001.html
------------------------------
_______________________________________________
gradsusr mailing list
gradsusr at gradsusr.org
http://gradsusr.org/mailman/listinfo/gradsusr
End of gradsusr Digest, Vol 42, Issue 4
***************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gradsusr.org/pipermail/gradsusr/attachments/20130806/56717162/attachment-0003.html
More information about the gradsusr
mailing list