[R] Print and plot a cross Data

[Jim Lemon]

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