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