Skip to content

Plot line with nominal X axis values (--data-field-x-nominal) - #308

Merged
shenwei356 merged 2 commits into
shenwei356:masterfrom
lovromazgon:line-nominal
Mar 14, 2025
Merged

Plot line with nominal X axis values (--data-field-x-nominal)#308
shenwei356 merged 2 commits into
shenwei356:masterfrom
lovromazgon:line-nominal

Conversation

@lovromazgon

@lovromazgon lovromazgon commented Mar 13, 2025

Copy link
Copy Markdown
Contributor

This PR adds support to csvtk plot line to plot graphs where X is a nominal value. This can be done by using the flag --data-field-x-nominal.

All unique X values are collected, sorted and assigned an index. The corresponding value is also shown in the graph marker instead of the index. This opens up the ability to plot graphs for datasets, where X is a date, as long as it's formatted in a way that is sortable (e.g. YYYY-MM-DD HH:MM:SS). Related to this issue #179.

Example:

File example.csv:

time,value
2025-03-13 12:00,23.45
2025-03-13 12:01,67.89
2025-03-13 12:02,45.67
2025-03-13 12:03,89.12
2025-03-13 12:04,12.34
2025-03-13 12:05,78.90
2025-03-13 12:06,56.78
2025-03-13 12:07,34.56
2025-03-13 12:08,90.12
2025-03-13 12:09,10.01

Running command:

csvtk plot line example.csv -x time -y value --data-field-x-nominal -o example.jpg

Produces:
example

@shenwei356
shenwei356 merged commit 33a1fa0 into shenwei356:master Mar 14, 2025
@shenwei356 shenwei356 mentioned this pull request Mar 14, 2025
Closed
shenwei356 added a commit that referenced this pull request Mar 14, 2025
@shenwei356
update docs for #308
9efdde7
@shenwei356

shenwei356 commented Mar 14, 2025

Copy link
Copy Markdown
Owner

Geat! Thank you so much @lovromazgon

I've updated the docs, and added an example:

$ csvtk pretty testdata/date2value.csv
date    views   unique_visitors
-----   -----   ---------------
03/01   7       5              
03/02   5       3              
03/03   39      21             
03/04   37      20             
03/05   59      25             
03/06   23      14             
03/07   49      24

$ cat testdata/date2value.csv \
    | csvtk gather -f 2- -k type -v count \
    | csvtk plot line --group-field type -x date -y count --data-field-x-nominal \
    > testdata/figures/line_plot_date.png

line_plot_date

@lovromazgon

lovromazgon commented Mar 14, 2025

Copy link
Copy Markdown
Contributor Author

Thanks! This will be useful for our benchmarking efforts on Conduit!

@lovromazgon

lovromazgon commented Mar 19, 2025

Copy link
Copy Markdown
Contributor Author

Hey @shenwei356, can you tell me approximately when you intend to cut the 0.34 release? 🙏 Thanks!

@shenwei356

shenwei356 commented Mar 19, 2025

Copy link
Copy Markdown
Owner

are you in hurry?
ah, I forgot to send you the binaries, will send tomorrow.

you can also compile from the source: https://bioinf.shenwei.me/csvtk/download/#method-6-compiling-from-source-latest-stabledev-version

@lovromazgon

lovromazgon commented Mar 19, 2025

Copy link
Copy Markdown
Contributor Author

Oh no, no need to send me the binaries, locally I can compile it myself of course. I'm asking, because I'd like to include the tool in a CI flow and it would be neat if I wouldn't have to depend on a commit, but rather on a released version. That's a minor issue though, I can live with it, if you wanted to postpone the release and include more features 😉

@BrewTestBot BrewTestBot mentioned this pull request May 31, 2025
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

2 participants

@lovromazgon @shenwei356