What will be the best way to Visualize the following data?











up vote
2
down vote

favorite
1












what will be the best way to show the difference between the distance points with the timestamps on the plot? or what kind of distributional chart will be suitable in this case? because I have thousand points with multiple ID's can't just go through the whole data.



Example:



ID   DateTIme                 Distance
1 2011-01-23 00:56:59 0.452323
1 2011-01-23 00:57:00 0.746908
1 2011-01-23 00:57:00 0.945455
1 2011-01-23 00:58:00 0.456253
2 2011-01-23 00:42:00 0.098822
2 2011-01-23 00:43:00 0.156353
2 2011-01-23 00:44:00 0.001271
2 2011-01-23 00:44:59 0.766617
3 2011-01-23 00:55:00 0.198188
3 2011-01-23 00:56:00 0.009182
3 2011-01-23 00:57:00 0.167261
3 2011-01-23 00:57:59 0.126766


please just mention the ideas?
Thank you










share|improve this question




























    up vote
    2
    down vote

    favorite
    1












    what will be the best way to show the difference between the distance points with the timestamps on the plot? or what kind of distributional chart will be suitable in this case? because I have thousand points with multiple ID's can't just go through the whole data.



    Example:



    ID   DateTIme                 Distance
    1 2011-01-23 00:56:59 0.452323
    1 2011-01-23 00:57:00 0.746908
    1 2011-01-23 00:57:00 0.945455
    1 2011-01-23 00:58:00 0.456253
    2 2011-01-23 00:42:00 0.098822
    2 2011-01-23 00:43:00 0.156353
    2 2011-01-23 00:44:00 0.001271
    2 2011-01-23 00:44:59 0.766617
    3 2011-01-23 00:55:00 0.198188
    3 2011-01-23 00:56:00 0.009182
    3 2011-01-23 00:57:00 0.167261
    3 2011-01-23 00:57:59 0.126766


    please just mention the ideas?
    Thank you










    share|improve this question


























      up vote
      2
      down vote

      favorite
      1









      up vote
      2
      down vote

      favorite
      1






      1





      what will be the best way to show the difference between the distance points with the timestamps on the plot? or what kind of distributional chart will be suitable in this case? because I have thousand points with multiple ID's can't just go through the whole data.



      Example:



      ID   DateTIme                 Distance
      1 2011-01-23 00:56:59 0.452323
      1 2011-01-23 00:57:00 0.746908
      1 2011-01-23 00:57:00 0.945455
      1 2011-01-23 00:58:00 0.456253
      2 2011-01-23 00:42:00 0.098822
      2 2011-01-23 00:43:00 0.156353
      2 2011-01-23 00:44:00 0.001271
      2 2011-01-23 00:44:59 0.766617
      3 2011-01-23 00:55:00 0.198188
      3 2011-01-23 00:56:00 0.009182
      3 2011-01-23 00:57:00 0.167261
      3 2011-01-23 00:57:59 0.126766


      please just mention the ideas?
      Thank you










      share|improve this question















      what will be the best way to show the difference between the distance points with the timestamps on the plot? or what kind of distributional chart will be suitable in this case? because I have thousand points with multiple ID's can't just go through the whole data.



      Example:



      ID   DateTIme                 Distance
      1 2011-01-23 00:56:59 0.452323
      1 2011-01-23 00:57:00 0.746908
      1 2011-01-23 00:57:00 0.945455
      1 2011-01-23 00:58:00 0.456253
      2 2011-01-23 00:42:00 0.098822
      2 2011-01-23 00:43:00 0.156353
      2 2011-01-23 00:44:00 0.001271
      2 2011-01-23 00:44:59 0.766617
      3 2011-01-23 00:55:00 0.198188
      3 2011-01-23 00:56:00 0.009182
      3 2011-01-23 00:57:00 0.167261
      3 2011-01-23 00:57:59 0.126766


      please just mention the ideas?
      Thank you







      plot data-visualization distribution data-science data-analysis






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 19 at 15:35

























      asked Nov 19 at 15:26









      id101112

      174115




      174115
























          2 Answers
          2






          active

          oldest

          votes

















          up vote
          2
          down vote













          If you're mainly interesting in variable within ID, then ignore the timestamp and show the data by ID:



          enter image description here



          If the times are important, too, you can put time on the X and try color for each ID.



          enter image description here



          But color doesn't scale past 10 or more colors. In that case you could make a small graph for each ID or use a unique shape for each ID's dots.






          share|improve this answer





















          • I thought of it, but when there are 1000 of ids, it becomes clutter, you won't understand what's going on
            – id101112
            Nov 21 at 14:44


















          up vote
          1
          down vote













          A bar graph with the time stamps grouped under each bar with a each bar having values of two distance's and they will encompass anything between those. Almost any kind of graph would work, come to think of it, but I believe that the bar graph works best. In case this isn't clear, what I"m saying is to divide your timestamps into groups by their distance's and then to set up a graph which shows which timestamps belong with the closet bar on the graph (by distance). Ex.
          Example Graph



          Edit: Sorry, but I do not know if this will be helpful because I do not know the context of why you need this graph. Did my best.



          Edit2: The ID's are (*as far as I can see) irrelevant to the distance-to-timestamp relationship, so if you want to throw the ID next to wherever you show the timestamps that should be fine.






          share|improve this answer























            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53377797%2fwhat-will-be-the-best-way-to-visualize-the-following-data%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            2
            down vote













            If you're mainly interesting in variable within ID, then ignore the timestamp and show the data by ID:



            enter image description here



            If the times are important, too, you can put time on the X and try color for each ID.



            enter image description here



            But color doesn't scale past 10 or more colors. In that case you could make a small graph for each ID or use a unique shape for each ID's dots.






            share|improve this answer





















            • I thought of it, but when there are 1000 of ids, it becomes clutter, you won't understand what's going on
              – id101112
              Nov 21 at 14:44















            up vote
            2
            down vote













            If you're mainly interesting in variable within ID, then ignore the timestamp and show the data by ID:



            enter image description here



            If the times are important, too, you can put time on the X and try color for each ID.



            enter image description here



            But color doesn't scale past 10 or more colors. In that case you could make a small graph for each ID or use a unique shape for each ID's dots.






            share|improve this answer





















            • I thought of it, but when there are 1000 of ids, it becomes clutter, you won't understand what's going on
              – id101112
              Nov 21 at 14:44













            up vote
            2
            down vote










            up vote
            2
            down vote









            If you're mainly interesting in variable within ID, then ignore the timestamp and show the data by ID:



            enter image description here



            If the times are important, too, you can put time on the X and try color for each ID.



            enter image description here



            But color doesn't scale past 10 or more colors. In that case you could make a small graph for each ID or use a unique shape for each ID's dots.






            share|improve this answer












            If you're mainly interesting in variable within ID, then ignore the timestamp and show the data by ID:



            enter image description here



            If the times are important, too, you can put time on the X and try color for each ID.



            enter image description here



            But color doesn't scale past 10 or more colors. In that case you could make a small graph for each ID or use a unique shape for each ID's dots.







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Nov 19 at 16:08









            xan

            5,70122438




            5,70122438












            • I thought of it, but when there are 1000 of ids, it becomes clutter, you won't understand what's going on
              – id101112
              Nov 21 at 14:44


















            • I thought of it, but when there are 1000 of ids, it becomes clutter, you won't understand what's going on
              – id101112
              Nov 21 at 14:44
















            I thought of it, but when there are 1000 of ids, it becomes clutter, you won't understand what's going on
            – id101112
            Nov 21 at 14:44




            I thought of it, but when there are 1000 of ids, it becomes clutter, you won't understand what's going on
            – id101112
            Nov 21 at 14:44












            up vote
            1
            down vote













            A bar graph with the time stamps grouped under each bar with a each bar having values of two distance's and they will encompass anything between those. Almost any kind of graph would work, come to think of it, but I believe that the bar graph works best. In case this isn't clear, what I"m saying is to divide your timestamps into groups by their distance's and then to set up a graph which shows which timestamps belong with the closet bar on the graph (by distance). Ex.
            Example Graph



            Edit: Sorry, but I do not know if this will be helpful because I do not know the context of why you need this graph. Did my best.



            Edit2: The ID's are (*as far as I can see) irrelevant to the distance-to-timestamp relationship, so if you want to throw the ID next to wherever you show the timestamps that should be fine.






            share|improve this answer



























              up vote
              1
              down vote













              A bar graph with the time stamps grouped under each bar with a each bar having values of two distance's and they will encompass anything between those. Almost any kind of graph would work, come to think of it, but I believe that the bar graph works best. In case this isn't clear, what I"m saying is to divide your timestamps into groups by their distance's and then to set up a graph which shows which timestamps belong with the closet bar on the graph (by distance). Ex.
              Example Graph



              Edit: Sorry, but I do not know if this will be helpful because I do not know the context of why you need this graph. Did my best.



              Edit2: The ID's are (*as far as I can see) irrelevant to the distance-to-timestamp relationship, so if you want to throw the ID next to wherever you show the timestamps that should be fine.






              share|improve this answer

























                up vote
                1
                down vote










                up vote
                1
                down vote









                A bar graph with the time stamps grouped under each bar with a each bar having values of two distance's and they will encompass anything between those. Almost any kind of graph would work, come to think of it, but I believe that the bar graph works best. In case this isn't clear, what I"m saying is to divide your timestamps into groups by their distance's and then to set up a graph which shows which timestamps belong with the closet bar on the graph (by distance). Ex.
                Example Graph



                Edit: Sorry, but I do not know if this will be helpful because I do not know the context of why you need this graph. Did my best.



                Edit2: The ID's are (*as far as I can see) irrelevant to the distance-to-timestamp relationship, so if you want to throw the ID next to wherever you show the timestamps that should be fine.






                share|improve this answer














                A bar graph with the time stamps grouped under each bar with a each bar having values of two distance's and they will encompass anything between those. Almost any kind of graph would work, come to think of it, but I believe that the bar graph works best. In case this isn't clear, what I"m saying is to divide your timestamps into groups by their distance's and then to set up a graph which shows which timestamps belong with the closet bar on the graph (by distance). Ex.
                Example Graph



                Edit: Sorry, but I do not know if this will be helpful because I do not know the context of why you need this graph. Did my best.



                Edit2: The ID's are (*as far as I can see) irrelevant to the distance-to-timestamp relationship, so if you want to throw the ID next to wherever you show the timestamps that should be fine.







                share|improve this answer














                share|improve this answer



                share|improve this answer








                edited Nov 19 at 15:51

























                answered Nov 19 at 15:39









                Alexander Meade

                116




                116






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.





                    Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                    Please pay close attention to the following guidance:


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53377797%2fwhat-will-be-the-best-way-to-visualize-the-following-data%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Paul Cézanne

                    UIScrollView CustomStickyHeader Resize height generates problems when scroll is too fast

                    Angular material date-picker (MatDatepicker) auto completes the date on focus out