Re: [ferret_users] Irregular depth from delimited file

[Karnan C <karnanc6@xxxxxxxxx>]

Dear ferret_users,
I don't get any idea to define my data and plot it properly. Here I
have attached one set of data (Ratios.xlsx) and the expected to plot a
time series vertical section plot (similar to attached image;
plotodv.png).

I don't have enough knowledge on irregular data plot from xls format.
Please someone help me,
Thank you.

My data looks like,
Latitude	Longitude	Depth	Collection	NP	NS	SP
9.4915	76.3140	0	1	0.196	0.007	27.216
9.4915	76.3140	1	1	0.170	0.007	23.283
9.4915	76.3140	2	1	0.232	0.010	22.161
9.4915	76.3140	3	1	0.877	0.044	19.877
9.4915	76.3140	4	1	1.163	0.048	24.070
9.4915	76.3140	5	1	2.621	0.168	15.603
9.4915	76.3140	0	2	0.226	0.006	35.194
9.4915	76.3140	1	2	1.711	0.049	34.921
9.4915	76.3140	2	2	0.171	0.005	31.857
9.4915	76.3140	3	2	2.585	0.071	36.463
9.4915	76.3140	4	2	5.291	0.193	27.364
9.4915	76.3140	5	2	5.987	0.226	26.493
9.4915	76.3140	0	3	ND	ND	24.735
9.4915	76.3140	2	3	0.300	0.012	24.588
9.4915	76.3140	4	3	0.356	0.023	15.620
9.4915	76.3140	6	3	1.606	0.242	6.640
9.4915	76.3140	0	4	3.913	0.087	44.864
9.4915	76.3140	2	4	5.093	0.147	34.744
9.4915	76.3140	4	4	2.608	0.089	29.463
9.4915	76.3140	6	4	1.655	0.086	19.165
9.4915	76.3140	0	5	0.160	0.016	9.915
9.4915	76.3140	2	5	1.250	0.077	16.281
=======================================================================
Thanks you.
Regards,
Karnan C.
======================================




2017-08-25 11:17 GMT+05:30, Ryo Furue <furue@xxxxxxxxxx>:
> Hi Karnan,
>
> I have to generate a time series vertical plot of nutrient or any data.
>> In which I need y=depth and x=collection dates/numbers.
>> My delimited data set contains 5 columns such as depth, collection,
>> data1, data2, data3.
>> My collection is regular from 1 to 18 but the depths of each
>> collection were irregular.
>> I have tried with some earlier queries and methods.
>> I can define time axis (regular), but I can't find a solution for
>> depth (irregular).
>>
>
> I haven't looked at details of your data, but here is a snipped of the code
> to plot a depth-distance distribution of oxygen by regridding the the
> irregular depths to a regular grid:
>
>    define axis/z=0:6000:100/depth/units="meters" depax ! New depth axis
>    define axis/x . . . .  horax
>    define grid/x=horax/z=depax  mygrid
>    FILE/VAR="station,depth,oxygen"/GRID=mygrid/order=ZX oxygen.dat
>    let oxy = ZAXREPLACE(oxygen, depth, z[gz=depax])
>
> The trick is ZAXREPLACE .  See the Ferret manual.
>
> Hope this helps,
>
> Ryo
>


-- 
C. Karnan, CSIR - SRF
Ph. D Research Scholar
National Institute of Oceanography (CSIR)
Regional Centre, Dr Salim Ali Road
Kochi - 682 018.
India.
Mobile No. +91 9633032345; +91 9941811608

Attachment: plotodv.png
Description: PNG image

Attachment: Ratios.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet