Is there a way to automatically finish many graphs with the same-format data?

Welcome to our Forums Technical Support Support Desk Is there a way to automatically finish many graphs with the same-format data?

  • This topic has 6 replies, 5 voices, and was last updated 10 months ago by owen hildreth.
Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #10329
    petercreate
    Participant

      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

      #10331
      dgteam
      Moderator

        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?

         

        #10332
        jordan
        Participant

          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?

          #10333
          pamela
          Moderator

            Hi Jodan – Good point.

            The dgraph command line interface is another way to set up a batch process.  I have not tested it myself lately, but I believe it should be working in the current beta.

            FYI – Looks like DataGraph 5.1 will be out next week!

            #10336
            petercreate
            Participant

              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

              #11010
              petercreate
              Participant

                Hi,

                I have many columns. Is there a way to paste the text into the menu and make it automatically change to next input?

                #11854
                owen hildreth
                Participant

                  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).

                   

                Viewing 7 posts - 1 through 7 (of 7 total)
                • You must be logged in to reply to this topic.

                Welcome to our Forums Technical Support Support Desk Is there a way to automatically finish many graphs with the same-format data?