Hello,
I wrote
> setwd("D:/")
> dd <- read.table(file="test.txt",header=TRUE)
> attach(dd)
> boxplot(x)
> outlier <- function(y){
+ out <- boxplot(y, range = 1)$out
+ outliers <- which(y == out)
+ dev.off()
+ return(out,outliers)
+ }
> outlier(x)
$out
[1] 1.950208 2.082025 4.768637 4.800333 5.529516 1.657321 4.656504 2.138956
[9] 4.437906 4.716786
$outliers
[1] 23
Warning messages:
Could you tell me please why do I have Warning messages and why I do not get
all the id for the outliers in out, but only for the id=23? Thank you very much
in advance!
Amor
DUPREZ Cédric <[EMAIL PROTECTED]> schrieb:
Hello,
The problem seems to be in the query syntax.
Can you show us the query you are trying to perform ?
Regards,
Cedric
-----Message d'origine-----
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Bernhard
Wellhöfer
Envoyé : vendredi 6 juillet 2007 11:45
À : [EMAIL PROTECTED]
Objet : [R] RODBC problem
Hello,
I use a RODBC connection to a MySQL server on a Debian machine. The call to
odbcConnect() seems to be ok, but the result of the first
sqlFetch(channel,"t_studie") retrieves this data frame:
[1] "[RODBC] ERROR: Could not SQLExecDirect"
[2] "42000 1064 [MySQL][ODBC 3.51 Driver][mysqld-5.0.22-Debian_1bpo1-log]You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '\"t_studi(\004"
Please note the funny character at the end of the table name in the error
message.
The "Test Data Source" option on the ODBC Data Source Name configuration panel
report success.
Who can help me here?
Regards,
Bernhard
[[alternative HTML version deleted]]
______________________________________________
[EMAIL PROTECTED] mailing list
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.
______________________________________________
[EMAIL PROTECTED] mailing list
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.
---------------------------------
id x
1 4.06943540913829
2 2.96711556178828
3 2.84317433381608
4 3.0233326530084
5 3.85313325683431
6 3.25176642540998
7 3.10428292446304
8 2.96910969433375
9 2.9552241744784
10 2.62429504388322
11 3.99268191373752
12 2.96086444531102
13 2.56744536717112
14 2.70121781167885
15 3.24684936804697
16 3.44327843924208
17 1.95020800627147
18 2.85980163644223
19 2.08202506958817
20 3.75122539005242
21 2.80888893178975
22 2.72440101567966
23 4.76863738451308
24 2.52030319968859
25 2.67162836262335
26 4.80033291215853
27 5.5295157545479
28 3.3974985398585
29 1.65732147122423
30 2.6442432979277
31 2.92896331334487
32 3.56828110031007
33 4.23621195722371
34 4.20075765202443
35 3.04216649315786
36 3.00065558135975
37 3.39899348717493
38 3.54186669950529
39 2.74577497065378
40 3.65806540173944
41 3.46080563866999
42 2.92364287919675
43 3.169530359221
44 2.81895832319278
45 4.65650428778026
46 3.13441576954598
47 2.46801579285723
48 3.60142459427783
49 2.62527443655611
50 3.11076163999581
51 2.73691336452806
52 3.06547273028021
53 2.31910454262203
54 2.84718685060895
55 2.73166022216125
56 2.50319833013540
57 3.28071111459285
58 2.22834208288696
59 2.57010740370024
60 2.92808256618058
61 3.47106674606136
62 2.89531828685819
63 3.14043589053520
64 3.60737829250284
65 3.349362441975
66 2.96643008153575
67 2.28158329744668
68 3.6684784632797
69 2.84333811049970
70 2.56603097492674
71 2.74439896339706
72 2.76673743269251
73 2.83901303251429
74 3.93860235569688
75 2.93421458375330
76 3.70193059685019
77 3.16669984232479
78 2.52111948256691
79 2.86827457189405
80 3.64035327618476
81 2.82257612117100
82 3.91084601867478
83 4.06337629602446
84 2.65069938607048
85 2.13895648311203
86 3.07094698739238
87 3.04251032825559
88 2.93832702325502
89 3.18925517662428
90 2.82310710876094
91 3.53555026048950
92 2.43346150685102
93 3.17505082308004
94 3.33696962712177
95 2.75327610347886
96 3.16884796114173
97 2.87430885351884
98 3.96319270382325
99 3.33724518129602
100 2.84952674324159
101 3.14071286918285
102 3.46932903729224
103 3.28243304083589
104 3.57372678583488
105 3.0976892345973
106 2.16390992379747
107 2.85859095019599
108 2.90054252846166
109 2.99949436219564
110 2.56974096827519
111 3.27703713781666
112 3.62234989470647
113 4.43790556634
114 3.18717449896503
115 3.36905281827009
116 2.99463205555609
117 3.26802819091051
118 3.0162905472874
119 3.22195713599212
120 2.86152638645532
121 3.90045830376136
122 3.88060585245645
123 3.57073100456813
124 3.39689582475306
125 3.27616451291833
126 3.02124628067637
127 3.24026669842036
128 2.91099446955292
129 3.38013108442537
130 3.31280212258765
131 3.58984034196474
132 3.25476661583719
133 2.83035967760564
134 3.65837748696407
135 3.45577687692518
136 2.88136124113419
137 3.71698292430956
138 3.68312346801783
139 3.47926656277074
140 3.70918777182233
141 2.58824066047867
142 2.81264629679887
143 2.38875123289569
144 2.55414096066573
145 3.13083078961354
146 3.72288304327521
147 3.08850272840355
148 3.92878601560369
149 3.15040033654465
150 3.07087971722552
151 3.14288150583549
152 2.71404525289157
153 3.33480656778750
154 3.68782929440495
155 2.973928783671
156 3.54318666419325
157 3.38733836800481
158 3.41014787564054
159 3.73602262906885
160 3.46717029961292
161 4.09646711430978
162 3.77413842446016
163 4.71678569001767
164 3.22934722053663
______________________________________________
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/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
