similar to: How to import .accda database into R

Displaying 20 results from an estimated 9000 matches similar to: "How to import .accda database into R"

2012 Dec 13
3
how to aggregate the dataset
HI, Sorry for messing up.. I want to transform the following dataset: product min_price max_price mean_price country price_band 11 34 50 40 VN 0-300 22 10 30 15 VN 0-300 Into: product VN price_band 11 40 0-300 [34,50] 22 15
2012 Nov 08
5
map two names into one
Thanks. Yes. Your approach can identify: Glaxy ace S 5830 and S 5830 Glaxy ace But you can not identify using same program: Iphone 4S 16 G Iphone 4S 16G How should I solve both in same time. Kind regards,Tammy [[alternative HTML version deleted]]
2009 Oct 01
2
The problem of readLines
Dear R-users, I use "readLines" to read data, but when processing the large data set, there are few files which can not be readed in: 48: In readLines(name_c[i]) ... : incomplete final line found on 'C:/Documents and Settings/lma/My Documents/habitdata/244052900243997/calllog/calllog_log-20050505T121611.txt' ... Whats the problem about this? Regards, Tammy
2013 Jan 24
3
how to combine unequal rows and columns in R
HI, I have the following list: crosspries $crosspries[[1]] Product Year_Month prod1 A 201208 1 B 201208 2 C 201208 1 $crosspries[[2]] Product Year_Month prod1 prod2 A 201209 1 1 B 201209 2
2013 Jan 25
3
how to delete the null elements in list
HI, I have the list: > suu [[1]] NULL [[2]] NULL [[3]] item_id prod 1 2 [[4]] item_id prod 1 2 2 4 how to delete all "NULL" elements from suu to get only >suu [[3]] item_id prod 1 2 [[4]] item_id prod 1 2 2 4 ?? Kind regards, Tammy [[alternative HTML version deleted]]
2012 Dec 12
2
how to grep in r
Hi, I met this problem. Trade_Price_Band x 1 0-30 0.6237240 2 101-150 0.6743857 3 151-200 0.6778513 4 201-300 0.6640293 5 301-400 0.6630991 6 31-50 0.6314547 7 401-500 0.6776249 8 500+ 0.6557705 9 51-75 0.6621073 10 76-100 0.6623469 I want to get the following matrix
2013 Mar 14
2
HOw to achieve big vector times big dataframe in R?
HI, I have the following question: Vector a with lenght 150 A B C D......... dataframe b with dim 908X150 1 1 1 1..... 2 2 2 2 3 3 3 3 4 4 4 4 ................ final result I want is the vector with length 908: A*1+B*1+C*1+D*1+..... A*2+B*2+C*2+D*2+..... A*3+B*3+C*3+D*3+..... A*4+B*4+C*4+D*4+..... .... because of too large dimension, how can I achieve this in R?
2009 Sep 01
3
data frame
HI, R user, I generate the vectors with the same length. I want to put each vector into each column of data frame. Why it doesnt work`? rm<-data.frame() for(a in 1:6){ rm[,a]<-getmeasure(p1,a,speech) } thanks a lot Tammy _________________________________________________________________ Share your memories online with anyone you want.
2013 Jan 22
3
How to align group based on the common values of two columns in r
HI, I met this problem: I have the feature data frame: Feature OS 4 2 4 1 4 3 1 2 4 1 what I want to do is to autimatically create one more column called "group": Feature OS Group 4 2 1 4 1 2 4 3
2012 Dec 13
2
How to create multiple country's data into multiple sheets of one excel
HI, I have large dataset of many countries. I have written the program to run through each country to generate one output for each country. I want to put the output like this: one sheet has output for one country. How do I achieve it by r. I have tried this: library(xlsx) write.xlsx(nnn, "vn.xlsx", sheetName="Sheet1") [1] but when I change sheetName="Sheet2"
2009 Mar 17
4
Merging
Hi, All. I have a data frame with the part as : ..... 142 2006-02-22 16:28:18 useractivity_act 8 0 143 2006-02-22 16:28:26 4 2 0 144 2006-02-22 16:28:28 3 3 0 145 2006-02-22 16:28:31 4 4 1 146 2006-02-22 16:28:35 3 159 0 147
2012 Sep 26
3
map two names into one
Dear R user: I have got the following problem: I have imported two data sets into R: one set includes price information, another one includes volume information. but I noticed the wrong data order problem in the product name, for instance, in one data set, "GALAXY ACE S 5830" in another one, it is "S 5830 GALAXY ACE" both represent same product. how do i map two name
2009 Mar 05
2
File checking
Hello, How can I check if file is empty in R, if it is, then jump out and read next file; if it isn't, then read through? Thanks a lot for any help. Tammy _________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/ [[alternative HTML version deleted]]
2013 Jan 25
2
How to name the elements of list
HI, I have the array list: X<-vector("list", 2) X[[1]] : data frame 1 X[[2]]: dataframe2 now i want to change index 1 and 2 into: "0-10" , "11-20" ,. finally I want to have X[["0-10"]]:dataframe1 X[["11-20"]]:dataframe2 how do I get them? Thanks a lot. Kind regards, Tammy [[alternative HTML version deleted]]
2009 Sep 22
2
Manipulate directory-help
Dear R-users, I have a problem: I have many files in the directory:"C:/Documents and Settings/lma/Desktop/FamilyAEntrepreneurs/Entrepreneurs/Juha" I want to copy those files into the new directory: "C:/Documents and Settings/lma/My Documents/Juha/book" (<-use "paste"), I first create the directory using dir.create, but it looks doesnt work. How do I implement
2013 Mar 14
3
how to change "`Year_Month)201103`" into "Year_Month)201103" using R?
HI, I have the pattern like "`Year_Month)201103`" I want to delete single quotes within double quetes. I want to change it into "Year_Month)201103" , how to do it in r? Thanks a lot. Tammy [[alternative HTML version deleted]]
2012 Dec 05
2
how to assign factor level into each value
HI, All I met the following problem. I dont know how to handle it. Country Price 1 CN 44.25 2 CN 21.07 3 CN 92.70 4 CN 47.41 5 CN 111.67 6 CN 50.57 I want to create the 3rd colume with different
2013 Mar 15
2
How to make the labels of pie chart are not overlapping?
I have the following dataframe: Product predicted_MarketShare Predicted_MS_Percentage A 2.827450e-02 2.8 B 4.716403e-06 0.0 C 1.741686e-01 17.4 D 1.716303e-04 0.0 ....... Because there are so many products,
2012 Oct 22
1
Testing the equality of two variances
Dear R-User, I met the problem to test equality of variance. Two sample units: conjps<-c(9.41,10.45,10.78,10.73,11.11,11.12,11.59,11.04,11.63) ms<-c(4.11,5.10,5.70,6.46,6.04,6.16, 6.24,6.32,7.33) Then I use the F test to test: •Test Equality of Two Variances F test to compare two variances data: conjps and ms F = 0.5419, num df = 8, denom df = 8, p-value = 0.4045 alternative
2012 Dec 14
1
How to import the large dataset into R
HI, R Users, I met the following problem: I was trying to import data of one table in .accdb database into my ODBC database for being imported into R. The table contains 1021965 records. I always got the following error msg even I change the drive: The query can not be completed. Either the size of the query result is larger than the maximum size of a database(2GB), or there is not enough