Displaying 2 results from an estimated 2 matches for "vanrenterghem".
2011 Dec 13
1
plotting 2 Y-axes, aligning the 0 value
...t;,side=1,col="black",line=2.5)
# Add Legend
legend(5,7000,legend=c("Beta Gal","Cell
Density"),text.col=c("black","red"),pch=c(16,15),col=c("black","red"))
Thanks in advance for any help you can provide!
Best regards,
Frederik Vanrenterghem
2012 Jan 03
1
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
number of POSTAL that belong to any given INSEE, and diving the value
of the postal in that INSEE by