Re: [ferret_users] how to map date strings from a csv file onto a ferret time axis

To: ferret_users@xxxxxxxx

Subject: Re: [ferret_users] how to map date strings from a csv file onto a ferret time axis

From: Ansley Manke <a.c.manke@xxxxxxxxx>

Date: Mon, 31 Jan 2022 14:46:47 -0800

Arc-authentication-results: i=4; mx.google.com; dkim=pass header.i=@gmail.com header.s=20210112 header.b=C3mu7ndg; arc=pass (i=2 dkim=pass dkdomain=gmail.com); spf=pass (google.com: domain of a.c.manke@xxxxxxxxx designates 209.85.222.198 as permitted sender) smtp.mailfrom=a.c.manke@xxxxxxxxx

Arc-authentication-results: i=3; mx.google.com; dkim=pass header.i=@gmail.com header.s=20210112 header.b=C3mu7ndg; arc=pass (i=2 dkim=pass dkdomain=gmail.com); spf=pass (google.com: domain of a.c.manke@xxxxxxxxx designates 209.85.222.198 as permitted sender) smtp.mailfrom=a.c.manke@xxxxxxxxx

Arc-authentication-results: i=2; mx.google.com; dkim=pass header.i=@gmail.com header.s=20210112 header.b=C3mu7ndg; arc=pass (i=1 spf=pass spfdomain=gmail.com dkim=pass dkdomain=gmail.com dmarc=pass fromdomain=gmail.com); spf=softfail (google.com: domain of transitioning a.c.manke@xxxxxxxxx does not designate 65.153.203.166 as permitted sender) smtp.mailfrom=a.c.manke@xxxxxxxxx

Arc-authentication-results: i=1; mx.google.com; dkim=pass header.i=@gmail.com header.s=20210112 header.b=C3mu7ndg; spf=pass (google.com: domain of a.c.manke@xxxxxxxxx designates 209.85.220.41 as permitted sender) smtp.mailfrom=a.c.manke@xxxxxxxxx; dmarc=pass (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com

Arc-message-signature: i=4; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=list-archive:list-help:list-post:list-id:mailing-list:precedence :in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:sender:dkim-signature; bh=0zs1u0H14eZiijxQhwJ2YnH2RYueh4mgEgOmQuS8F+U=; b=RgwRQzeLv9qcwpbf1Px4dtK726l++e5JuPSi9sjUYKXlRrTXouos90iXnsYbBDRlF1 kcg1AD2wJVjZlO82DiU/JTjSroINpvf+p7QTmHM1nC5YVCoy/7McggwhAf0h2SGEynnP ir/9cttmOC8OHAF+fkh5SCdziEeRpsBUXRvp459IYdKoETG4LHsRYtwUwSaDGhKD8dy8 UtgQ3Et/dLHeLxOcTiDc7DijW5Zyz3ra0HDDWPCLsgkXHkeQDvCTtoL4HdyHa1X4xNyx UcZHrOh10WNadfB6fXb7A9ed7G+fhzt7w6x0Br92GnlCNklGcLrLmqENH4ADwIqxaXDo 3jxw==

Arc-message-signature: i=3; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:dkim-signature; bh=0zs1u0H14eZiijxQhwJ2YnH2RYueh4mgEgOmQuS8F+U=; b=txqofXckrDxadVhBhR89f7v8Vydz4XfVKMk0KTywzpCR71xE1zWhLhc74J5lfsjxBn 4koEZgykAQwq78yFF/ryV2YxhzTTdBpUo9cfun5EVZCl7BDtwaNyyFqLjAiShq5zADSA +j+SBewnliczU8SYeWd7y5noN4NViNdQxUJDw4qWwnE1LyWW532ATj/YBEgXlM9hGhcT 6rD4JQKklsXDlFrKs2IJEWHRBMMKPWxjL50BQAOrG2Kaxf3DsCfMZpYvmL9qSnfOYwzA 9YLnndc7ybytXXHb8tCFEP0Tgzoha7G/zOWJBz051gdKlPJFD3t3mKFlM2cHBnB2NTnS bWtA==

Arc-message-signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:dkim-signature; bh=0zs1u0H14eZiijxQhwJ2YnH2RYueh4mgEgOmQuS8F+U=; b=JmxhriJTuFxNmyYKMm8dsyWYYVl2u4xh8j607QnDfnX5bk/gHpzktisWCwwBhs0TNL f+A3JMY2lX8JS2p9VVee/bx8IR+zxfEGARR/PrN9zBQSkilTjxQj/MD1ayNeva90R0aO BblZVDD0bP8OMGHidIyTdReIfLlXFI73CU/jrmoyydSF5e5+0c1S/qIqXQoAfHRkn0h9 byN9SvbNtT1t1wegJui9jSPwY97LYC2LuGNQO/8AKY9ojQKvjgV8O0dcEhXd6+V4J1bJ 8Bpv7cm61+PlRzE9hW5Xd3Ar2oVTu+BWClk5GTY6ma8Vq6otqY0Q9chfgLjpXn5jsICy iJXQ==

Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:dkim-signature; bh=0zs1u0H14eZiijxQhwJ2YnH2RYueh4mgEgOmQuS8F+U=; b=aFSc0tmxHv15wJw81hATv+hW0yyjnz6w/WhFsPqBhftfIXwQjg217CLvOHc6XXwZBm YT/ZxcE6qUKPkwb9fukOUye2se+EaGKLj2m9Ngw/5nl5ONURGP25BSqkdljYHNCxunbK DlQuibWA119wJTBe1dDoxQO/TmRHbZVCNghi9Y6rlPogKpvI9EMIygW4Ic2stLi0eSe5 9uoCuRjNvLy59H8UREkk5wxwjE6iSxFNLpVR7o1Fbap2qDqSYV+BKX5RktytTiDEKqAB ciN+gFXf7WP9pDG8Zoe3tBjTXkPGJNKGUad8xf6C46TtBg54RT9d9WvCDncHQA97AoBz /saw==

Arc-seal: i=4; a=rsa-sha256; t=1643669223; cv=pass; d=google.com; s=arc-20160816; b=IKWTdoXpyjWzmCPM1AEIUSGrWS7vDZv0awAl91ODDIE60J/1IO8tAMx643LP7wMvRU ZZHotd7GTqjN2MANDVjfLik8mss6tgYC+sCukti6UjPZeJfd8uYr8+IlP8OQa5g1XgT5 F3+F4+HrrPxslpz5ey582U7sJ+3LR16hYOdGu9qKthtd+62k6/zl+zOs6Dtl2sgAk+3Y jYRm66lMOpwHK6GUypOmdC4cPrDpb0MIxSva1+5ItOY4j4KVdGPc3yDU4Gfw8y6mvpZE DfNzqFl6V16VT0nAQpsqKLw9XdHfA9jukOXV8gdX+d7zjILG3FexzUnaWnEePMLtfEpa CkBQ==

Arc-seal: i=3; a=rsa-sha256; t=1643669222; cv=pass; d=google.com; s=arc-20160816; b=Guozuj4h7LzbpLfSIQbokyHpztInvwRtvafBZVn25ENknM/PEg5Y6NLHLpZVIDMGNE MiH1xnd3WPCeLlWlQpHV909NHdY+TyfCET5ydDQd3f7Oa25xcOrWNbg7f2M3gNE9uxdq b1xV9YEKmDalNTimKVVzZbaORq1Pm8ER6N57IDXoa5/OcfIRQybBeNiau4hx9pR8A3+Q 3RgBGvxwhO5KsSqOhwpqG4hUPQewSNZF/1wURMoffYTigSjsRXwRrhIEuf/JBMnMLlcz +/rIC37jfNPXS1LHwsWOkVLTlrBCYdmN+N74BMhxu7T7N1AkCY+vUdh83DGHolEOaSCl Uv6Q==

Arc-seal: i=2; a=rsa-sha256; t=1643669211; cv=pass; d=google.com; s=arc-20160816; b=a5b58UMUEsGDuQgZRIz2E8VKWzZFcSKxQFP3Q3K0UYfsDFfTTi/q9yeqz6+dIKSHQ7 MHsUj4O89XF+bA1OMbvB204XvREdCV1qGZJ5y3opA0BZA27C7WRwA0LjZz/RqXWqsVRI xE2yG7diwi8yQTllNE9/93G+QISGvGzafysc+WsMHWeJKjEyrnuXOzybWm3zJDkNl2K5 B/5q/BwQRm4NCcvpaIN3I5BokUy2kJpGO772/aRz/Sr70jRtAy7BoDMlItTBgjxNIkqa wd9UB2Yg2kXp/UTTqY4lileATrf7po1CMZN2eDPJXK7fWvhv2qmUdXXsPpGfxrhKCSO4 qenw==

Arc-seal: i=1; a=rsa-sha256; t=1643669210; cv=none; d=google.com; s=arc-20160816; b=oCxo3Grw73EA7H98Ce5R+jBG2RmvwyYtUi4HkRUw8XkA26Js11PR2a4TWDoyAqOsoz 9XUEYiD5vkdnTF7YRCY8VxtpdT9mOJJp7BuOdXiT5VJc+Km8sxR8kuozqSyKzAZkvrcV oZRXBF10uakQAUC05ExNrsdbfmnurk8vCbginlF/Twak8ZrgLhapKMKn6qstt5kwtO29 PfxWNCbDB01mUzg8UCvVAIVVvi8KGxIpQu+PBFbVagudq4uWEQL9HbHOD5EocYLA0pM2 j+9m6am2LVhnsbRYPXCciHdNRYXiC5XAQPQud9jXhwNtfucJ1ac80UvafAvNW44WsWqa jlrQ==

Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=noaa.gov; s=google; h=sender:message-id:date:mime-version:user-agent:subject :content-language:to:references:from:in-reply-to:x-original-sender :x-original-authentication-results:precedence:mailing-list:list-id :list-post:list-help:list-archive; bh=0zs1u0H14eZiijxQhwJ2YnH2RYueh4mgEgOmQuS8F+U=; b=TFrR4N6g76fOs7VQdFt0EymqrBh91P0wOgKbODIV047tn4BqvZq/pIxcJ8+R1NvzTO xIanh9BhMAeCLN688vGUFv+IqA6u5CNDii+KN0b2Ijh/P1eX0QpF0+EtBnfbgtq5T1tI Wwkl0SwF8IODvDculVqkSluRElzrjk0f0G24vPtAxGYFxqIxUxUou9fUrV8se5JeEN9B MRkHT3OGXT3GOW2HUvqL2ts1ThxUPYwGTn5tZl/RUlD/Y6hfohKojIBP1gnmxfrEfivR ZaR2nrt4Uc1znnYnMSFmQ+kXLItro0xtgKdc9aHSLAIJJIFNbwA7bo0hFO/hw1nL3a9E qgKQ==

In-reply-to: <CAEsMs0RhnnK8GV4gH7pexES106YDm=Sn+f0FVH4AzKjGNz=92Q@mail.gmail.com>

List-archive: <https://groups.google.com/a/noaa.gov/group/ferret_users/>

List-help: <https://support.google.com/a/noaa.gov/bin/topic.py?topic=25838>, <mailto:ferret_users+help@noaa.gov>

List-id: <ferret_users.noaa.gov>

List-post: <https://groups.google.com/a/noaa.gov/group/ferret_users/post>, <mailto:ferret_users@noaa.gov>

Mailing-list: list ferret_users@xxxxxxxx; contact ferret_users+owners@xxxxxxxx

References: <CAEsMs0RhnnK8GV4gH7pexES106YDm=Sn+f0FVH4AzKjGNz=92Q@mail.gmail.com>

Sender: owner-ferret_users@xxxxxxxx

User-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101 Thunderbird/91.5.1

Hi Al,

In general, you can read date/ time information from a text file with "set data/form=delimited"

It looks like what's in your file corresponds to the "datime" format, but you would need to edit the file to replace the T with a space, and remove the Z. Also, if the file has quotation marks around the dates, remove those.

It should go something like this:

yes? file/form=delim/var="ftime"/type="datime" myfile.csv

! Look at the time data and its units. Dates are translated into "days since 1900,
! and time is added as a fraction of the day

list/i=1:10/precision=8 ftime
define axis/t/t0=1=jan=1900/units=days my_time_axis = ftime

On 1/31/2022 1:44 PM, Albert Hermann - NOAA Affiliate wrote:

Hi,

Does anyone know how to easily map dates like the ones shown below (contained as a variable in a csv file) onto a time axis in ferret? The file contains one date string and temperature value (plus other variables) per line. So far I have not found any ferret function that can interpret these strings - does one exist? Thanks.

-Al Hermann

yes? list/i=1:10 time
VARIABLE : TIME
FILENAME : 2021_SpringDeployed_BS_BioPUFFS_POPS0001_bottomdata.csv
SUBSET : 10 points (X)
1 / 1:"2021-05-13T00:10:00Z"
2 / 2:"2021-05-13T01:10:00Z"
3 / 3:"2021-05-13T02:10:00Z"
4 / 4:"2021-05-13T03:10:00Z"
5 / 5:"2021-05-13T04:10:00Z"
6 / 6:"2021-05-13T05:10:00Z"
7 / 7:"2021-05-13T06:10:00Z"
8 / 8:"2021-05-13T07:10:00Z"
9 / 9:"2021-05-13T08:10:00Z"
10 / 10:"2021-05-13T09:10:00Z"

albert.j.hermann@xxxxxxxx
Pacific Marine Environmental Laboratory
7600 Sand Point Way NE
Seattle WA 98115
206-526-6495