Re: [R] How to create a readable plot in R with 10000+ values in a dataframe

2020-07-30 Thread Ritwik Mohapatra
Hi All, Thanks for all the suggestions and help.I have gone for simpler plots with lesser values for demonstration now which served the purpose. Regards, Ritwik On Thu, 30 Jul, 2020, 22:00 Dr Eberhard Lisse, wrote: > I always find two things helpful > > 1) RTFM > > 2) Asking myself what inform

Re: [R] How to create a readable plot in R with 10000+ values in a dataframe

2020-07-30 Thread Dr Eberhard Lisse
I always find two things helpful 1) RTFM 2) Asking myself what information do I want to convey before thinking about how to do that. >From the below I can not understand what you want to tell your audience. I don't think it's helpful trying to read 17298 names on a plot so maybe show the

Re: [R] How to create a readable plot in R with 10000+ values in a dataframe

2020-07-30 Thread Jim Lemon
Hi Ritwik, Carlos made an excellent suggestion and there are at least two ways to plot "machine" and "region" as the cells in a 2D matrix and then add two more variables (say count and price) as the attributes of each cell. Is the data you are using publicly available? If so a demonstration of this

Re: [R] How to create a readable plot in R with 10000+ values in a dataframe

2020-07-29 Thread Abby Spurdle
On Sat, Jul 25, 2020 at 12:40 AM Martin Maechler wrote: > Good answers to this question will depend very much on how many > 'Machine' and 'Region' levels there are. I second that. And unless I missed something, the OP hasn't answered this question, as such. But "10k+" combinations, does imply aro

Re: [R] How to create a readable plot in R with 10000+ values in a dataframe

2020-07-29 Thread Carlos Ortega
Hello Ritwik, There is another possibility. You can count (crosstab) the number of elements for each Region and Machine (with table() function) and represent this table with geom_tile() function. Wit this you will get an equivalent of a heatmap which will give you a good sense of which combinatio

Re: [R] How to create a readable plot in R with 10000+ values in a dataframe

2020-07-29 Thread Jim Lemon
Hi Ritwik, I haven't seen any further answers to your request, so I'll make a suggestion. I don't think there is any sensible way to illustrate that many data points on a single plot. I would try to segment the data by machine type or similar and plot a number of plots. Jim On Fri, Jul 24, 2020 a

Re: [R] How to create a readable plot in R with 10000+ values in a dataframe

2020-07-24 Thread Ritwik Mohapatra
Hi All, These are the two codes i have used so far:- ggplot(df3_machine_region,aes(Region,Machine.Name)) + geom_count() !![2nd Plot|690x375](upload://gTyYUXe6lPJXCdyvqRBtUZ8zsyL.png) [1st Plot|690x375](upload://bb0ux9WheqM4ViyYf3Gki6TKtlG.png) ggplot(df3_machine_region,aes(Region,Machine.Name))

Re: [R] How to create a readable plot in R with 10000+ values in a dataframe

2020-07-24 Thread Martin Maechler
> Ritwik Mohapatra > on Thu, 23 Jul 2020 23:41:57 +0530 writes: > How to create a readable and legible plot in R with 10k+ values.I have a > dataframe with 17298 records.There are two columns:Machine Name(Character) > and Region(Character).So i want to create a readable pl

Re: [R] How to create a readable plot in R with 10000+ values in a dataframe

2020-07-24 Thread Duncan Murdoch
On 23/07/2020 2:11 p.m., Ritwik Mohapatra wrote: How to create a readable and legible plot in R with 10k+ values.I have a dataframe with 17298 records.There are two columns:Machine Name(Character) and Region(Character).So i want to create a readable plot with region in x axis and machine name in

[R] How to create a readable plot in R with 10000+ values in a dataframe

2020-07-24 Thread Ritwik Mohapatra
How to create a readable and legible plot in R with 10k+ values.I have a dataframe with 17298 records.There are two columns:Machine Name(Character) and Region(Character).So i want to create a readable plot with region in x axis and machine name in y axis.How do i do that using ggplot or any other w