Displaying 20 results from an estimated 200 matches similar to: "How to build a matrix of number of appearance?"
2011 Jul 05
1
How to translate string to variable inside a command in an easy way in R
I want to write a function that get 2 strings y and z and does the following
R command.
temp<-qq1[qq1$z==y,]
for example if it get y="AMI" and z="PrimaryConditionGroup"
It should do the following
temp<-qq1[qq1$PrimaryConditionGroup=="AMI",]
I could do it by the following function that is ugly and I wonder if there
is an easier way to do it espacielly when temp
2012 Feb 09
3
Rearanging Data
Hi,
This is only a small portion of the Data i am working on
I want to make a subset of this data set( Data Set=Claims)
MemberID ProviderID Vendor PCP Year Specialty
1 42286978 8013252 172193 37796 Y1 Surgery
2 97903248 3316066 726296 5300 Y3 Internal
3 2759427 2997752 140343 91972 Y1 Internal
4 73570559
2008 May 06
1
check_friendship method only returning value of last pair
Hello, I''m new to facebooker and ruby, so not sure if the issue I am
having is due to my misunderstanding or a bug in facebooker plugin.
Here is what I have:
def show
@current_user ||= facebook_session.user
@member ||= params[:id].to_s==@current_user.id.to_s ?
@current_user : Facebooker::User.new(params[:id])
#for each of current_user''s friends, check if they are
2012 May 09
1
QQplots format
Dear R help,
I tried to plot two qq plots in the same window using the code below.? Somehow it is plotting only one at a time.?? I borrowed the print function from xyplot. ?
pdf("QQplotCorrUncorr.pdf")
qq1<-qqPlot(residuals(fm), main="QQ plot for Correlated Model")
qq2 <-qqPlot(residuals(fma), main="QQ plot for Uncorrelated Model")
print(qq1, pos = c(0.0,
2006 Dec 09
1
manipulate headers?
Hi...
Here''s a working Perl script that I want to be able to do in Ruby:
use WWW::Mechanize;
my $url = "http://host/tt?name=chris";
my $mech = WWW::Mechanize->new();
$mech->add_header( Referer => "http://chrismcmahonsblog.blogspot.com" );
$mech->add_header( Cookie => "messageid=170118; memberid=1007");
$mech->get($url)
so the header
2007 Dec 06
3
Setting Multiple Values via func_odbc ...?
I need to insert/update multiple MySQL columns in a single row with the func_odbc function at the SAME TIME.
Someone showed me how to use ARRAY to retrieve multiple values at the same time, but I need to SET multiple values.
Can this be done?
If not, I will just stick with MySQL, but that's a pain in the ass because the asterisk-addons package has no default rpm spec file for building an
2004 Oct 26
1
help!!!
Dear R users,
Would need some help.
I will compare some results in a dotplot.
The picture is very dark(grey) in the background, could I get it ligther?
R-code
dotplot(LINES~VAL,
groups=QQ,key=simpleKey(levels(QQ1),space="top"),xlab="Values",main="Tail-Measure"
)
(where LINES,VAL, QQ is vectors)
2010 Aug 24
2
chisq.test on samples of different lengths
Hello,
I am trying to see whether there has been a significant difference in whether people experienced damages from wildlife in two different years. I therefore have two columns:
year 1:
yes
no
no
no
yes
yes
no
year 2:
no
yes
no
yes
I wanted to do a chisq.test, but if I enter it this way:
chisq.test(year1, year2)
I get the error saying the columns are two different lengths. So then I tried
2008 Dec 10
2
how to merge panel data stored by variable?
Hi,
I have two datasets stored in tab-separated format in the following way
file1:
country year1 year2
Germany var1 var1
Hungary var1 var1
file2:
country year1 year2
Germany var2 var2
Hungary var2 var2
I can easily read in these files, but how can I merge them as a panel
dataset?
Thanks,
Viktor
2007 Jun 29
1
Assign name to a name
I would like to know how I can assign a name to a name. I have a
dataset that has different years in it. I am writing scripts using R
and I would like to give a month a generic name and then use the generic
name to do different analysis. The reason for the generic name would be
so that I only have to change one thing if I wanted to change the year.
For example.
Year1 = 1999
datayear <-
2003 Nov 17
1
Generalized linear model
Hi all!
I am fitting a Poisson model, using the following command:
> fit2<-glm(canc~id1+year1+time+lnpa,family=poisson)
where 'id1', 'year1' and 'time' are factors. I defined them with:
> id1<-C(factor(id1), treatment)
and 'lnpa' is a continuous variable.
The 'summary' function gives me all the effects estimates, that is, for id1,
I
2012 Jul 04
2
Date
Hi
I have monthly data and the dates are in MM/YY Format
I need to convert them into DD/MM/YY format by pasting 01 in place of DD to
all the observations in my Year Column
ex:
Year Stock Prices
01/2000 1
02/2000 2
03/2000 3
I need to convert them to
Year Stock Prices
01/01/2000 1
01/02/2000 2
01/03/2000
2006 Aug 24
1
Using a 'for' loop : there should be a better way in R
I need to apply a yearly inflation factor to some
wages and supply some simple sums by work category. I
have gone at it with a brute force "for" loop approach
which seems okay as it is a small dataset. It looks
a bit inelegant and given all the warnings in the
Intro to R, etc, about using loops I wondered if
anyone could suggest something a bit simpler or more
efficent?
Example:
2006 Dec 14
1
legend/plotmath/substitute problem
Dear R Experts,
I am trying to produce a legend for a series of plots which are
generated in a loop. The legend is supposed to look like this:
2000: gamma=1.8
where gamma is replaced by the greek letter and both the year and the
value of gamma are stored in variables.
Everything works fine as long as I have only one data series:
year = 2001
g = 1.9
plot(1)
legend('top',
2011 Apr 18
1
Comparing two lines - Ancova: lm or aov?
Hello!
I have measurements (length and volume) of fish collected in two years. I
want to know if the the relationship between length and volume is the same
for both years. The number of fish measured is different for each year. I
don't know whether lm or aov is more appropriate to use.
Here are the two output options:
Call:
lm(formula = Volume ~ Length * Year)
Residuals:
Min 1Q
2010 Feb 11
0
sqlSave data into multiple *.mdb files
Hi All,
con <- member <- class <- list()
for(i in 1:5)
{ con[[i]] <- odbcConnectAccess(paste("C:/Desktop/Data/source",i,".mdb",sep = '')) #read data from Access files
member[[i]] <- sqlFetch(con[[i]],'member') #get table data from *.mdb files
observe[[i]] <- sqlFetch(con[[i]],'observe') #get table data from *.mdb
2010 Jan 30
2
drawing a line that shifts from solid to broken
I am graphing longitudinal data from three time points. I'd like to draw a
solid line from point 1 to point 2, and then a dashed line from point 2 to
point 3. It works if I do it in two steps:
> first.vector <- c(mean(year1$variable1), mean(year2$variable1))
> second.vector <- c(NA, mean(year2$variable1), mean(year3$variable1))
> plot(first.vector, type="b",
2010 Aug 20
1
Shifting of Principal amount while calculating Present Value
Dear R Helpers
I have following data -
cash_flow = c(7, 7, 107) # 107 = Principle 100 + interest of 7%
t = c(1,2,3)
and zero rate table as
rating year1 year2 year3
AAA 3.60 4.17 4.73
AA 3.65 4.22
4.78
A 3.72 4.32 4.93
BBB 4.10
2013 Apr 03
1
linear model coefficients by year and industry, fitted values, residuals, panel data
Hi R-helpers,
My real data is a panel (unbalanced and with gaps in years) of thousands of firms, by year and industry, and with financial information (variables X, Y, Z, for example), the number of firms by year and industry is not always equal, the number of years by industry is not always equal.
#reproducible example
firm1<-sort(rep(1:10,5),decreasing=F)
year1<-rep(2000:2004,10)
2010 May 01
1
I need some help joining data from 3 MySQL tables, please
Hi all,
I am trying to display collective data from 3 MySQL tables:
The query I have, so far, is
SELECT c . * , COUNT( m.id ) AS `members`
FROM `jos_mls_teams` AS `c`
LEFT JOIN `jos_mls_teams_members` AS `m` ON m.teamid = c.id
RIGHT JOIN ( SELECT u.name, u.lastvisitDate FROM `jos_users` AS `u` )
ON u.id = m.userid
GROUP BY c.id
LIMIT 0 , 30
But get the following error:
#1248 - Every derived