Re: [R] MySQL and RODBC - limitations

Thanks guys - that is better. You all rock! -- View this message in context: http://n4.nabble.com/MySQL-and-RODBC-limitations-tp1692743p1746457.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://

Re: [R] MySQL and RODBC - limitations

I found the solution. The problem was indeed R. Their is a simple way to solve the problem, but it just needs a bit more time. If you download large integers from a database, convert it "on the fly" with SELECT CONVERT(yourcolumn,char) That is it. This is nor problem, as long you do NO compar

[R] MySQL and RODBC - limitations

", but I see no difference. Any ideas what I can do? Thank you! jorgusch -- View this message in context: http://n4.nabble.com/MySQL-and-RODBC-limitations-tp1692743p1692743.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-proj

[R] First Appearance of value in splitted matrix

Hello, I have a large matrix (foo), I have to split by weeks and in which measures start at different points of time. Now I am looking for the number of the week, in which a specific value appears. I do not need the date or any other information from a row, but (due to structure of result table)

Re: [R] delete repeated values - not unique...

rle is extremely cool!! This is really an impressive method to reduce vectors to point where you need to do calculations. This really helped! Thanks a lot! jorgusch -- View this message in context: http://n4.nabble.com/delete-repeated-values-not-unique-tp1557625p1559171.html Sent from the R

[R] delete repeated values - not unique...

Hello, I must be blind not to see it, but I have the following vector: 4 4 5 6 6 4 What I would like to have as a result is: 4 5 6 4 All repeated values are gone. I cannot use unique for this, as the second 4 would disappear. Is there another fast function for this problem? Thanks in advance

Re: [R] vector based command for equal values - if too slow

stingPrice, x$ScanID,), function(.price){ > # return sum of duplicated; non-zero => duplicated prices > sum(duplicated(.price)) > }) > > > On Thu, Nov 12, 2009 at 12:11 PM, jorgusch wrote: >> >> Hi, >> I have a big set of data with price lists in di

[R] vector based command for equal values - if too slow

Hi, I have a big set of data with price lists in different periods. I want to check whether there are equal prices and if so, start a loop to look closer into it. However, my solution so far is based on a loop and I cannot think of a vector based approach...any ideas? # Counting vectors equali<-0

[R] Subsetting matrix with values from vector

Hello, I have a large matrix (data), in which there is a column offerid. The values are numbers (lets say 1:5) There is another vector (idnew), which contains some of the offerids and many more (3:10). I want a subset of the matrix wiith only those rows, which match the criteria of the vector.

Re: [R] Slicing cra**y csv files

e learned but in preparing the data for the use of the function. It is like a magic barriere R keeps or wants to keep alive. These are just my two cents. Anyway, I thank you a lot for your advice and it will be well remembered. Patrick Connolly-4 wrote: > > On Wed, 12-Aug-2009 at 03:36AM

Re: [R] Slicing cra**y csv files

for such scenarios. I mean, R can be as fancy and amazing statistical programm as it is, but not getting the data in properly in first place, makes it kind of useless. jorgusch Patrick Connolly-4 wrote: > > On Tue, 11-Aug-2009 at 01:39AM -0700, jorgusch wrote: > > |&

[R] Slicing cra**y csv files

3 Results 42 Results V8 V9V10 1 36 Results 22 Results 28 Results I just need the numbers as a vector. Excel can do it with a few lines of VBA, but there must be a way to do it directly in R, would make things easier. Thanks a lot! jorgusch -- View this message in conte

Re: [R] Using a variable for mysql/database Query

help section for the command help is short. Are there ways to paste several variables into one query? The table we are looking at also changes so, it would be quite handy to do it once in a line on top of it. Thanks! jorgusch Dieter Menne wrote: > > jorgusch web.de> writes: > &

Re: [R] rmysql query help

Hello, Okay, this is a help for me too, thanks! However, how do I do it for two variables/entries in the database? Thanks jorgusch Aaron Sims wrote: > > R HELP, > > I am trying to use an R script to connect to a mysql database. I am > having a problem using a variab

[R] Using a variable for mysql/database Query

does not help as the database does not now this entry. Anyway to make it work? I am using RMYQL Thanks! jorgusch -- View this message in context: http://www.nabble.com/Using-a-variable-for-mysql-database-Query-tp24166250p24166250.html Sent from the R help mailing list a