Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  nodelist  faq  login

What this country needs is a good five cent microcomputer.


computers / comp.graphics.apps.gnuplot / Re: format x axis as date/time

SubjectAuthor
* format x axis as date/timeRandy Wilkinson
`* Re: format x axis as date/timeJörg_Buchholz
 `- Re: format x axis as date/timeRandy Wilkinson

1
Subject: format x axis as date/time
From: Randy Wilkinson
Newsgroups: comp.graphics.apps.gnuplot
Date: Tue, 7 Dec 2021 23:50 UTC
X-Received: by 2002:ac8:5cc4:: with SMTP id s4mr3230655qta.505.1638921057855; Tue, 07 Dec 2021 15:50:57 -0800 (PST)
X-Received: by 2002:a25:71c3:: with SMTP id m186mr24701624ybc.598.1638921057535; Tue, 07 Dec 2021 15:50:57 -0800 (PST)
Path: i2pn2.org!i2pn.org!news.swapon.de!news.uzoreto.com!tr1.eu1.usenetexpress.com!feeder.usenetexpress.com!tr2.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.graphics.apps.gnuplot
Date: Tue, 7 Dec 2021 15:50:57 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=67.5.113.7; posting-account=5nKv8woAAADM_uJpPf4DhXhpFdLsk7x-
NNTP-Posting-Host: 67.5.113.7
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <67956c64-1ec5-49b2-bd52-8ed95cadcfe5n@googlegroups.com>
Subject: format x axis as date/time
From: randallc...@gmail.com (Randy Wilkinson)
Injection-Date: Tue, 07 Dec 2021 23:50:57 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 37
View all headers
I am trying to figure out how to format the x axis of my plot using date and time.  I have sensor measurement readings that are recorded every few minutes over multiple days.

My data file looks like this excerpt:

11/19/2021 11:36:01,717.9,70.2,33.4
11/19/2021 11:42:01,701.5,70.8,33.6
11/19/2021 11:48:01,692.5,71.2,32.7
11/19/2021 11:54:01,695.4,71.3,32.0
11/19/2021 12:00:01,699.8,71.4,31.5
11/19/2021 12:06:01,698.9,71.7,31.1
11/19/2021 12:12:01,697.3,71.9,30.7
11/19/2021 12:18:01,711.6,72.1,30.5
11/19/2021 12:24:01,765.9,72.3,30.3
11/19/2021 12:30:01,747.0,73.7,29.0
..
..
..

My gnuplot settings are currently like this:

set datafile separator comma
set title "CO2 Measurements" font ",20"
set xdata time
set timefmt "%m/%d/%Y %H:%M:%S"
set y2range [32:100]
set autoscale y
#set autoscale y2
set format x "%m/%d/%Y %H:%M"
set ylabel "CO2, PPM"
set y2label "Temperature, Degrees F"
set grid
set border
set style data lines
plot 'CO2logfile-25Nov21.csv' using 0:2, '' using 0:3, '' using 0:4

It looks like plot does not ready the time correctly from my data file.  It seems to only be reading the seconds.  I'd like the x axis to indicate the date and time for measurements from the data file.

Any suggestions appreciated!   Randy


Subject: Re: format x axis as date/time
From: Jörg_Buchholz
Newsgroups: comp.graphics.apps.gnuplot
Organization: A noiseless patient Spider
Date: Wed, 8 Dec 2021 06:51 UTC
References: 1
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: bookwood...@freenet.de (Jörg_Buchholz)
Newsgroups: comp.graphics.apps.gnuplot
Subject: Re: format x axis as date/time
Date: Wed, 8 Dec 2021 07:51:47 +0100
Organization: A noiseless patient Spider
Lines: 16
Message-ID: <sopkm2$2pv$1@dont-email.me>
References: <67956c64-1ec5-49b2-bd52-8ed95cadcfe5n@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Wed, 8 Dec 2021 06:51:46 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="6c581da3482a1a95cfe831512c477cef";
logging-data="2879"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19E6plBHpN9zEjYXHg1dtRsS3wZs63LymY="
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.3.2
Cancel-Lock: sha1:A8TbaHfH6pBX4+klwVugGl6h4xY=
In-Reply-To: <67956c64-1ec5-49b2-bd52-8ed95cadcfe5n@googlegroups.com>
Content-Language: en-GB
View all headers

On 08.12.2021 00:50, Randy Wilkinson wrote:

plot 'CO2logfile-25Nov21.csv' using 0:2, '' using 0:3, '' using 0:4

It looks like plot does not ready the time correctly from my data
file.  It seems to only be reading the seconds.  I'd like the x axis
to indicate the date and time for measurements from the data file.

Any suggestions appreciated!   Randy



column 0 is a "pseudo-column", your date is in column 1.

Jörg


Subject: Re: format x axis as date/time
From: Randy Wilkinson
Newsgroups: comp.graphics.apps.gnuplot
Date: Wed, 8 Dec 2021 14:53 UTC
References: 1 2
X-Received: by 2002:a05:620a:1253:: with SMTP id a19mr7053920qkl.293.1638975227269;
Wed, 08 Dec 2021 06:53:47 -0800 (PST)
X-Received: by 2002:a25:ac21:: with SMTP id w33mr60793476ybi.616.1638975226977;
Wed, 08 Dec 2021 06:53:46 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.graphics.apps.gnuplot
Date: Wed, 8 Dec 2021 06:53:46 -0800 (PST)
In-Reply-To: <sopkm2$2pv$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=67.5.113.7; posting-account=5nKv8woAAADM_uJpPf4DhXhpFdLsk7x-
NNTP-Posting-Host: 67.5.113.7
References: <67956c64-1ec5-49b2-bd52-8ed95cadcfe5n@googlegroups.com> <sopkm2$2pv$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <cb2108db-982f-4bd2-a3e3-e8245aff81c4n@googlegroups.com>
Subject: Re: format x axis as date/time
From: randallc...@gmail.com (Randy Wilkinson)
Injection-Date: Wed, 08 Dec 2021 14:53:47 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 16
View all headers
On Tuesday, December 7, 2021 at 10:51:48 PM UTC-8, Jörg Buchholz wrote:
On 08.12.2021 00:50, Randy Wilkinson wrote:

plot 'CO2logfile-25Nov21.csv' using 0:2, '' using 0:3, '' using 0:4

It looks like plot does not ready the time correctly from my data
file. It seems to only be reading the seconds. I'd like the x axis
to indicate the date and time for measurements from the data file.

Any suggestions appreciated! Randy

column 0 is a "pseudo-column", your date is in column 1.

Jörg
I thought I tried that.  It works as expected using column 1 instead of 0.  Thanks!  Getting out the docs to find out what a pseudo-column is....Randy


1
rocksolid light 0.7.2
clearneti2ptor