d2'}# :@ Nw(/`:mp%ָds}ɷ`:]qhio 1&f^u|/8XX9?`[1(S.el H&ٔ8Vhl@8MS8P8@ @'ŏ $u%t!RZ4}^rUM>Xۮ2}aωk I(yGϲ bJb/}=>OUOb| {ZTVKu_rr#=t++cLr3;r))^k&uڼ:T9;yILq0..}o;nغIq1}f@J3UTRQKIB*z<ƸNBa#t8qUS#h9o:4UVWrѱUI/E1|RMDpX k@NjxZVt5F?m y 9k5ۖO -bM֞iݹb+~߸#I"gC5Eip_­Xk88P(0B +@5h0E7,K &^#;$+ pt)˜$g2LGi^9<͎wvCyjМ12/Li$1e>乄7 ƹ6eJ '% lzehQZ4%j#C!FL[f(/`@ 3TwheelrootZi;^]Kb KP0 5&uaԞюaKºN@tB*Siw0DÚPGД Ֆ3!KUXQDŽ#\uj~V}ϭs$tڎKYx *;%z(hDs,d#MP>;0e !ݓXqtWM͙,G۠ N ~0Ć$܂bim2_z2v|"5 *+auŘvc}XO :j"qo}!—!Ox :"q\-Vtޝd َm}^JO9s@/lQ2X.uK4?mcX㞌yJ, ]~}ªFBU+Z/8.'.QBǂJs]K}"ravenlibRlibrarysqldfMetaRd.rdsdemofeatureshsearchlinknsInfpackageR.rdbx-groupchoose.-unitTests.RhelpAnIndexaliaspathhtml00.tdoSvUnit.Rr.all.RDESCRIPTIONINDEXNAMESPACENEWSTHANKScsv.awktrcomma2dot.vbs(@"#>`4)Q$Ԑ$Qnia=9?1h D=_Vya6hk2`w 1Ny(eb# w PxN%pBH9U4 >tU >**~,ÝfzH~C*ALW@ lRRTc : 6 }~?L]ۥ1 GϜ2f %dSc 3YO dc3c[(/Nw S}QN0 ]u&!qB#\CM]ZjUo8$MJmϮ6@D`/o](7U߼K"ayg*"xjpe}L TkC.hW+>ꧢ%\qhU`qhJS\C*<1X|Nji+8;aߌ ~/#hdq[DjX/MSݰ'.gH*]/8eO Ad8 ΑS},ODQgn>ЗzڶV MNK 0v tkW xQpi&I<8Y @y! + R=Ӝg^CݜنIu:JgwI>^ZCHd<6p9S >xӦE~Di-*uZ ^|^b```f`aeb`feLLF , @Z(-%,B#18x]vvk@nkk X尝ofǵvA@c+Dm)˧_"[ Ԡ3L{$d"m;rG|)TEF{3IY(/P;fH@bgs.Q|FR$BDq$K>>8V6J$qU\K5/B{Wcy臏7N?j=j<L7""NLw!S`:4X-g5OC*ס֪DB{s m"U,g@vÁG6 6ԁunDHXL Jzz@T\Q_\\RC%[TR&FRּb +n0 Mڂ1!\6$&mp5,)1xiV/,ۿm 2 YMyU ?NL6qp| ?TzFs0p^D/hl$\mj] 敖 ʔ׽H4~yÓNP(㚫~nyƝCK0kkE[2F*L@M[s%O}{|tzw0m (aVmOF6yU=*( H tPrHpG *Uico]w]ɗHyyrZwzowT^+4YFl=w7Vv7FҾ"%iDΈ" *N2͏F ͐=P>w۝oD&,f "VcF"(*mvھEtBX}aP]?r1-W,$i|!HI DDr?V יH*( Pd<,DL@j4 3LJ. H$ FC"i$uV3s6K¸QLTA2$W/`hDU๺2Y i*T PEńq:ŏ8 ,zE (pGƧ>Ui5$p}ࢴP) >RO"Ð"0a2Xh@.L >, b"ayЬqTf eAPDm57<)с ]?{\MQ]Rf!eR5wDJͺ! ՁPD=w &]eYx|>F|Lu@͍g'"__vJv8]FYe)gd+<6ol{}==(N ?chlk|?ԟzUxAכ캯@Bo?ᦜ^+bY2.vO mW?bdB԰W["ij 33*}h~2U4$lfzF}v& C*ݯ^n/Oƭ4hQz=̣5_`Jܺ"x GgA29ؾN6IW҃f ]&s"FU$ݧRL`LA<0eNxzV2j݊7cֽ{Yi|E TBrt;9ESYR>CأWgb3XI#oMbNVOeel=Ks^WJ^6^ A[JH=ς7Q$F>x^/eC~Iziq-x^E.b r b β_IKR[3knΜls]\^|_'f!޴{K&~{Zi-NoZɝa# File share/R/nspackloader.R # Part of the R package, https://www.R-project.org # # Copyright (C) 1995-2012 The R Core TeamThis program is free software; you can redistribute it and/or modifyit undertermsGNU General Public License as pshed bFS Foundation; either version 2, or(atr op) any lat.d inhope thatwill be useful,but WITHOUT ANY WARRANTY; without eveimplied warranty ofMERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Seefre detailsA copyis available atr/s/ local({ info <- ingNameeInfo()pkg$pkgnamens.get(as.(pkg)if (is.null(nsstop("cannot find n environment",, domain = NA);dbbasefile.path(lib"RlazyLoad(, ns,= func(n) n != ".__NAMESPACE__.") }) xV( ,L@$Z d@$G(VHlzXq$edCly90WbIIQfRiI*L%86'?9;5d+.x]MA (`LJӃ4DATHCdwggggO @!9>CI=0l  vo3xit҇8ysO%%9)r/$ݭ{ HʆuR:VFxl֏՚57x[[oFfm)vm-Wӭ-F^i6& A#k$l?sm3\ vZ0"i.gΜw#X`9tn ? X}EΒɥ1Iۖx-j^^Vcz=]Zz9[~U+8/PSj]0J1cעA ["No"{WY=N1,NJ3k)g30>GPN$^G[Ijd5W5p ==:se7θ^Nzɀ&E07Pa4j _FQ2/4Op6?Ǿ2ړ@JsyOMfi6>{Z f^#'FC&V#7YDo*4TJXĤVegl; <9orf(M% zOkհHCA{(Sny՝ )ķq 'LǓC4aRWu[3ATn*$Cwe幨Qlxy'x/=ݏɄ6@! QS*֛βKI+@{8aZT&uSsዦj ĉMc+aAҽ#攱=%G3vfc^4Iwᦉ\:K @2&Uzi|OWp%uvjkzu We&ִֽ]&1 O\F 8 4%#Ur7kk er㦰J- 2-_ZFRS 7[ziEN`jb!C.ĥS\3V, -JH &WUȶ(Ŕư ͵uٳ_^z !Mf:9Fm@S +$Z` fUYc_X@݊@Aqжmkqٶ5fk[?mk,)JSwivS0#]냝F+'ha8ILx mcS-lHF,pԂv#hg3XSSP{F*EjY{b5&bZidz2m ǽcw{Y}nW#w&zHcq ~2zh R많>BF_n$9FvҷMtnd8ne.  w*}>(U| IXVmVi} qi*3-MֵC߶xmk+^[w;p&$/d^+Dz8*HTͷBcBYzKd"vZ^AlKa 5՘x8eCy,UpChMQIhJ6.hbdYkJx3Z/HOfs#P)D=`i4e&ߺsQIL%xt3+V)#< b "?cOܑ"~* }PT1LRS14j;*cBWkj&GZJv?"Z78P".`5?OQEQc /F=^zWQs!g9;,|:=\{̼"?&]'/%F8pƁ;JZ5B*}Lp3##:N%~V{(1M;iiy{"$U*9{'>uS.L>^ -wOsl<ΝG`0q$]H|Ǟ<;GBroUK)/IޖR T)SR+orJ*唔 t_1#TeVrvGO7Ҵk)e3ͽS"6כ|0F›K?Lq"]+z}>^0pIUUM m?Ip<~>Թ5ӊ7I?{CU?=랛2XࣉH,4 η8_Y"y.[l{^})z<.SqgyEZRfOu,)%Tawu bE|uzv ҷ7C'R3WO-tK6ISs:gkNAog!]9Q"D!Qo9czuk88vplGq7ElvG܎io 7wh[%ՠ/W[)InN`Ļ^@%DPNA@/4 Z1o`l B1KB^@_.#1VD*320piœ4*Y:%x[V-IhA 1 l,m ^`ld$ afdC$ϐi''XV":Oխ[+uKy1cm~/~iq6~[,n^j[.__rLJ%\f ٽZb6@ݠ~6Vpj6[&$R:J٪LWT\nɗ%\e| \>[Ȥjߕ{£BZ2rp5Ta{L-q$G5חJGg룍-ظ ~]a#iy2>qQt v'&(g78{C8K8Apscp^B|I8.ἂ8 ˄sp&9NEyL8<ǟ ě\ ! N~?a%wspMUa89zoplquc!o>Atorw%F AXG/?:>'8>FeD8~I8>g%=__5Wmpm_+ m?%paLx5' #sag}P32"ʈ߂k\%cj}xCIw{DhezOSʽ1Fǿ)K bODyrAF<dm|muyۏcn|d>A j5_Fo@J_OS׏I~`@\3ѽTJ՚|~܋8t/ʏtI¯.sBV~u;ǡ_q_.>3~YoW_tא/MTa F,dWʯQ~9kIMX5aes"V~]qפCZ5e״_Q+f5Яkr4]R}fz=>RG#r-Rl3ּwH>s2`un(櫩a`B#e@Wi2m}ZZ1.1Z/3 ޱkUy z[U|>c%ʳS3}뗘zό ܯ \]k^'m!EzU]kXs} Qe+X7YlnjCfz#fpc-S\kXHD5}ә Cu2bΤpmRǦ9͓RF{5xbntFjwӜTL>5_j%=X*zN$ݔ/ D3^>-^2ݙencǟt>|EoL 1chwIwɔ{ȉSW9PΟcަjʃ1-?SRqVby1=>՘Ć1oz` =Ҭ_i鎋n StcAa3 \ghaavbԞ:F]CQ8~Qu@888fχf\g \c8xq18i']1RƹXE 4bqκyx9c.sы:߰9=##. PZM=o!/+}x5ico#.#A%jݪQ;{"׼&ѵ G{ڊ' eǵ+kuD-}zD@VnaKMCGjء]4ƼcZXrlO~jO퐘K!&*O4P5'}n'ӧLRӻ {ݮSԠN^u @so~f?om+~Zk>ŗ3O;|xNb^?ks?O뎵h1l~!@Y@{ZG .@`X` & L$)`Zs@ `[<"pXl{ u#ښ'&r6<ʽ{K6 )Rg6;^ėW6~[ݵ} m AV@N %(DU|Zؿ{n]xݖO@7~ 7)PJ-E\ZN=!U*^8 'NmG{KUt7L6+_id3V"DQ%"~QH^λ]*Q*`T8Mq74خ [͎uQXvn[mۧwЄv_H[ }Y];H܄a%p 2V$>Q{T&Iqlm7J-ZATk7jvF?jBG㯟PllfriV**jj<R.yCEj e{.#Ӟ kiOR[<πYx^/X/5:%x ~ ނO}Fzn ?%#xR<Nsg 57΅Bz); Hy8<մ0z!Gv<9ׄf+׎zjSVNdjZ+hN?lyw y:?#+<rpCx-۵v^h^p}Dj]XgvB$4I-M/IM/̳ω .cDc$lx O`U X`l. zGՈgxʞf r2B-{);}@UKXQuRz."įGx>|F IM֢9Q=[? -&oӷ {mDO2xOg;:tl;u3󌗆-zg܎u+fЗsҗ3+9+՜ՌZNZF}='}=Q~RN.ew9'rFJN՜k9OL)uY L[5Nx}|읺nLqanlcc ڸЌ-NI>[w' I( B/ !4C B-$/og۷3;ϣyڼ3G1⬢2╌3V7'1VjͰ2|g[;Xg9y?_ȥ39l.o⭟6]$R:TfM:Dž@/ThϙDU]lIUۑ*,.KQSXLR8$$ӝD{6ו,|A&E[KƖZ)ޖ[c٤-^IWlMw2_͵zԦ+3ۚ#\ACgFZB Եf3T+dDR6-ԒͧHTK-DU \A1G2m)&'b$SxW ѻZxWwлnz  Eû(x#z7ލwy<3a G0Ʉ9& 6!a& y)4f4{ iw%i9@ìXRCcwt%O{CZnי&4 cL8!pw0a??ؗq;پ0߄ 7C>p]N;E6CMَz O@ 7"?#|ncLXj˿ q0#$ml>}hdQ2rXۉhr[& qnzI[v<4w ?)n n%OaEo@ì@.G zdxw(r6i{L v":v-]oiOP==~ĝiOFi)~N@4WӁǩ(Hu=pDioiiFy-S˘BhyC <܋@ .[Ol=H}fRHs >$.#{%*jnט2}оdz;~2zW\d x~ow[~ ttoA yۋCw tE>aI>>0(?4'@QOt}r;|"<t_@=_4Md{&h𴯘iEd{9vK_3Ad{d{Lېlw66v?}ό>{&hf#"1d{3}W$'@,@" ֬bOk]U[^D711HП?Ws[#xNFcTN7)a4z¾@zi! H'1 k s<1鶅tCd Sw;@\Cpw<#]UcUc$hOC\"&m&WNL>Ưa0&>1eCLZ?B6_˘v:c&{S@ϝAv>?;UT3lUQü W0M&c7e[6cvVǴG8$2VUhf&W8 w7?Y`} ,q&{ ˍ}!\xޏy['c߇q`_~`\Saz?g*~piD?p]v]Ĝy )#;8 W=;\3f7Z ^=.rH^4A}l?5Kx Br[vl;6m@Ċw% NKhc9l62pzc?eAn>ͼ~n{)s;A] izEZO܇I~DObnR+@mO_ȃ_ 2e [ T{-f]d{.6yɼ/[eۏ9%M܍LZU>uJ@&8+L2oy+Q:N*cNC"۞@GUO"~(?4fQg=54nB4nUgNKLjOO4gNKVD@Uȳ(ov9E/T_/#\׽co@&y-dgm51v-xݳ 9cfìc?2cxG [/&pxy,OL 9 khײ4!?_~i܆Гlض=x5јX'Ǫm]b&cm? fjcǚ˙e ̂>]>KdA<󵗱5>=Ô'f5kg1ND/f2fja )(O!\b߀tz{D 򯙃El7sX#'/u b{sUרl㳺Q ?p'yDs\W9,VӂqWl/GÀKD<-/2 9k|{85(ׁ9>[:/N@46ALj9V|.;!|&[ ?{~ߟfe WC'MӴt4uE?㿑y}yk]8>0W0_?z~eYīm~hrb6ˢk)q,Gt|+mx?äQ7qfu@cZ/~!;Bl3e05JcqVv,Yeεwqd~pgg#=B|t=;g-vBp/ ,|xrZףg*#Idi"ȃd`->p4T~v=˺C{3!>Ά:>bwֿja_2c^^&y=wyʉ R1a☁|bZHdzRt+i(hִdZї&0x{cD" e,j\Ok'JDhWv&yZ=GT* d43I7dg`!+dk!#^ZaZ4 4va ))nRF"&i% )+kD0u*E*aj0H-KCWi*tMH >Jw-ZztL-<GnPg~ m'J`\WestbqMk)L5ih*;:Sc ~ I}nijmJW*K^LaJKB!m(]`[Ҷ 4QizIosSa6q+,3>aK&WK`Ty,7AV\eɫr)ϙѤPQZ5ڙ'qQ=-L]>&&47[y'%&h0cN `U)>JRU E)ڡE@93ZLA$rT= ]1)&(gS~t'^RցvKE[H |)TYd|Hr"MuC6ӕʶ>KN(ݞڳ=6He1c֤3+Z!>0 s`M[^ދfVBp7N[V)i/Sd"QBUl;ipf{)Eʺa.YT#ܪdww,h1I]pD\yī@kVMB:ιn ozop䂮e]KU5)L@utU' <ՐfOp Ldվ˒'(zߴ2y.!+3-Etwd]=eCb>~C7zLhc)pHp=,}tv2j藫7;L1S監/s77JC7i:w]ʭ5t}(eMH =|!Ne!^n0f VYݕә/s ' . Sr8C*G(ڙq";xpCqrC6'B,k1 klGx+FTzm!M8H&7N8e4JѥbTHd6O2y ?4۲ߑV^V}μ w2Hv4S ㍟GO?VojoN_&xh+hk''xӎOYN{bZHI6#RL9 h O:P"(figl&Z. okYK[*)ukBZev mU~*1ÔCH^V%n4twYZfzW+[?=P35o/x%5hq3 SU[1$W/W @bFOzATY5SLO{Us%)*:OyF#'07^O :v懛tĈI|;WR<ͤdyac˧:M%,A!ƍe|Ĕc#o <2/~I\6Il^dL _&@94:?v< F0ۗ^kk9 U8'E?A/+ob)/-_nM5 M %Ut&]lg٘kL}<% L3}3rGбL7M~=UN2G?(aڂuB2_]7^tZ7!e󦣇|G>@}_ׂz}pC _7~VS+;\@NM" ZI2| _z#R4\i/dl?-4?Q'6(J*gQaJz1]c2 =K|OK{&҉z}X ONOQsI,!"#^b?EgM po_#PMLHMft.u?q;٪ YXͼj3yZ9P0i(Mا{ #e}UTgL?r=-yIJ+5ILnUؤ4ULBi"}*}-tM_h^>1n\-Xs U?}_&& Wjj"6..qO5id+N&ޓIC9ܝN0& {h٦SiEhqp^lzR[ƒE] "4>id=[n/BӤg1K>,W.HUxlNVt+O>tLr=arIuCm>u|s3K/o8<|mu'@P.SHgrfjbkK\pe[=r)05E+#VL%6*ebA.?pɋݥTe$k0* U[̙[ߘ&yHCw">eo\zhRpD⾛_q*ub ӗtr9G\xo< / *^wZlpɍaI\pUܠTԺq '<]H~pa-L񱑎;1]?iIRVR5CuC6Η}&$=A& 9"\_Zljt(fyQ?rT6v 092nNszhB{6ץ@^8QX߭Xn]δe*ާN+m(>39Z8\y6tMLFr\q`_|P>:/$S/<#MO,V_9Yߣ^3&BPg/įoK[s rJp] ȑ9'8m [ӕ8+fTVrXo{jsٮFՠy a=aM;M]?;n/p\I!#wS9B2it% S^N!w+OM.@ܣ)9rFnXwkc餲z]Œɢ@ 1 ]T/a6^cpi?Y_WgSrU;"鏭99Z,Oׂ+uv* 9 c!NU/eߵG_&9V)A@d*9%,B|]\r[HRr.wE &ުoːaANʥ[ftEiި)9WfMT'r+#\%-c$e8-U 8gr&j7~nگK7hlojelZjM0V2Pz4Kt53~ʄAhaڬywnPFL"<i}X[;</ɑs;vlN6ˠD*]|>ّRҬL:OFcNDU0Hf˥:I4ԟCw|vdQo~B隮亶TwA܋f$0%qElS5} ΅ɂf5sQ%&6X=EgOmd%L5̣_n~WCZ1Hx3vn 5l z /u;T!Yb%IsdP981G ;S'i%bj$IڝxYw8D~Du6B~g|r~0o\@_b)hE"^*jx)K(&71 ,Z浹6X;UaߚBv1=Ճi:qژ97"Ggk5?e-Eur",HC7 ' ິ7&0}Lt 8@~m5Y- rz3`NӑkBRҕ4[aNܫA{56.D 9>''YdZ{j?ױ|D*t FNNLs/i +rC 7xr*ONߕƓs#BmT*r=.{Kt Jt-~̤21mHt9 .rܺ\ȁ!;֋SmBjOI^+q~LBh^DYOUy,UHNDg׊dO! 79' MLÎ>Q?Z[r"<=F*>NOzMv$v=9ڙ˦9yrֻ/wYQ5aɐSL}}i瑬^ɶ'[ ҙẽIUrZ/r5șZרivΕ9[J&(|I\vmOdoT΁\o0.kN,w{i-5CBh%獧۴:h9N7ȹɮtGO1HLrF+un% 'CS7zA/> 퓃LgOr3= 9H#g4]!)tV Z kyeiGL^ŽKmU6+Ժnr˖MoKw ӗ/@> |H[M3OerD3χ2TdaJ>Lr T$dmaejPY+XD{rl!I^We%VAsQ czƌ;֎ 8q&6X[<OxMi_'o ngYm岮0!+"ZoK\RU כȇrWXokMd?׽Z`GY{A0gfڥ 1Ve!m0ոTFV$qv8Tt" /A~'ȓk"?:V0CU6F(Ptx?kJU!{IZ8 gclTS]/L钋T+ڵiMry7k3𷅷 2{(4&[f8 n;]Z" xfTY(lJVq;ޛq P! —Sy3muoD𾿥!Q*0B$ ^_$~AJ-6kCVz3G<19c[ȣk;*`,26^/2v +y pQA% %K\k:+#qi-5JWK՘#X>Wm( c2 |u7 [yS;DG*cb;~̧֒$@x[/#:PrZ[&?/ICMk)L5tn%.S.wFu5.A \mՄ B})\pLOW*ne_Nrt@Ȃ U8mF J_ߙ!)JtB->6eh~ٻюB[Kټ /{L͑+`;k4fUxg{W5ý{*ҌC@fA? Hys@v~5asJnSμ IMOD Hjzɳ',} *'%{g]71yܲ'?)A/,;!jRdچ7G.FӨG9yu.QL.>͋x-F\I cRa-LamDx{gȄQ9Ss5^~hb5#f"ȣFk:/Hx妡n(g!a,dVTEW WTu[PPejڀ65#{S 3wr\?Qa9ajgwT} (b%F h* cS * */e+G]IPꞀ .p_6c7;g<rc ,-s4rޔdjc!,oUiđ6UԎUVA8w)J̡5Dz."G0 00<Ac/ AX[ѡ W$xN(`,jͮAh!n~*Nƀ>cJ+xճP ЯbۗJ?љT5߰I0oXbZEG/F=U! 0DG"3^ ׷ :tˊ;nqܗ4,i8OVqGċa1S!~ ȄwFlϼmؗwF e;#|ry >]2L$'`nǗ[(C=:N 2S5nݩ6g@N ֝5`"^ni(ߩAfJS)vj%H;5\Ԗީ1OW0w-쏇!J _ʡR%sLbu֝[wZuEɺ[wZؿ;-(G7uN;-֝[wZliA `vTX"lXMsn`[7Mcចzm&xM}YM}'lhmP LG7#^M5TbcE_`pl EPlފk?&:}Y@?! EvAywpa6#yGdo֚/8Myʏhw׉X2YKY&B8)%x'a,!L@8!¼cisxޅw'ZLJ4㚁O7K3a]Mo7pwD2=4m",IAɎE BG.CX!>sCnND:k\w9[YjIWF #̓ ;O$h1+2i;y;J>@&ϊerY**eΙa;P"(PHÝ kσAsx>yRw~Y@Ct0YtK.[ij$KeRCq t JiUi,% %VZof) ,pK \*I8v]hkkW9$(oEW3+Օͭ8&m!ms5/e~"OǼvIu-+!0 *Ilf BBvCaNvݛE}DO:ɘ8¼$ePpۯp-M_!:{ Ej%4wn3/_ߋ_t3*S\GOW*SOw^pbrMTvw} «!FP1fu^  Ǟgፒbfo$I5T.i?ŸAso3Gd2㗲_Bx 'U oX:}4>i 6 ů%Ր:]F65ٝwP|ה/ B{:-BxKH۶N[B |"w‡vk@.v1T?5vĨҙtadn)O21_+_w¦d't.gԼu|bQJ Li6VD*3=%oAo,UTXcZ,+JA~6ݙs䎊^lBgY(!F!L:kSBi #'~*aF鄑~`-|o~%rgLG:J"? A;o0 Bkgax $[ 1  ~!݈ar}-tM_h^>Ѧu:%?]ЅLNϰGԀnQ !|^zß0ݕx>2A)!wSBEm ,!w?zZ؂ܳ$55Ö7-Ж!VHf^WV-,ؠ^h =wq ;6ѯ- o^-3E[DuNc5FiἩhOwL44@OݖN\ˌ!޴{k0=SjUQ/Q4?eyB8B/ jx-E1a6޹Oercoj}E9rz- 'vA| H}{2CtqȾ!(/v#lZ [B: dJhN_5&C`붖#sBj IƐ_s%JkRuIڄuMpWC`Dc3` (_A k}!gϗߗkәIW3.Y\`?_DcKx8q<(f7wxP0~oo>\Wе<թ} t|(m]#L gp‡B8K'5W|wg[$H~B]uBk3FbG徊 }LN. ]8!\a Q?{15Q<{%dp ]3FgYAD#l̻t |95<5XRJWepHU]m;>G /pqpqDbq b~}5sO*&=W"q{|x>%\bRf*ZV T5%Է$ki%AuOĠ[s ǹp\qD_*ޓʭ/fayfU=;g~w)ݳ p~mσ3AY\,XSE~ev5)Mi:錈Z.!P1N3.b#p:*\qb ύ0r" sK¸Or+PCLl"vW_-C;y|+mA@"/3@1/gWv + ũLd!8۲Cp:WX߫ k%rW${ bH GX7@'T7éo*7BxDx.mF\67ϐUd0GDbzW3J̗Zp:+~ꔅ[ٗA L=Zb] 26uQ8xπ;OZs^_\) wI9 :+[ #ˆ\vrk7G%gK&^wAxBx;w?Sk ׍t߈dWK']XߘKu$smLMhv: iFٗ,4;!B{U+he>{1= ;C"Ių츹+-ޖH/_>0R`<);!|,3V(Fx$ڄlIGo\K:zd? 9$6y>;-!`7-ՠ3'WeưO)v9Cr d|6~xc-B< #T1w!6{Ky]ŗ@g}$|a = ~n\혽 0w%lG`.bId8*tG' F(80w<PzL&@ʛ)3 p.̝܍i`ntw㕐no$gݦ0DY@ |&-f#_HoW[UyQ!}g`}>m9(y]ud*FKw*.߬Tva>븀zaH 4<#K.ZbrGGⴖYi|ofo$!M+Hp )$>p޼uu7|;_o ASY(_qpz5WR*ӟ#,s}s?dj"K{:,`ѣMg}d.I5LPZ/AWǴs}gQH6aQ+L|\ϴ6x/d7VP~DžLh=}l-KIPu3 @EgӺ ɳʣsb *Ƕ^ghvz9.s{L[.['0/ɔpo*:R>ޜχz>K;tvi ˨^ %v\ {41_UNzB jM6WTՔ!֌Xp O+%|+_Wn;S}7w%jL_M`l^: ,>ւBISxrV_";pJLXYH;eO 04oTڤ]~C6Œyz7oꡔz41*q{D4Ş^we:~{1LƿS)6res7`"_WenISʧTrM\K1~ 7LZP*ߧM 'K3n(}|ўWZY~kܜws.)-C8 8mVo [9m0Z:'gcWϵAgKCMlXI˕nua=UwH$U ]Eux>BlL.YN>\˓zy:^fl2.He\M  p!ܑ*!'aGDh@8BNΚTN؉a07*o KNp;Kt:hdt0a'$\xDR{-Jžsd$ww}p~*5_RD+@|#)׻+a{pw{P;)Z2 bqngxƛ@t~1@t ~!!F h0 4"7%L@0I;#]G`:E>(}aù Ao[2#80$҄kX|a 8 BpHK18- hCR@;֋Vt oi j ;nfw-\";>1sZҏx]I yz1 (\yO>kIk-зmЗvO\bBO~ @'dah?C(&" ہnDip]DnDZY !B@i~!+Rp;O}A8`>@ p K{#B= m8VaۖfI 4ۈ|G ?n-=mcD|'L  Ѓ` x^ O 8@<!k[ v8 $^+*]Z\C 7!GݏD?Ci܊ݎ@"T+$܃^y$q#"[So <#xx { x 4gqx9/{K x !۫8Ea5+Mkx ;w!x_"4>B1p{ |}o ;L / FATcAC#0  cC4 y;k`pmWE 1`$@ ^4)`0څ1XwÃ!C_ ;O0 ;+ A`λ ƮxW0v ]-.+ 3#H7'"8QS ~LbGA%K-X^Z18@IЁ  _ߏG)'pBp2 p:ՙ*B˃P`gp ~㷴 p\ p>4fRļq+AۯpZ=mo9p]H1?缻1$ₘs($1_YH1o<üF@$~K R]~ pnq>  :bΖa߈aAW"01tDxTο*K^< lpE\?- NG>v_b@}xG7(^ p:\Ʉ9UT"ՀCP>u^p/~eԯ8Ć 7a Kg$@#&vB0@<(G.8cDĞ$^p.r伛`vE Q]lO{`f`f _/88"X`a,FpG X `OcG_׍p,c pf$@+$!GvAZ XAWnr( =NpAλN&pJ88pf4plo"VD !So}E\V$UXp-@ n 7%&A5ڻT p܎E~ 2dovO S؈A!x8rY81 x2<ِ 7߿9U^!@&x%.{+Y/"G/_ q#T"Rūj)@@ ]^ #FB!" -F `&;i`4@S[@;L LQ.vS@0+E0`.< uSh]J@'am([[zAk2blȵ//ճ/&6103; l<)q:T&{Gg>ˆgߴS-flp; _ -Sc`270d  &/X.K yTmxŸpJ j!Y$ &^Wujo@d b9RWLmKmhb4\-Wo\ٳLH(e H(]o2c9( - Lines <- "DeployID Date.Time LocationQuality Latitude Longitude STM05-1 28/02/2005 17:35 Good -35.562 177.158 STM05-1 28/02/2005 19:44 Good -35.487 177.129 STM05-1 28/02/2005 23:01 Unknown -35.399 177.064 STM05-1 01/03/2005 07:28 Unknown -34.978 177.268 STM05-1 01/03/2005 18:06 Poor -34.799 177.027 STM05-1 01/03/2005 18:47 Poor -34.85 177.059 STM05-2 28/02/2005 12:49 Good -35.928 177.328 STM05-2 28/02/2005 21:23 Poor -35.926 177.314 " ################################# ## in R ################################# library(chron) # in next line replace textConnection(Lines) with "myfile.dat" DF <- read.table(textConnection(Lines), skip = 1, as.is = TRUE, col.names = c("Id", "Date", "Time", "Quality", "Lat", "Long")) DF2 <- transform(DF, Date = chron(,mat = "d/m/y"), Timtimes(paste(, "00", sep:")Qualityactor(, levels("Good", "Poor"))) order(DF2$umeric), abs-"12:00:00DF2DF2[o,]tapply(row), head, 1), #last line above could anatelywritten likis: do.call("rbinby#sqldf("select * from DF by substr7, 4) ||4, 21DESC+ 4/60 - 1") o group by" Anoway to dolso usingvia nesssameasu where=(min()xy x.ydu library()vUnit.testsystem.("unitTr.all.cat("Running:", , "\nource(learLog() - read.csv.sql 2 Ņ9)iىPA2=,1VfaL@#L0/17 ^{? _?9?4$3?O?H0'%MB&&%R it S4RTǚYT\d۫P#x}P1N1HrB 97QDKHTTH hy!< .(73wY@eE x@~p0n6D8:kz8[fh'h{nEH>8$3faA{^rdO}@_YA2U(SV(Zi=ȇ^g"'뻎)&;_wzzQ1M]Omb5SI)[]m7MSCx]k{HVsz/E&@h. $@ dUrA$'?c2lMoU\NYJVjĖ9uU?1h a{_?q0 c( F*O-$7k?9xgW}^_0EtLB\?ݝop16_J]pbķЏb[{v~4 }* _>fhT@b3 @\Yd@YN,`|pkC\OC>7]qXIficn oh|DzL6.lg!\zSI-(!eKXPd3g4(kd!B8S nl=| 4錋nKхFuBB\}n&Vn ɢmflt4,͐7{:{,s-U-(皴|\f{Uq+^a'0è6WW?=k\UqDSM}*Z€Dx3Z ֲʪ'Sȟj$#ucЗ~lzv)0MPXr20G[ ë!j׈zvKM횸7֒xGY0cw|oL9XPbsvSbx;_cý&ݦI@xMܫz*uAE ;$;͋^!\.+t jރ|OJ/:Ԯ(+JM Mz.*:vfoΑO9sn۔֎5;g ]xA1EvQlȅvCX2"pr<ݫɉI qi18o"|l-m.%QƯ'«ðpaA5$prQ@RճHDKȺ!2w ~fÎR1pj?|Tc1[>+E~{F҈fϋ9U#Suru<"1 #f- \I =f+$=`ꮤi Mj J3:s+ÚII&jzAS~UY1a!JiL< n|soij䒮L*!5۴r9EAݏ>Ң L {MZ#ȏttv6MWoO!JX ʓj 3EeѥNSc7HP*H+'G҄ұ 1"pDvt#ýZȝPtwպU cSoD[#*)kU?~;M*~u]r,JŝܧE_b9~)W@ 1"_!1"Vׁ7 Ϯ4FTQDkTA|5F EƌoFY3 F&˗ܴ}d9`P%~Ǣ\Ay,&W Dr x]3@raoX|_ܟL +0_F]6Kt@]2;!^B|b2=*Q`2:{T&H,RUT&R D}iT./KAa2Ml&rg%ĕ| fb3=6Q`b3l&xd_< [{5.Qۥ\Ͻшx©i\" 4H+ hЊytGd 3'QX^+ݰg[Mᴃۢ;hѢ_lӢO F?1|˄ZmX~n2aߜmK,jqS "7c)wF,44*!z!˄ ܉ML TT3' X&Oǂ7L6rر R ձ8ptB E䩌=/]} b/G 8uԆsik.i5Df@M&yd-ۨWUS:EUc"d'QuRfyERq+(M;{Jq]Afj(`PH$WKvEv8lB:'" ̦=#r$ẖ̂=)ZM@i깡Smⓒ@\/ͩXyjSl.A^ҧقѨvnvPvY&f|}yebo] KMўP=RC [!M^})*BֿųKDuo6AD a 5 oԖuxrGfGlZ_F g gx4zˈ%m#uGUn)v`?"U0_[ٷFf)S0.s;KM%V'0~ M)4 R-*QUtU k d[yx6apۇΦ]cȏiැMKD݄ۨoT;HIZ0[D4pr\HLヵkk;XcB& O s/({ܪKʜJR˴<"˱vY`;pM[˭i;&qI)ZQ2P*1KO8߭z"PƋ^-NNHuůmUV3] 5l}k0xcơVF6( oAum} ~5D6prݺhDWzC^l ӱ_@%FCyx͡X}CemӮQ gIiQX3+KMǬFIщI`q#"zːuG& ?Ƀr" KWLؗvHt!YZdy /p_yfu,7`cBaZcrb8 ܷ:"1<YXz0&V灟@_9 P.Ha%p ybq qiSzqm6TNKfrBOvVYת{l8ۥfӱy\qVU{(DaԺC5-M4~$ن|A=#mE(E(iQp۞?v'F`7fk'<:HuB6myUfVm6B߂/!4g<#ЏjCK3|ZC$.oBgBQlVuQY>D0 -!i99m <.>-P uq'j~DrDإixzGXF -V*~Lϫ޶KZ^5pGfa:lۦ[tstv?B#+40َלٗGP%1]OFx?f4@D /ğoAcXZm4q* lHg mHLA59b3:Y6Giz x~" +:tzWw!݅OTq p%GpɤtjAV/!#g}Ć$6=ve^NmWNN<iO 3J̮9@5˜;@/E8 d&3:Fk( WBszN %z=FlbU*nb("_V,>P\IiEr*7YօgtPX]؆ISPEq3xctS/Z^^']ֱL!ȮL;Ȏ5}4}Nu2JED$x}PN0|uf@H|CCU2jA侸U.+V`n{w~2 YO'Sva q7e"B/j4ںnN]*Uݟ-=7|-g>0.gCQqk)8.=SW6i歈AٵF#4R#_I%Iwݒ^jI $톶0o¾}ǧ%cRDVr:9\$U7bT(xXMS0UBA.0t(Cmt8d#l%`FvH{+ƛ`i4%X>d]!eR1 R6 {2 1 D*dPηV<I[z<T[fԴt=$ oX>LZƩs4d kqqy.ZwθOc$Zү|'SQe1ML!b~tF B~ Rv}*^J1z揁%|sYæff \0of5W4KWm^7NA쉊WZ4΅bգO2sQ&(gQvY lҧ_>G4N3ڔ*mJVE>s -0v7!ʹAQߴe3D\Fhy6;)iAfQ[ 74W._@tq˥犛2hjemmEH!}02@r WL8g~"Uԇ9 95o܂_CD_yhk. p!kk ԧQ9"b?Kh/iU+);afщa%d:9^8eC5ܸݹki/a9n߶8,+!mj@Mp\nX (Ś]it5gx->>bjP"-' bwd[xjvn]@+DZ;zo1,5!Q,;-UZpτ9خ;96WW[wLHg2r t`˗ Z\p@>xyi![ %Jީ ~f xbKRU0R7:.pl_ſ|`7ςzw~ (9Cij p0|t;Dy-m%jgĿfSg+l.My}ן*Ɣ0iH>>,V(8;"dE Nbqc%5ھ$FE1GѾ>jEd톾1o~=njhml~Bub[TI)_L]5`Oxս |u<%^o4<$0xI\+ʫLq=ql+ĎJ#>C>8O,űdw|&q;>8}bL]3cv03 իWU^'ɬͬ[ߕY>;9unv S-ϵvh[3=̺_xX|3guoo~wf??INFEZ[o͔ʎWFp؊_X_(AOzWoBS/W0]CN~ 77NPKM3&yͽWojxc 26E3']s~ɝ ƃIz~`]&=5ͿO!˲|o1ѮNc?Vlqü_K[Q2 ˼yE| _,MWdcS{|BϟCHxi@zEIԋE1 U.5P6[ v?*.2G s_S,G,*x+F*A/?Mp[>4 G(R ?|V}l6&3BycƔ(”ǔ&t5gMBKf(!ڠSeA,KN>6`lrv\i41Y4YIr nپe; D<l׊Ahμ|];Iޤ|ӐnPkAf- ˱ sum- bҺ yoQeHCBzc5XSP b^n|ۂ9Y ~jWE KE+iX*T˶/v誸joSmHqⴃ#Bb޲fb,K¶B'*#qߜX^*]/4&n#4(&%[Us_e<Ť>sҵ>~ W YL|3^-꺂4f%h7Ź\H!_ eZ ^P wRNqaS2} a g@IrY3UWfjY6^">ͨ4Yծ{BTzY4ҺYMgɾ]42kX^0Ǯ{{tXB|r;azA,Hl D9?iqי?ڙWɗIvS] /ᆰX7W.̔UEە \Q&pDWx A*[etuGw,8zx6BWɓT 8Eyʐp,AFSZ-Ajt#q2G,߬x2p#;u(:U P)Z1Y#&h*Z^RY Rތ1V8vd&SA( qbB4=[?qAR P#S>':7>=⫔_m$eS">HCD,){2AօqV?x*l."(i|kv㏍\ ^lޢ\UMsn4r-7oi;,d]n0 m)Ls qxTVAj*|!wvI8$ZN paKKnPπ4S]hM廏bRrPUivSQ>x*^>E|,d0H늧cu4b =5[׵YC|{ӌ̱f MXJiLj]tU"nbNVJ 6:|#r\ZEZ&0`J7@ug(i}D~f_ag,vԹe_aUul"(x~6nlHe9!XevS6',ENm;=]M%鹠**?pMΖ>oEʤ&9{Yyh{CN([تӦ"Đ"H#n u.HfP6Uc?KWk ǎ|-qs6EPdᚌtyrcuYND켪IsMMNϓF"L_D;11wv+^ol4N՚L3f' ]LbCM% r8F,k%cZUml'? RNq뙓 riGE{)@Pp[%kdpn~**9Eʘ?پsR]Ʈ$4{ğvp b+\ٖ̅1 ӣ4^-b?~-v4IOSnrH$lj9hbz}]og7):c_Wee(wo&Ѱ/d_ǁԺ!xmwL;>>ڦح hwwPN1< ʖ=>=s7%"jZt#V{[fcΘ+_OO]62$TtylO #s@vq?XO<@9#VE{nBZ0 1:OH٨N%IS\TIug(wiqjb Zj^sӬ^oSMz%M cu eS?]IZu;q4k5jxsv?1K9ΆI죜bJ_ {4Sό;_=Dqrq0j(Qӣ㕓4%)FM:FLT1|y?IF9br&XSΆ d3}U{^%>;$RZJ(+iR}UĖtIf.@]vbriuy8Ld+m_DӋǗSbRQq\9@;pY0 $8'˗iYaU)n%^Fa)(.`##OQ>Ձ7OSn.H P6"kDu 8%ޢl=~Go*\Ԙ k\R`)y)lDvCehcJF|yJ # TGuˎ5IyM6#qح{cj>j.QQ̢0AI9˭wxr7E41"qlT.ZeW ?,e? z/S6e`G+S,@'p;Kn[Tf+V ~cYWn`l&bD<0u;ت΍_^ɾfu;'H#ZvuNA{i o-;[_WFJUܥ򖮢6QNV{yĀݔ ;$"p;]=̍]UKA*MioAD#$^Ig 4F`FǷq&.)3PXOM9OE 1yL{(ONr۞ lj{"/`/"ʦ.ErC8MO̙EzVԡIb."XW*X(_hтD?1v1評5SDI* vU-a藦թ[0p37)uthX sQoO= i~lDwմ ?[Ur@Q!!&U_M]od(ڔϣ<|\ H&QNq^:픽|&,MWBpXK2(3w@| 2BNĜG(wO6|,Nc8nV)9.czRXV^->z0K>*?imZ zx {>J42 *Vܓ8{Ŭ=D2zH#frfs}'6O;"ކvIt7ٳt"LԦъkOhO uF _9A{7qrۖaʦA@.2 ɑ1v> ˴NF [ BmZfgܶ@zj@u-v{)bxA8;I<hUyL)-O]"//Q6˴+H^&ޣl*mw-|eZw7^BYv%H!Q6UԧU(q`u0̭ހR]1Cu#{+eE!n&)ޒ#i5q.jG۽Nm+[)*__ S>lxؐ7k/q@G5 1O9MٹDmzxrkm:D4j`ux9LBbVu7gs$mkL$wS6Y/^{)mC2aOPN65=@Q6u{14,r~ΗV+(ruS6p$>6J!n]F [(_GQ6}ϒ=K:Qg|ҤX%-`d7҂k*vHKc0 Xj Mv8Z&U=!R0!nb:6ʦ,qۑ Eb/^M)3g7E<1T%Q粨,Cb rсbq;с:⋔_)xDIxͺwĶ׬]5뺴7`hQ Re.Fױ8KMR(XEffeUsOrR@bqeS)oV,jJL)/$)-ȜlvRH!_zK%rWomKax=o7q3s%ύ+WS.eu8LN~xr5*+rJu D*\p<GCf|o>ZTsIx,}7@y8Ny]H'NP0d/]K۔M78`9%Z$h/Pn[')O4. 'Ћ0 !~L-tL)HuŐGLcl 8w_bxj07M(kMM d4HتhjghoQNq}EoIʓQm˔M>7JJm'0K9۹hG)xiDq؝&^\Z/zFO'ӁHuŰB/#LDMhjY{ϳ̽+[ vg#AufT(9nݣ6MʦO}!W2"qu9ĶNqDW@T4y~br؁Dq:v(&X[]win՞ " bYAޗ}I ANh*۰qgAZСk`8LyؐMT]H]$.RZ 4Os͸9vt>ym;j (r;еWHO)8\2*vݙc xrCMÕ<(͟nmw}#L Ί;3;nynB0kWмݨ/c9OCǕ%q]5TLv^[S  HVB(GjKТl~ه󉈪L3U*P. 'JuS=!ޡjޗ+cd(?RwcZ5n+vV纎4)PI{V45*Ek:KljEyE늕EaV7>s.m{ط&㟞+Olpc26-mA@qrEqAR@àWFBy-lr*O McziMLVA"C@TL9R1)CJT3(WiXyXĂGjxXf2gマl)4 i. y8@y]$z yK+Ol:;+o!s<:lQ8eS&4;Aox#uDtzr(+{8JM6hII r[aϔTZrOPN9)/Ϭs嫹XF8c$I7 ;!H!_l evM?Q;Q-GYR]r'+#vCyФUtNzc?PcX&kԦB@m, TMAU** SN"oA{f@94sJ`P3NTUGp}˫D /{1[HLyK:ÔeC.o'Ĵ0iTW r?_SɌ〛($p3/XNcĞox岷%<*Ȅ áu N=)Тl6~J+RF|A;G7kؾnȴ\]cQ6}b>-mfާm 4ݧ]bԈGlޏwBS4.ejʵ>b4K딯)Z`5AA9sZu"' e?t嗌ٲ`r)2&Zv?r!~$0=F*\2ucz,WeљpK(R{p)8 W8P"G2A֒Wsȗ" UP_ivh)N76TQ!Ƴh*4ɵҝEj m'Up"2i ^\kAw&h^xrwn-ekdlu0eՐ7NhA>Ha zwd ZppHjᬮ<4[Z kpzX&\fS͉d7VՖ$1HB̴~is-3-ءb^b%d{(?qdg$S6uxkt$uM sM"\К~|kͯ?~=S!n"bMq=;=SX nxJ{'N=T,kPa/qͮ:nQpuY(?- EhrШ Ðb>pvfJZcQu3BR87 c8܆s|xzr≿!Aߡ~uj`M{ؾA%˛h{dHLݼ_3FE;jw@})_I(B}]☿KN wz}PC/IG^d)Yl}!C7|*FPJ5m7CΊnEKx(K`p<-f|Rǰkns\XG)q*'M|#?NVQ1C^gcmXڣ<7Ks!J3¶%[kf[גf L)ޢ 95iHԷ5Y)%i>$q85ބw]<4f B|ELw[Q%$ UGm8L:J}Y3H%$ ~/%~f7P?dF$MM)ؾZw*hjaZ(9 [ *̎q0_RكtUӭs:/m7˻ 4j6]$˿xR]mf$zeꚁ20H]kJmMrޣD?I l__'N+h_'E 9% G eKĪFZvU~%E@ 4[:2)ؾb+h2+y w+hYy1\Erl}ޟJ+Ji2ܭ%J}%ͺtgJJi5I1zukI %wMTwklZmr.vmk۵; 4ҶFX%h; 4›bq6>FR۸8d6J,ER.͗BuR7nXV yq|gGe%`Ѻo)\}#ď+h6>Ogn dod`P2Ј}(ON;ˬ%#I@j32o +ť׎3J+Rqߛnq CO7l%̈́H~Og  xTIzy `#D '7)4gҮq%#S_ ZNN׺RтW(/^$Mx֎@j*|!w4T,(ӳpD ϴP5L^[U}u8r0L XY+!74f/уk %$IC`uU}P6KOH(BW]&u.䝯!.ʂc"!/vM]+)Q.1/%]G)_o8kkFAj"|!V?Ԁ:{;޿u,oro $-ʖ)J;Kn[ُRNF-!', .3I 6 qxr 5C_e]<7K/vdiO [ƚ]Y;M59H p©+*~/ז/@jTOiOk2JL0ư/{Z)V3uUnM-(m_)ݟQ#eS6AZWӤ4q!@$Ap7q s~$+vS^+=@FyX>GT"eӇH:᫲Faw)5O/RNqNmz4]ea>9`[B]*T.9K%j-;Kh՝SᰐV)"B2۩0U*)1hڔ!C }*hsESGd-~ew'A6iX,tEdPϓj:mkj#&[RjGr1,>a>rm[lnkAS&?5e,;r37B0gJdƫg+\_sփfzJsTԵB^Bs{R*8։c'xC hi_P28B 1y&`u]o 0hn`芕?QðHȇ 4B}YpvYX=frىIww& .7A%cͻԌW'܉։;'4TS놔S+M=qlU3{DG1bnW:Ksx_C׫Wax+ذ?Nէo+(W?L;"؅Ra៴˟.c$ T>^S~&gU\Έ岵ⳳAJծvE%-[}E/^EULZڲeJt("-D} sKvHE oR4u#W<SՖ+x꼫`|^2u8$bpn+B pt{o:@\T%d`tb6F;iaⳳ(;:֠e/"o MZQU\AִJGMe94(t>/V_ =rqTaޱ]}a9woc ]`Y4T.ȩ=ǝ {?73-+;KŸqf^SH0CFnTU9(|: ;/x#ШCӯpO2Ό}A:G蜌YT{/|rO#&duvUlһ1hkIhf~А{R7UyCj䖩!r-[ h=QO/SG^k?J1yO"pscU\h:m_EE7)4`(YىUwZ z1dYʽL 7{$ b4Y4 /  O3BvDAn*ЫXcզ*)MTŏ=2(ݞ_tG#:[Q&%1}y@=@C#ڬzV;`154=B썍ܢUIh:yw<xX&'pBHQ zLvDNh_ M{a(;zQsuHôf~(yFI΄P*IoI\/0Vxd/Vw>.g{Ar7.y&ΑU"i`K}:H$_#e`wѨ),z >Wx>/[)V)Vz}JO$ VM͵w97h|p, 皅N3[T8Le;&dG4=$IMO'uy7זRa^L^%,:n =m*MB2q%2J[C!SqS~3Ӭ_D^\E/&e`-:]#5NњSHVQ饂͸{9pbnDD,n,?LS‘F LٗR/m#S?C=OdMg,nGyT t짨L*їQ# KbAyPhT/JٲN #<ɗS K4hrHhRbcJT9%cFHz?$_a-_uNO_@ v+cAΙQ%9Ih8I$5y 4;%8X ?"a`睈j# zY?-?^/*E#SX[ a; ~P9u*wݐr7W_{DBnd1M-?7ORt+9Bi(6z1AqflZ9>`M$9~ | 씝F( ;Q - M{Gp,~iQ /I|5.蔃)MoEt Ȏht'\:#Gv4;(K%rM:sP|I[Bsdz+Dy7놚H~OAonOn7R;.}&{%Wm`go:4uSYqID"g5=SX-wVJ}3^ϘF>38b=o8vƺyE1>?svTu.?r漶*BUO4Tӧ몜>N2zA[R@]^wޢ+pAj3|6JmoXؐcES] KmFٷQok6ڌ8|zyT\0+NUf6Xꪜ?49aM]le} aTب}}|HQ1}Uw*U]1awh1v#|.U2o< ox2r2,AܓF,hS.P;: ] T1; ,WZUAV%R9٠J߰쾷uYkg 13l'4/yCgT hzzqu֣V˟yyMӺ&:tgyZ9tv[T-?nk!ݎ[Vv5y]/ @{daCyDowz8рddwѫACOp XM) X |ZK] ~P;-&n=g`A=gWErZ' i1B6*c{& q ` B|ϴLv j7)H ʞIJCtPq ۩=t]?F@-C |z.f%ڶ 4m ?Ar?[':Xha%$ 4]ly%H~3"c"ֲ Ukyf } M[i[Hc-l墪-Z1ؾzM͛qirZ^>i\ /m4nW`L/?gq(W+EUj~jMWՍ.:RR^j`eњOG3k})N_Ѩ9sb?;)*T hא}LVY€t5$5^oɨ)*QHZ!ΈɯWYRf] 1K2aC]>M>݂}/%vёǪx<^rf4WTx 3DEq[{c\SK]jyS://S8aVwJ^5|\K-uE\'(e{Y/REPfȃ2S%m)SV7A=5H'ZT_'D퀦C^hWrygGqq]U]L^R픎+$+-osA"_%o@[Sk*츘HZ`%}8i2*"p3P\̨3_}t tuj5%'Z$u `W+]~jM_E|O drP KVّ:BT|7*5jN:p REZ#>2ռTUWߢf.87X]*[AFW!fq\tJ6i)'=$nuvK+V0P1)Q8o\(Tߒ?) y7r9p`zZ]NPiVꁙ<.ߓ6ڨvHh4I-abD\ #"|)V7~h~EWHLB)Wzb8aaN%ɛc0`ʤ*RC$54ۂE4b#XΠLgfDw8F YПaB Pp`u1"sa2?)I[ @mա>#9tISwl0Y2T,5 L?*@WdGThz~tZ^1㿓2~-PyǛih:/ZqKfrT0AjkTZǩ('-PmcB_hH֐7U n*s~pP!yURaɿ}R7y'3*aά̊Y/EK]|sC+<^8уu\GՕ?Ϛ?̤0X-{?@lmm @XP \NzfGZm_]̬.s3̽.] X\0}mox\&`t]q/sŃ+kmbOE͖$uڽ R: Manipulate R Data Frames Using SQL

Manipulate R Data Fr USQL


arrowleft.jpUp]">

Docu‘&r0.4-12

  • RIPTION" typ/plain">.
  • demo">Code s Uutils/help()rumNEWS">P/ulh2>Help P <> #! /usr/bin/Rscript --vanilla --defaults=,stats,methods, require # NeedfR CMD BATCHcharacter.onl# unlink("mypkg.txt"Make sure we gte w report SuitsvListexcludULLall ss run(,R..protocol(,",...eses: #ally:RHMySQL)pg wised.sverbose); ; ) { # set drv drvgetO("driver") drv) ":RPostgreSQL" %in% search( " } elsepgpgMyH2H2"SQLite}tolower drv a1r(warpbreaks)s limit 6 checkIdentia1r, a1set /2r.(COgrepl("^Qn", Plant(a2r)"== "psql"# pgsql needs quotesa2\"CO2\"\"\"'Qn%'gCO2# Equal,,.atFALSE(farmsMASS")in3Managc("BFHF" a33\"('BF', 'HF'){33multiple ineqconstraints4, >= 20 &<= 30)between3 h2445ois'M1' a5ois\" 55! 6262 2}66s)76r)un6s"dropsunof does not; however,iscolumns i (a77r[-1], a7s}aggreg- avgcuptbyTypeh2 douasuse backSpeciesto bins.8r(iris[1:2], 5], mean)a8'"",("Sepal.Length") \\Wid\"88s)"_) `` `bytotala9x)(x=[1]. =(),r/))99"","/"999``/` op 30[$dec, ], 3)desc3"10100s)bottom11# (s111avrowwhich vitsaverg i DFrep(1:2, eac55, v = 1:11DF>(v, g, FUN))Ggv)vg_v"DF"ga12DF".g, t, , " =.gg_v'"DF""DF =222educ twoeoneaquery3s d1,gg2) dd1g2DF3shornatujo14d1.( DFDF45rten, wool) a15 sum(cast(A'integer)),B "SUM),B') .matrix()5# reshat<- "unique(DF$t))_a1direwide",var", idg", varyla1g1 * v) t_122334455\"DF\"DF23451167Fldehyde$optdena1\"\777xnorm(15,5a18rDF[4:12,ovavgowMeans(embedx, 7#edof l7cidnrow(DF8.x) xb a,b.i-3 hacount(*) = 7a,{a.xrow_+ }88merge. a19ra19pt Aa1a22, 33Bbb2:19"AB"A, B"r(SortDF),](r)#DF.tructure(dc(-15676, 48), x), y4, 5).Nc("xy"))g=as(c("1927-01-31",2-28x=3)hy=5finald1.*, d2.yghond2,sdim(pragma_(BOD)L, 6L)sqcBOD_mr")sql1L, 5True_")$aia/bent")$0L, 2(a+0.0)..0arealc("te mytab(a "inserto")tonumac lDF))"auto} : V: : 202629 Title:ipulRAuthors@R: person(giveG.", familyrndieckroccremai"gg@g.com") DeTh)yplya rg n thordinary R . trarentlys ,ort perr eturnresultheuristicetermto assigned. or sfsRioriglargan Relfhandle. 'RRH2'''enduped. ByteCompitrue Dep: R (>= 3.1.0subfn0.6),, Sugg RH2, , , , tcltk, I: DBIron : GPL-2 BugRegithub///issues URL sanod30 02:30:02 UTC; louis: G. [aure] Maine<> sitory: CRAN/6:10:09 Built4.5.2; ;2-14 03:34:35;x # D RRemovpreviousifedit# ExePat(".# Ims ( From("downL Vo satisfys. No cchan 1.0 now acsftps0re198R "sSQL."7.bug fix invols;adcorrespondisc tCHECKR 3.0.26.5fixea2r/6.4uses henco2.14.0higherowc0.6zial POSIXct2.15..extfunsoaartuprenoscuron 1messr wa dnisadhbdotha if actuny sfdrv= ifaly. Psiofy(i.e. , H2H2etc.) posis maktikitu rathgin errorabsgrtostocwin outpuINSTALLorneexam ?porAWKPATHallgawk fo saath. (discusofdin, awk,rocesvuea commasinfield(suchmust bd)os (swn)beto: i, o\"",escapenew\trimhatifNIf=1ntismbeginnd of#nit'A,B\n"Joe, Jr.","Mac ""Knife"""\n'temp")<-;""-v=; -f (IstorsoAnassuWindconssyntaxshellnston UNIXenae NOTEd durbuild/on Linux3dbforbeoinmaya URLbe omd ( valor NA"")isnoito input2dbWT's .sdidwo rout.)1.2es1as(if0 df haswo.firscomponsoldnda keyword "raw"r "__aor avsecondttopriutocspatiai lonIt seems le isuseexll., ,s ifte. Anyvalurehrawhosnnamquensessroeindediss/preorsto worryrpreofals. e. f",{( }'My(inito, h2)tsAsFatoadd: 4 #;tapg3-5global"ofotis= formbigusitumatch.4workH2ja3if iis "llpsta()s (p)3-2H22-o cerond zo0resermale.contchatibmma dotllib-1ounit. Wthacsgaia-gis.it/-sql-2. y wishiIfindinuekut1-7smviyds (kSoren Hojsgaar)6ew5minornWacek Kusnierczyk)4rejunk3c2 objas.r ""spiteF[Ts.]otrevarixx""icaseecuurnis.be. t":memdedexdeleupontits.Rdmo illusorvs.x,hre1ofavortooloto explan0ini rele :- Ben Esco soms,.J LehpoinfixCela-Diaz, FndbugVadlamani, Sto 2im HoltmanTomoaki NISHIYAMA #! #* 2011/2OFSarat# OFS=, mycsvTc.FinLorStinson+csv.Orl.csv/Par CSVrraynumber# Ievgativesverr.belows.am =r# Nly ,"Hsanof.empty caWr.ffing. Wtbegnorspriv =thusos rputrTasokEi# -1Unnex-2Mise3N:yec, evogic msirs ard_csv(,csv,sep,,,,,,pos, o)0) 0; =; ,FIELD= 0; #wh> 0fterif.&& "1;)}Uimoff#a= 2do++!= &&( + 1 || )) {ds.1-);1&&>get== -1= "";-1}$0}<2nsep[]++;}S# IfnorestC tfo++mAdwifs!=t(!3;Ge(1*BEGIN), =;inum_$0,, %s,,%s[0]or (ii <;i++OFSi]''tty EkkehHornlicWS.QuiniTrFim s :Ro Until StdIn.AtEndOfStreaInpChr :=( 1 )Out=nP:= InStr(,If 0 0Gm>Π$NZ2vH -Iٖ(_u9Oф̥[eú^گuL-%'>A-_˔t&]Ū2-̄ `3`,fUN$Q#]E s${ku3*jRu4?sJo)Eom_'т-^ oIןN%An`x$D(n%*ؾ1ET:)W"04Lj8V)`v ӱ,Fi-f@# mn3%D7OYFy)iO: /OQD-Z^$ܼL0 u"~ͯbWj{bwB 0f\q xāAOFb{30~ԧ4ɳ2IQd 㢆1!^1Ae6±'Yg vN~ã^`D[ U$qI biimAo9)1?밐`d/G&!33D.LK1tknbZz8'1?hF<56ތaCq >e> ɻ&%]Z(۰0 )'n,BMsck8@> Q:H4eMpA@u]y˚2Lpw ptb'޺6{#!YHVHES8l 麃u а6r",t m^Okt_w=.+p [SL7Alа >y-ޏKc-9K ȥN?9ф1%0Yo 9OHnϫ>`Y6֧'~@:p]xr"l|-a?%л505܄fdž ~Zʂ6M"%;,k_H 7B#`QnyGXfkH\F 1(~0T-r=R~*oTU)=\[EH%Q]ye& [VMu-|>$x^BAr;Y0c@u0P6-ItBS:0NG>:q W)*X@"и+0c@nED9@ Y6#1F3OqHIvk# (:΋*#/@oYߠ -Щ-Ph=oGjA+AZf XdzB߷xa/j0/:2lSbzn#ػ?Y L!gGu$:Ob?t6shƹ'xz.[4/]g&F<fD9˥Yqd2H@ "5P(3{"l(랲ä(ͳ;#y0z U&\-Hg Hx4^Q˷'q*^C"$Wq 1{XQral2XX#OnG>FEz}n[%䉶 5QnI!dqeO%0hmz&LIQ pnyY&dVKޜ)7Hgnt,ȿi>%gת%5N[oYO}΢N6 ˆ)afD{9cNGjhS>w0!JV [ y MgTR_v?Ɂ'Lm>BrTTO uR;+0(3 ^?-Bz`xp2r,od-hf}!swix'uW,<}*pqOJn<̖KrG "݌);e'ޮVX8= 0brOJMOba nLWZ~e=sI.C_䆭uR͓吘DIVWb$&'aۍI7[0T ?Zs<@5 2\IFjo?Ez3{[x^ 9-3WS)ec=AH"Y H]rEi<3ExSZ=$BUfD*;jo ze-EvuSn\'<.Uip>;jKWiX1Z5* h!AQ)%\U"*~aP~$\legys[18H&[C$"JKl̾B$GL5 'aKD<@Qۖr 蜾z>G r6b/Fτ>06"Y}^ bC\l7Mf8MC!DzֱI߰3*XW6(4Gt0bkQNB!cZol`mDSIG`P/bsi-*DPg)yOvJ h7 IZZ+5-ܤK!e])Xh M964o$/ H ]H5DNmH0sf)2ú'9NȇEئt @1N6~2?5 Fg^q(e #JtIDbg=%0 Hӭw5M|gA)c׊`o&&NL7ϏY9u֏)}Ah'2gz 'qΨ>O9[;Ig>XAbwj̱ggQنv!_n#>Jum"qP#a"PM Iq7RuHdHQ0^GRz|^oϚL\Ǹ1ݍ~a$?юAIAB5ӿWʚsY σ1%d x؎{\i.1ݵDOʪ˵ҰPbϛdn}91q](* . u0GHdVV@ A~r05Pi'lg۽, ҁYB4N&8r5Rӡgi{)˜Żt^.O; 7SIhRh zddՎ|)_~ :7NʹT7 UR"h=v XWѹq2v[ohfhcT+BxgƸGJZ nsnD3H>LYW rՀ$CBQ'="*,[mO dATL&g4$"C2k]WqtEJ\g<[$S]Ɠrs`[2#`-[5E~HQR3C}8 iZ2B% UvЛU ]VK1`ЪF,14VG%,r4Hߒœ\ _Mr/sqO"}s i:~#Oct<: u!(4^s)[i5٘M|KrrbO{E-&(v-1/;Yf:`б 8yWӃ\$9w-Tv[5<` 61zO; AaOĉnfʵЭP߽X&,zpERW9<ԉ@<H9x\r_k. Hb7MOLaOnZ X]AG3Pj[(ao2pBHԯ[NjP&U ql샃m `T[5C7S)IVPad>?Ģ7,I !(Fbgw<~p޻n7|Z#\7c /?hx\{x939 A;PͭGg+@; 6F.0cD+PsN"ڦJE v˙z&IGЇx6`R P44[]}?+?zll ~  l#ۘDejgIj*]s\SN-^vdKX)Z胛j Qs -0Q :%˛K|ǛS+ &>O=rl8Yh`38ce'06WNQaX}_YŪ/EY]c5{4,(tHjLX(P0#ʠh'ik?Y3,M7xc9.W r }Va#)-B<=h(,"\lr[ԢCVR0!"!/e-h5%1YvMg߹惺Hb}7()#Fo )=CAoi(m cȸƇ[g&0AD ؠ0Hi.C'*FyFݘjARa(fv^pvxXc,>F&B+ w 0ȅن}6TxpP 0`|_X T46|!C` a4@ T`kg0zO^<SdzR,GxĊ@$Wt`rBT'}Y݆dΆ-LmX[ fqvy(@)0x\^0rۀf S3{ rcrX2lG RAsyCkqg7Fy؅3l$ n Vch55TbYh(P,eaCz 6{_:a7\khV*,t:A[t{ݔ5}3uz4H_ݙw  , 'ʶ3#"C}Hz1yԫas{ ^$fiiͽG>&i`0O6&kkhZQcdASARn׉ʒ`3H 9g+z_ß㧡N^Z%*?@Q iP%_V̞;P( +瓊%Йd K\K(J =% s^>TwmThXj*Tn:[q$60ٯ6B[~.W2H!(MMQJH{u V.-o`,aX 1ā`2{h8{7qdHUm(͈4ݶېN8~N^˰nC!saXYw0"H&KZn*l @m)Զe&Dm\Mcy௛ Н\X7c^hF؁=St6C~ГXˉry>ԁikvC5%N"P*W3HUؾ\PS4_8΅( ϗ BY|L(G0BdC+]E.#Q0D<4Dw(]؄ ½q='&kTL֙wtI4˲M Ǻ/ LXզxܽ'. w'r;|_n{c64!-2] x! +HA3cXzJzWLH`zjtT&J{!=q r]+co?Dbf3b/rI̼t*O0Y<>-Cڹy0Tdt6_Vy`">y*ŚIЀٝ'xhbjrN/o[9o >?[^Md{0-69!`afty\ٺB Bob6sQ8N|0m#˧E4,ݤk7 zVѿ _DyP /p h_1.剒LXЈO߰ sLfU2^tZcOD嚲J5Ho~s=w1>㝽@RLc8T/kXu+ L,^g~ s9b