What will be the best way to Visualize the following data?
up vote
2
down vote
favorite
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
add a comment |
up vote
2
down vote
favorite
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
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
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
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
plot data-visualization distribution data-science data-analysis
edited Nov 19 at 15:35
asked Nov 19 at 15:26
id101112
174115
174115
add a comment |
add a comment |
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:

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

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.
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
add a comment |
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.
add a comment |
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:

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

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.
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
add a comment |
up vote
2
down vote
If you're mainly interesting in variable within ID, then ignore the timestamp and show the data by ID:

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

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.
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
add a comment |
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:

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

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.
If you're mainly interesting in variable within ID, then ignore the timestamp and show the data by ID:

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

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.
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
add a comment |
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
add a comment |
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.
add a comment |
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.
add a comment |
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.
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.
edited Nov 19 at 15:51
answered Nov 19 at 15:39
Alexander Meade
116
116
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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