DataGraph Forums › Technical Support › Support Desk › Is there a way to automatically finish many graphs with the same-format data?
Tagged: automation graphing
Hi,
I have many text data files in the same format and need to do separate graphs from the files.
It’s tedious to do that manually.
Kind regards,
Peter
There are different ways you could do this depending on your specific use case.
If the graphs you want to make are all the same except you have a different set of inputs, one possiblity would be to set up one graph and use a Text Menu with a mask, such that when you change the selection in the Text Menu the data in the graph will update.
Then on the Text Menu, you can output every version of the table at once using the batch output option, which is described here:
https://community.visualdatatools.com/datagraph/knowledge-base/variable-string-from-menu/
This requires you to have all the data in one table. There are two ways automate this process with multiple files.
One way is to drag and drop all the files at once onto the Data List side panel. That will create a group for each file where the file name is the group name. Then place all of these group in one overall group. Once that is done, use the Append subgroups option on the overall group as described here:
https://community.visualdatatools.com/datagraph/knowledge-base/append-groups/#append-subgroups
Another way is to use the Import Special to create a parser and select all the files as input. Before you import you can check a box to include the file name as a column. Unless your data is rather complicated, I would recommand the Appends subgroups method first, rather than the Import Special, which may take more time to set up.
Does this help?
In the past I have used the command line interface with the dgraph command to do this. I am unsure if it is still supported. What do you think Pamela?
Hi Pamela,
Thanks for the method, which I believe will work in most cases. Mine is a little annoying. Because my data (.csv files) are in different folders with the same name. In the same folder, there are two csv files which need be concatenated first. There are tens of folders. After being concatenated and imported into DG’s data sheet, I’ll do pivot to calculate the yearly average to get a series of yearly means and stdevs, because the data are on a daily resolution.
It seems that the issue would be extended to another auto data importing task. After setting up this, I can use the method you provide to do the latter job.
Regards,
Peter
Hi,
I have many columns. Is there a way to paste the text into the menu and make it automatically change to next input?
https://github.com/HildrethResearchGroup/Graphs
Me and some CS students wrote a program using the DataGraph framework to help organize and visualize 2D data. Graphs connects your data, DataGraph templates, and simple parsers so that you simply select a file and the data will be automatically parsed and graphed. It has the ability to export your files as a DataGraph file (right click).
DataGraph Forums › Technical Support › Support Desk › Is there a way to automatically finish many graphs with the same-format data?