Hello,
I have created many excel files in my working dir. each excel file contain one
country's data. In the excel, I have dataframe in sheet1, where each product
and its relative information is
in each row as following:
ProductPERetail_price_Band Country Model_Fit
A -2.
I have the following dataframe:
Productpredicted_MarketShare Predicted_MS_Percentage
A2.827450e-02 2.8
B4.716403e-06 0.0
C1.741686e-01 17.4
D
Hi,
I have data frame like this:
Product PriceYear_Month PE
A 100201012 -2
A 98 201101-3
A 97 201102-2.5
B 110 201101-1
B 100 201102
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*
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]]
_
HI,
Assume I have the data frame generated from R as the following:
Product Price market_share
A 10010%
B 1109%
C 12020%
D 90 61%
What I want to do is to have this kind of excel user interface by c
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
HI, All,
I have three dabases:
analysis_tool.accdb is linked into sellout.mdb and audit.accdb.
whenever I use this database, I need to firstly open "analysis_tool", then
press "External data"->"Linked Table Manager" to link the other two databases.
Now I want to load the data from those databa
versité de Bourgogne
> UMR CNRS/uB 6282 Biogéosciences
> 6 Boulevard Gabriel
> 21000 Dijon, FRANCE
> +33(0)3.80.39.63.06
> ivan.calan...@u-bourgogne.fr
> http://biogeosciences.u-bourgogne.fr/calandra
>
> Le 25/01/13 10:39, Tammy Ma a écrit :
> > HI,
> >
> >
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
HI,
I guess I did sth wrong with the optional argument in the program. but I don't
know how should I make it.
in my main program:
source("getelasticity_overPB.r")
crossprice<-getelasticity(mydata,mydatao,"nest")$cross_p
is same with
crossprice<-getelasticity(mydata,mydatao)$cross_p
I don't k
HI,
I have the following list:
crosspries
$crosspries[[1]]
Product Year_Month prod1
A 2012081
B 2012082
C 2012081
$crosspries[[2]]
Product Year_Monthprod1
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
does anybody can help me on this?
From: metal_lical...@live.com
To: r-help@r-project.org
Subject: How to import the large dataset into R
Date: Fri, 14 Dec 2012 11:01:03 +0300
HI, R Users,
I met the following problem:
I was trying to import data of one table in .accdb database into my ODBC
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
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, "v
Really sorry for messing up.
I want to transform:
> product min_price max_price mean_price country price_band
> 11 34 50 40
> VN 0-300
> 2210 30
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:
pro
HI,
I want to transform the following dataset
Product Price_LC.1 Price_LC.2 Price_elasticity.1 Price_elasticity.2 Mean_Price
Mean_Price_elasticity Trade_Price_Band Country
100 35 52 -4.14 -2.84
47 -3.69
HI,
now I have dataset:
Product Price_LC.1 Price_LC.2 Price_elasticity.1
Price_elasticity.2 Mean_Price Mean_Price_elasticity Trade_Price_Band Country
1 100 357580.1 527483.6 -4.1498383
-2.8459564 473934.0
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
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
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
HI.
I make this code:
getdata<-function('a','b','c' ,'d','e','f'){
drv <- dbDriver("SQLite")
con<-dbConnect(drv, "sqlite.db")
lt<-dbListTables(con)
myf<-data.frame(NULL)
for (i in 1:length(lt))
{
myfile<-dbReadTable(con,lt[i])
myfile1<-myfile[-c(14:44)]
myfile1$MODEL<-gsub(" ", "", myfile1$
HI,
I got the problem.
I use the following query to read table individually, how can I read all tables
autimatically rather than typing "week42" "week33" in dbReadTable?
library(RSQLite)
library(sqldf)
drv <- dbDriver("SQLite")
con<-dbConnect(drv, "sqlite.db")
dbListTables(con)
#dbRemoveTabl
> tbs<-dbListTables(con)
>
> tbs
[1] "lowend" "time" "week30" "week33" "week39" "week42"
> my.data.copy <- dbReadTable(tbs, "week42")
Error in function (classes, fdef, mtable) :
unable to find an inherited method for function "dbReadTable", for signature
"character", "character"
I have
Dear All,
I have two samples as the following:
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)
I want to test the change of sample is same to the another one.
conjps_ch<-c(1.04,0.33.)
ms<-c(0.99,0.60,0.76)
which test
data1<-data.matrix(newdata) # transforming the factor into different values
data.use<-data1[,-c(1,2,3)] # leaving the value matrix
data.dist = dist(data.use)
data.hclust = hclust(data.dist) #complete linkage is used
#if I plot the following one, I have too large data set(rows`=9980), can not
Dear R user,
I have been setting up the models for predicting the volume based on the price
information of own product and competitive products. one option is to use
instrumental variable to break price into two parts: one part that might be
correlated with error term, and the another part tha
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 variance
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 o
HI,
I have the price and volume data from own product and competitor's product:
Year_Month Volume own product's price Volume
competitor's price
1 201011 17583469.03 NA
NA
2 201012 33899
HI, R-Users:
I got a questions. have been struggling so long time
I have this data:
> m1$Year_Month
201009 201010 201011 201101 201102
> min(m1$Year_Month)
201009
I want to calculate the following two answers, how do I program it?
> difference in Month?
[1] 0 1 2 4 5
>differenc
Dear R user:
How to import .accda database into R?
I have tried many ways, still doesn't work. Thanks in advance.
Kind regards,
Tammy
[[alternative HTML version deleted]]
__
R-help@r-project.org mail
Hi, R-users,
I have a problem: Because there are few files which can't be readed
into R completely, so on the following subsequence programme, I use
write.table, which creates the "NA" files for those incomplete files
autimatically.
I don't want those NA files.
My programes formats looks like:
pushed back, silently. For all other connections the line will be
> accepted, with a warning. "
>
> You can disable the warning with;
>
> readLines('your_file', warn = FALSE)
>
> On Thu, Oct 1, 2009 at 9:39 AM, Tammy Ma wrote:
> >
> > Dear R-users,
>
From: metal_lical...@live.com
To: r-help@r-project.org
Subject: Debug
Date: Thu, 1 Oct 2009 15:21:42 +0300
Hi, R-Users,'
I have written a programe to process the bunch of files in one folder.
But there is a error came out;
How can I know which file returns error when being processed?
I
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-20
How do I source a bunch of files in different directories in R?
> From: metal_lical...@live.com
> To: r-help@r-project.org
> Date: Wed, 30 Sep 2009 13:45:34 +0300
> Subject: [R] Change directory to implement same programes
>
>
> HI, R-Users,
>
> I have one problem:
>
> I have written the the
HI, R-Users,
I have one problem:
I have written the the programs which process all file in one directory: for
example:
setwd("C:/Documents and Settings/lma/My Documents/Vappu-saved/Log") as the
start.
..
But I have many folders like "Vappu-saved" and there are a lot of files in each
Hi, R-users,
I met a problem:
Items:[Anna 'moi =) akku loppu joskus 4ltä. Kestää kauan nää..'\tAmer, Tuusula
(0:20)\t20\t12\t16\t00\t00\t11]/Anne 'Ei jakoa,uus päivä muistio et 4n niin
peruin. Hups'\t (0:16)\t0\t12\t18\t00\t00\t11/Elina 'Konsertissa. En tod.
vastaa teille'\tEtu-Töölö, Helsink
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
dir
HI, All R users,
My problem is:
> fn
[1] "C:/Documents and
Settings/lma/Desktop/FamilyAEntrepreneurs/Entrepreneurs/Juha/book_log-20041210T095019.txt"
> dpath
[1] "C:/Documents and Settings/lma/My Documents/Juha/book"
I want to make a function "cyfun" to copy all files in "dir" to "deskdir"
Dear R-help list,
Does anyone have a function that I could use to determine power for 2 way
Anova??
an A x B repeated measures study,power is 0.95, I'd like to draw separate lines
for three different combinations of A and B:
(2,2), (2,5), (2,8).
Thanks a lot.
Tammy
_
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
_
I need a simple algorithm to generate random ranges.
> From: metal_lical...@live.com
> To: r-help@r-project.org
> Date: Mon, 24 Aug 2009 09:55:35 +0300
> Subject: [R] Generate random sample interval
>
>
> Hi, R users,
>
> I have a problem about how to generate random sample interval from a d
Hi, R users,
I have a problem about how to generate random sample interval from a duration.
For example, during a time duration 0-70s, I want to generate a sample which
last 10s.
the sample could be 0-10 or 30-40s or 25-35s etc
How could I do it in R`??
Thanks a lot.
Tammy
__
Hi, Dear R users,
I have a question:
I have A matrix which is 11519X14
and B matrix which is 1764X14,
How do I get C matrix which is The remaining matrix after removing B from A?
Thanks a lot.
Kind regards,
Tammy
_
More than m
From: metal_lical...@live.com
To: r-help@r-project.org
Subject: About Matrix
Date: Tue, 28 Apr 2009 11:28:43 +0300
Hi, Dear R users,
I have a question:
I have A matrix which is 11519X14
and B matrix which is 1764X14,
How do I get C matrix which is The remaining matrix after removing
Hi, All.
I have scatterplot in 2-D
I'd like to see which proportion of data goes into a range. How shall I figure
it out?
Perhaps some accumulative graph or something?
Kind regards,
Tammy
_
Drag n dropGet easy photo sharing wi
regate(V4, by=list(V1, V2, V3), sum))
> Group.1 Group.2 Group.3 x
> 1 2006-02-22 16:31:14 useractivity_idle 0 0
> 2 2006-02-22 16:28:26 4 2 0
> 3 2006-02-22 16:28:28 3 3 0
> 4 2006-02-22 16:28:31
useractivity_idle 0 0
> > 2 2006-02-22 16:28:26 4 2 0
> > 3 2006-02-22 16:28:28 3 3 0
> > 4 2006-02-22 16:28:31 4 4 1
> > 5 2006-02-22 16:28:18 useractivity_act 8 0
> > 6 2006-02-22 16:28:35
I still couldn't solve itany help would be preciated!
Tammy
> From: metal_lical...@live.com
> To: r-help@r-project.org
> Date: Tue, 17 Mar 2009 11:49:10 +0200
> Subject: [R] Merging
>
>
> Hi, All.
>
>
> I have a data frame with the part as :
>
> .
> 1422006-02-22 16:28
Does anyone know the solution`?
Thanks,
Tammy
> From: metal_lical...@live.com
> To: r-help@r-project.org
> Date: Tue, 17 Mar 2009 11:49:10 +0200
> Subject: [R] Merging
>
>
> Hi, All.
>
>
> I have a data frame with the part as :
>
> .
> 1422006-02-22 16:28:18 useractivity_act
n[!n2,]
> > n3
> v V1 V2 V3 V4
> 1 k a 2 1 2
> 2 l b 1 2 1
>
>
> Pankaj
>
>
> Tammy Ma wrote:
> > Thanks for your reply,
> >
> > I couldn't use the method what the example gives. Because Data frame is
> > quite big, and i
Sorry, I didn't sent it twice, but there is some problem on my emailSorry
for this.
Tammy
> From: metal_lical...@live.com
> To: r-help@r-project.org
> Date: Tue, 17 Mar 2009 11:49:10 +0200
> Subject: [R] Merging
>
>
> Hi, All.
>
>
> I have a data frame with the part as :
>
> .
> 1
Thanks for your reply,
I couldn't use the method what the example gives. Because Data frame is quite
big, and it has so many rows which are repeated. I am not pretty sure about the
range of 1000. It turns out I should merge those row which repeated.
Tammy
> From: simon.pick...@bto.org
> To: me
Hi, All.
I have a data frame with the part as :
.
1422006-02-22 16:28:18 useractivity_act 8 0
1432006-02-22 16:28:26 42 0
1442006-02-22 16:28:28 33 0
1452006-02-22 16:28:31
Hi, All.
I have a data frame with the part as :
.
1422006-02-22 16:28:18 useractivity_act 8 0
1432006-02-22 16:28:26 42 0
1442006-02-22 16:28:28 33 0
1452006-02-22 16:28:31
Hi, All
I have so many files in my directory. I got the following error. At this time,
I couldn't use debug() to check error one by one because so many files getting
invloved. How can I get some idea about my error??
.
Skipping book_log-20060222T143612.txt
Skipping book_log-20060222T162
uot;
>
> act_2 <- read.table(textConnection(Lines), header = TRUE, as.is = TRUE)
>
> nr <- nrow(act_2)
> Rep <- as.character(act_2$Rep)
> ix <- Rep != c("", Rep[-nr])
> act_2[ix]
>
> On Thu, Mar 12, 2009 at 6:25 AM, Tammy Ma wrote:
> >
> >
>
Hi All,
> act_2
DateDtime Hour Min Second Rep
51 2006-02-22 14:52:18 14 52 18 useractivity_act
52 2006-02-22 14:52:18 14 52 18 4
55 2006-02-22 14:52:49 14 52 49 4
57 2006-02-22 14:52:51 14 52 51
Hi All,
> act_2
DateDtime Hour Min Second Rep
51 2006-02-22 14:52:18 14 52 18 useractivity_act
52 2006-02-22 14:52:18 14 52 18 4
55 2006-02-22 14:52:49 14 52 49 4
57 2006-02-22 14:52:51 14 52 51
Hi All,
> act_2
DateDtime Hour Min Second Rep
51 2006-02-22 14:52:18 14 52 18 useractivity_act
52 2006-02-22 14:52:18 14 52 18 4
55 2006-02-22 14:52:49 14 52 49 4
57 2006-02-22 14:52:51 14 52 51
hi, All.
DateDtime Hour Min Second Rep App_dur
9 2006-02-22 14:36:11 14 36 11 4 1
10 2006-02-22 14:36:12 14 36 12 3 86
11 2006-02-22 14:37:38 14 37 38 0 58
14 2006-02-22 14:38:36 14 38 36 3 1
15 2006-02-22 14:38:37 14 38
Check as.Date
> Date: Wed, 11 Mar 2009 06:25:44 -0700
> From: qflic...@yahoo.com
> To: r-help@r-project.org
> Subject: [R] How to monthly,daily,yearly average
>
> Sorry, this is my first time to post.
>
> I have a big data set: first colume is date (ex: 2008-2-150, the second is
> time (10:30
done.
thanks.
Tammy
> Date: Wed, 11 Mar 2009 07:50:37 -0400
> Subject: Re: [R] Date frame
> From: jholt...@gmail.com
> To: metal_lical...@live.com
> CC: r-help@r-project.org
>
> It is called a "list".
>
> On Wed, Mar 11, 2009 at 6:32 AM, Tammy Ma wrote
Hi, All,
How to make a data frame, each row of data frame store the different length of
vector?
Thanks.
Tammy
_
Show them the way! Add maps and directions to your party invites.
http://www.microsoft.com/windows/windowslive/produc
Hi,All.
How to make a program to delete repeated value?
a example
> c
[1] 4 3 0 3 4 1 0 1 4 4 3 4 3 4
I want to get : 4 3 0 3 4 1 0 1 4 3 4 3 4
two 4 is being represented by one 4.
Thanks.
Tammy
_
More than messagescheck out
69 matches
Mail list logo