I have two files.
date,colA 2016-01-01,1 2016-01-02,4 2016-01-03,2
date,colB 2016-01-01,2 2016-01-03,4
I'd like to combine these to get equivalent of:
date,colA,colB 2016-01-01,1,2 2016-01-02,4,0 2016-01-03,2,4
So I want to append colB to original data and all missing dates from
B.csv should have value 0 added. The resulting data will be plotted with pgfplots.
Is this possible with LaTeX, pgfplots or pgfplotstable? We can safely assuma that
A.csv has all the needed dates.
Or is it possible to add the missing rows first to
B.csv before merging?
My current solution is to add the missing rows manually and then use
\pgfplotstablecreatecol[copy column from table=... macro.
EDIT: I'm using Overleaf so the solution should work there aswell.