search for: salary

Hi, Is there an easy way of querying an active record for a maximum column value? I need to do queries like: SELECT MAX(salary) FROM employees TIA, Jeroen

Hello all. I have the following: plot(salaries$yearID, salaries$salary, type='n', xaxt='n', xlab='', yaxt='n', ylab='') axis(1, at=unique(salaries$yearID), labels=unique(salaries$yearID), lwd=.25, tck=-0.05) axis(2, axTicks(2), format(axTicks(2), scientific = F)) Which nicely creates the Y axis with the raw numbers, which are i...

I have the data similar to the following in a data frame: LastName Department Salary 1 Johnson IT 56000 2 James HR 54223 3 Howe Finance 80000 4 Jones Finance 82000 5 Norwood IT 67000 6 Benson Sales 76000 7 Smith Sales 65778 8 Baker HR 56778 9 Dempsey HR 78999 10...

Easy one: Let''s say I have a table called ''employees'' with a column called salaries, how can I add Employee.salaries_total to the model? Thanks! -- Posted via http://www.ruby-forum.com/.

...nding rank for each employee, partitioned by company. But when I implemented it, the results weren't the expected rankings. What am I doing wrong? set.seed(1) DF <- data.frame(Company=sample(c("Ford","Toyota","GM"),size=18,replace=TRUE), Person=LETTERS[1:18],Salary=runif(18)*1e5) DF <- within(DF, rank <- ave(Salary, Company, FUN=function(x)rev(order(x)))) # Then checking each category manually DF[DF$Company == "Ford",] DF[DF$Company == "GM",] DF[DF$Company == "Toyota",] # My results show that it works for Ford and GM, but...

Hi, is there an R function like sql's TOP key word? I have a dataframe that has 3 columns: company, person, salary How do I get top 5 highest paid person for each company, and if I have fewer than 5 people for a company, just return all of them? Thanks, Richard [[alternative HTML version deleted]]

..., thanks a lot for all the prompt replies to my earlier question about "merging" data frames in R. Actually that's an equivalence to the "join" clause in mysql. Now I have another question. Suppose I have a data frame X with lots of columns/variables: Name, Age,Group, Type, Salary. I wanna do a subtotal of salaries: aggregate(X$Salary, by=list(X$Group,X$Age,X$Type),Fun=mean) When the levels of Group and Type are huge, it took R forever to finish the aggregation. And I used gc to find that the memory usage was big too. However, in mysql, it took seconds to finish a similar...

Hi, What do you think is a reasonable salary for a ROR programmer in Manchester, UK? If you''re working with ROR and in the UK i''d be interested in knowing your salary :-) Your opinions would be very valuable to me JD -- Posted via http://www.ruby-forum.com/.

Hello I have Vacancy model and vacancy_spec test with validates_numericality_of :salary, greater_than: 1 in the model and validate_numericality_of(:salary).is_greater_than(2) in the _spec. When i run rspec spec command tests pass (in some cases and in other they don''t) Why? vacancy.rb ------------------------ class Vacancy < ActiveRecord::Base validates_presence_of :...

...456 4669, Fax:+27 12 422 6579 E-Mail : pmakananisa at sars.gov.za <mailto:pmakananisa at sars.gov.za> > A = read.csv("C:/Documents and Settings/S1033067/Desktop/A.csv", header = TRUE, dec =",", sep = ",") > names(A) [1] "NAME" "SALARY" > dim(A)[1] [1] 19 > B = read.csv("C:/Documents and Settings/S1033067/Desktop/B.csv", header = TRUE, dec =",", sep = ",") > names(B) [1] "NAME" "B.SALARY" > dim(B)[1] [1] 15 > common = merge(A,B) > names(common)...

Plotting with 2 x axis? One axis inside another, for example salary within state, 1-50 | 50 ? 100 | 100+ | 1- 50 | 50 -100 | 100+ | ? repeated bins for salary AL ! AR ?? more states The values are all stored with a single data frame. I have tried different things with th...

I'm sorry for the way OT post, but here goes. I'm an informatics specialist, and R user. My wife is a secondary school maths teacher. My wife recently tried to explain to her class the link between education and potential salary, and I would love to be able to show this graphically, however, I cannot find any freely available data for this. Does anyone know of a suitable dataset, or where I might find one ?Ideally salary, maximum education level, age, sex, industry and some form of geographic location would be amazing...

The dataframe is id salary 100 500 101 600 102 700 103 800 how can i generate a subsets if salary>600? -- View this message in context: http://r.789695.n4.nabble.com/Filtering-in-R-tp2299603p2299603.html Sent from the R help mailing list archive at Nabble.com.

Hi everyone, I''m new to Rails and Ruby, and have been working my way through the Pickaxe and Agile Rails books for the last week or so. With a background in payroll apps I found that the default ActiveRecord mapping of decimal columns to float variables really bothered me! Financial calcs need high levels of accuracy and floats just don''t give you that. I know there are a bunch

...tick and Ytick marks with Currency symbols: $2000 instead of 2000? I would like to add dollar symbols to tickmarks on boxplots, histograms and back-to-back histograms. My Examples (requiring the lattice and Hmisc packages): data(case0102, package="Sleuth2") str(case0102) boxplot(Salary~Sex, case0102) histogram(~ Salary | Sex, data=case0102) require(Hmisc) # out <- histbackback(split(case0102$Salary, case0102$Sex), probability=TRUE, xlim=c(-.001,.001), out <- histbackback(split(case0102$Salary, case0102$Sex), probability=FALSE, xlim=c(-30,30), main =...

I am facing a problem with a function in survey package. The function svyvar gives the estimated population variance from a given sampling scheme. I am working with a data having more than four continuous variables. In order to have have population total for all those cont. variables I have written in the following format svyvar(~var1+var2+var3+var4+var5+var6,data) ; var1,var2,...,var6 are 6

I have a string like this st <- "SELECT COUNT(empid), COUNT(mgrid), COUNT(empname), COUNT(salary), FROM Employees" How can I remove the last comma before the FROM statement? -J

I have a query which returns a data set like so: > salaries yearID POS pct 1 2009 RF 203 2 2009 DH 200 3 2009 1B 198 4 2009 3B 180 5 2009 LF 169 6 2009 SS 156 7 2009 CF 148 8 2009 2B 97 9 2009 C 86 10 2008 DH 234 11 2008 1B 199 12 2008 RF 197 13 2008 3B 191 14 2008 SS 180 15 2008 CF 164 16 2008 LF 156 17 2008 2B 104 18 2008

...les user to click a button in order to change value of one attribute in given record. I use this code to invoke a method from controller: <%= button_to "Change", { :action => "edit", :id => prog.id_prog } %> My method looks like this (just a simple one - to set the salary attribute to 1000) def edit prog = Prog.find(params[:id]) prog.update_attribute(:salary, 1000) redirect_to :action => ''list'' end However after a list view is shown again the change is not made to the database. I do not get it, as find returns the proper record and...

Mydata is as under. dat=" salary ex + 1 1856 1799 + 2 1856 1800 + 3 1858 1800 + 4 1858 1801 + 5 1862 1803 + 6 1862 1805 + 7 1862 1810 + 8 1865 1805 + 9 1865 1808 + 10 1865 1815 + 11 1865 1820 + 12 1870 1810 + 13 1870 1830 + 14 1880 1840 + 15 1880 1845 + 16 1880 1851 + 17 1880 1853 + 18 1880 1855 + 19...