Hi all, I have a csv (extracted from a web) I attach the data: I use this code to read the data; library("readr") tusDatos <- read_csv('~/datayield.csv') In this CSV, I want to use three columns: tusDatos$DATA_TYPE_FM, (will be X axis) tusDatos$TIME_PERIOD (will be the pivot to search the values) tusDatos$OBS_VALUE (Y Values) In Data_Type_FM I want to plot a graph where only some rows (included in thar colum) will be the X-axis and the Y-axis will be OBS:Value for an specific DATE. So for each day (time period) I will plot a plot imagine 04/08/2020 (a value on TIME_PERIOD) for the values c( PY_1Y, PY_2Y, PY_3Y, PY_4Y, PY_5Y, PY_6Y, PY_7Y) this values are included on DATA_TYPE_FM In excel for me is "easy" but in R I dont know how to proceed can you give me some clue to make this king of operations? If I wanted to do a 3D PloT would be possible? only also for this limited values c( PY_1Y, PY_2Y, PY_3Y, PY_4Y, PY_5Y, PY_6Y, PY_7Y) this values are included on DATA_TYPE_FM tusDatos$DATA_TYPE_FM, (will be X axis) tusDatos$TIME_PERIOD (Z axis) tusDatos$OBS_VALUE (Y Values) Hope I explained properly and hope you can help and guide. datayield.csv <https://drive.google.com/file/d/1WvIIhxXOeg8y_7LssRu0wK9s_c9c03sZ/view?usp=drive_web> [[alternative HTML version deleted]]
Hi Pedro, I'm not exactly sure of what you want, but try this: # I downloaded the CSV file as datayield.csv tus.datos<-read.table("datayield.csv",sep=";",header=TRUE) library(scatterplot3d) data_types<-c("PY_1Y","PY_2Y","PY_3Y","PY_4Y","PY_5Y","PY_6Y","PY_7Y") row_subset<-tus.datos$DATA_TYPE %in% data_types scatterplot3d(tus.datos$DATA_TYPE_FM[row_subset], tus.datos$OBS_VALUE[row_subset], tus.datos$TIME_PERIOD[row_subset], color=order(as.numeric(tus.datos$DATA_TYPE[row_subset]))) legend(9,8,data_types,pch=1,col=1:7,xpd=TRUE) I used a few tricks to get this to work without being too long a script. The color for PY_7Y is yellow, and this can be changed with a bit of extra code. Jim On Thu, Aug 6, 2020 at 8:40 AM Pedro p?ramo <percentil101 at gmail.com> wrote:> > Hi all, > > I have a csv (extracted from a web) I attach the data: > > I use this code to read the data; > > library("readr") > > tusDatos <- read_csv('~/datayield.csv') > > In this CSV, I want to use three columns: > > tusDatos$DATA_TYPE_FM, (will be X axis) > tusDatos$TIME_PERIOD (will be the pivot to search the values) > tusDatos$OBS_VALUE (Y Values) > > In Data_Type_FM I want to plot a graph where only some rows (included in > thar colum) will be the X-axis and the Y-axis will be OBS:Value for an > specific DATE. > > So for each day (time period) I will plot a plot imagine 04/08/2020 (a > value on TIME_PERIOD) for the values > > c( PY_1Y, PY_2Y, > PY_3Y, PY_4Y, > PY_5Y, PY_6Y, PY_7Y) this values are included on DATA_TYPE_FM > > In excel for me is "easy" but in R I dont know how to proceed can you give > me some clue to make this king of operations? > > If I wanted to do a 3D PloT would be possible? only also for this limited > values c( PY_1Y, PY_2Y, > PY_3Y, PY_4Y, > PY_5Y, PY_6Y, PY_7Y) this values are included on DATA_TYPE_FM > > tusDatos$DATA_TYPE_FM, (will be X axis) > tusDatos$TIME_PERIOD (Z axis) > tusDatos$OBS_VALUE (Y Values) > > Hope I explained properly and hope you can help and guide. > > > > datayield.csv > <https://drive.google.com/file/d/1WvIIhxXOeg8y_7LssRu0wK9s_c9c03sZ/view?usp=drive_web> > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.
Hi Jim, Many thanks for your help, I will try a 2D plot and then pass to 3D. I am trying something like this: tus.datos<-read.table("datayield.csv",sep=";",header=TRUE) data_types<-c("PY_1Y","PY_2Y","PY_3Y","PY_4Y","PY_5Y","PY_6Y","PY_7Y") row_subset<-tus.datos$DATA_TYPE %in% data_types x<-tus.datos$DATA_TYPE_FM[row_subset] y<-tus.datos$OBS_VALUE[row_subset] PERIOD<-tus.datos$TIME_PERIOD=="01/06/2020" for (PERIOD="TRUE") { plot(x, y) } And the error is for (PERIOD="TRUE") { Error: inesperado '=' in "for (PERIOD="> > > plot(x, y)Error: no se puede ubicar un vector de tama?o 1.3 Gb> > }Error: inesperado '}' in "}">El jue., 6 ago. 2020 a las 2:24, Jim Lemon (<drjimlemon at gmail.com>) escribi?:> Hi Pedro, > I'm not exactly sure of what you want, but try this: > > # I downloaded the CSV file as datayield.csv > tus.datos<-read.table("datayield.csv",sep=";",header=TRUE) > library(scatterplot3d) > data_types<-c("PY_1Y","PY_2Y","PY_3Y","PY_4Y","PY_5Y","PY_6Y","PY_7Y") > row_subset<-tus.datos$DATA_TYPE %in% data_types > scatterplot3d(tus.datos$DATA_TYPE_FM[row_subset], > tus.datos$OBS_VALUE[row_subset], > tus.datos$TIME_PERIOD[row_subset], > color=order(as.numeric(tus.datos$DATA_TYPE[row_subset]))) > legend(9,8,data_types,pch=1,col=1:7,xpd=TRUE) > > I used a few tricks to get this to work without being too long a > script. The color for PY_7Y is yellow, and this can be changed with a > bit of extra code. > > Jim > > On Thu, Aug 6, 2020 at 8:40 AM Pedro p?ramo <percentil101 at gmail.com> > wrote: > > > > Hi all, > > > > I have a csv (extracted from a web) I attach the data: > > > > I use this code to read the data; > > > > library("readr") > > > > tusDatos <- read_csv('~/datayield.csv') > > > > In this CSV, I want to use three columns: > > > > tusDatos$DATA_TYPE_FM, (will be X axis) > > tusDatos$TIME_PERIOD (will be the pivot to search the values) > > tusDatos$OBS_VALUE (Y Values) > > > > In Data_Type_FM I want to plot a graph where only some rows (included in > > thar colum) will be the X-axis and the Y-axis will be OBS:Value for an > > specific DATE. > > > > So for each day (time period) I will plot a plot imagine 04/08/2020 (a > > value on TIME_PERIOD) for the values > > > > c( PY_1Y, PY_2Y, > > PY_3Y, PY_4Y, > > PY_5Y, PY_6Y, PY_7Y) this values are included on DATA_TYPE_FM > > > > In excel for me is "easy" but in R I dont know how to proceed can you > give > > me some clue to make this king of operations? > > > > If I wanted to do a 3D PloT would be possible? only also for this limited > > values c( PY_1Y, PY_2Y, > > PY_3Y, PY_4Y, > > PY_5Y, PY_6Y, PY_7Y) this values are included on DATA_TYPE_FM > > > > tusDatos$DATA_TYPE_FM, (will be X axis) > > tusDatos$TIME_PERIOD (Z axis) > > tusDatos$OBS_VALUE (Y Values) > > > > Hope I explained properly and hope you can help and guide. > > > > > > > > datayield.csv > > < > https://drive.google.com/file/d/1WvIIhxXOeg8y_7LssRu0wK9s_c9c03sZ/view?usp=drive_web > > > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]