Inner_join output not string as a column

[Chris6698]

Hello !

I want to join two data frames by the year date of the laydate df. I used the 'inner_join' function and it seemed to work. The data corresponds perfectly.

The problem is in the structure of the said data.

Here's the output:

tibble[,1] [31 × 1] (S3: tbl_df/tbl/data.frame)
$ RCP.2.6.médiane: chr [1:31] "3,3" "3,9" "3,6" "3,7" ...

Eventually, I'll have to plot this data, and it's not accepted in this format.
Is it possible to get it in simple character column like the other ones?
Here are my two data sets:

kanasuta2:

structure(list(yearInt = 1950:2100, RCP.2.6.médiane = c("",
"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
"", "", "", "", "", "", "2,5", "2,9", "2", "3,3", "3,6", "3,3",
"3,7", "3,6", "3,7", "4", "3,9", "2,8", "3,5", "3,5", "3,3",
"4,5", "3,8", "4,2", "4", "3,9", "3,3", "4,2", "3,6", "3,3",
"4,9", "3,2", "4,3", "3,5", "3,6", "4,5", "3,8", "4,1", "4,7",
"3,8", "4,4", "3,9", "4,7", "4,5", "4", "4,2", "4,5", "4,3",
"4,7", "4,7", "4,8", "4,7", "4,3", "4,3", "4,6", "4,4", "4,6",
"4,1", "3,4", "4,1", "4,6", "3,9", "4", "4,8", "4,8", "3,7",
"4,6", "4,1", "4,7", "4,9", "4,4", "3,6", "4,3", "4,1", "5",
"4,6", "4,2", "4,1", "4,1", "4,6", "3,9", "4,8", "5,1", "4,9",
"3,9", "3,9", "4,5", "3,6", "4,7", "4,6", "4,7", "4,9", "3,9",
"3,6", "3,6", "4", "3,4", "4,4", "4,6", "4,3", "4,1", "3,4")), class = "data.frame", row.names = c(NA,
-151L))

laydate

structure(list(anneeInt = c(2008L, 2015L, 2009L, 2013L, 2014L,
2019L, 2012L, 2013L, 2015L, 2013L, 2009L, 2011L, 2013L, 2018L,
2016L, 2008L, 2008L, 2013L, 2014L, 2013L, 2018L, 2014L, 2020L,
2012L, 2020L, 2005L, 2020L, 2021L, 2021L, 2021L, 2021L), linked = structure(list(
RCP.2.6.médiane = c("3,3", "3,9", "3,6", "3,7", "4", "3,3",
"3,6", "3,7", "3,9", "3,7", "3,6", "3,7", "3,7", "3,5", "2,8",
"3,3", "3,3", "3,7", "4", "3,7", "3,5", "4", "4,5", "3,6",
"4,5", "2,5", "4,5", "3,8", "3,8", "3,8", "3,8")), row.names = c(NA,
-31L), class = c("tbl_df", "tbl", "data.frame"))), row.names = c(NA,
-31L), class = c("tbl_df", "tbl", "data.frame"))

Here's my code for the 'inner_join' function:

laydate$linked<-laydate %>%
inner_join(kanasuta2,
by = c(anneeInt = 'yearInt')) %>%
select(RCP.2.6.médiane)

Finally, there is not error message at the inner_join ouput. It's later on that I get this type of error message:

Error in hist.default(datesponte$linked) : 'x' must be numeric

If someone could help me with that, I'm really stucked there!

[jrkrideau]

R is very Anglo-oriented. It looks like you are using , as a decimal marker while R expects a .. By default R will read 3,3 as a character value. I believe there are ways to get around this but I have never used any of them.

Try

kanasuta2$RCP.2.6.médiane <- as.numeric(gsub(",", ".", dat1$RCP.2.6.médiane)) 
laydate$RCP.2.6.médiane <- as.numeric(gsub(",", ".", dat1$RCP.2.6.médiane)) 

to convert RCP.2.6.médiane from character to numeric data.