[R] sqldf and not converting integers to floating point in SQLite

Hi, I have following 2 tables: Table 1: POSTAL | VALUE 1000|49 1010|100 1020|50 Table 2: INSEE | POSTAL A|1000 B|1000 C|1010 D|1020 I would like to convert this to the following: INSEE | VALUE_SPREAD A|24.5 B|24.5 C|100 D|50 I can achieve this with a nested SQL query (through counting the

[R] plotting 2 Y-axes, aligning the 0 value

(16,15),col=c(black,red)) Thanks in advance for any help you can provide! Best regards, Frederik Vanrenterghem __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org