similar to: Extracting data and saving in excel

Displaying 20 results from an estimated 20000 matches similar to: "Extracting data and saving in excel"

2016 Apr 09
1
Quantmod abline and axis configuration
Hi all, I have this code I want to add two ablines like this abline(h=2400, lty=3, col="lightgrey") abline(h=400, lty=3, col="lightgrey") But doesnt wotk. I alo try to set ylim from 0 to max "Foa"+1000 but I?m not able ?Is it posible? require(latticeExtra) require(ggplot2) require(reshape2) suppressPackageStartupMessages(require(googleVis)) require(quantmod)
2012 Nov 10
1
Likelihood ratio
Hi All I have to run multiple stimations and to compute Likelihhod ratio. If I compute ls function with coef and summary I can extract "outputs" that I need. I am not able to find something similar to log liklihood.... Can you pease tell me running a ls function x on y how to extract if posible LR statitic or Likelihood or Log likelihood. Many thanks in advance. If you send me
2011 Jun 24
3
Fwd: Extract element of a list based on an index value
> Dear list, > > I have some data on a geneaology, here is a subset: > warmerge[1:11,c(1,6,25)] > Warrior SibID birth.year > 1100 3793 2013 1926 > 4 2013 2024 1934 > 1094 3769 2024 1918 > 632 2747 2037 1928 > 176 2083 2039 1944 > 187 2085 2039 1949 > 192 2086 2039 NA > 495
2008 Feb 21
1
Save a group of matrix
Hello, I'm creating a loop to work with vegan, to get a species abundance curve. Here I send the script I've created and also an excel file to prove what it can do. Well, I have a database with 20 years, and each year we have sampled 19 stratum, and in each estratum we have carry out some sumpling. Then, with the script that I've sent I've got to calculate the species abundance
2010 May 28
4
Matrix interesting question!
hi, I have been trying to do this in R (have implemented it in Excel) but I have been using a very inefficent way (loops etc.). I have matrix A (columns are years and ages are rows) and matrix B (columns are birth yrs and rows are ages) I would like to first turn matrix A into matrix B And then I would like to convert matrix B back again to the original matrix A. (I have left out details of
2009 Apr 22
1
converting histogram to barchart
Hi list, After a lot of tweaking i have managed to create a histogram with an overlaying density plot. The histogram shows a sample of birth weights of babies and the density plot shows birth weights from a much larger reference populaton. My data is divided in 0.1 Kg bins so in the code below binweigh=0.1. The trouble with the current graph is that it is not very clear since the density plot
2009 Nov 23
2
non-intuitive behaviour after type conversion
Deal list, I have a data frame (birth) with mixed variables (numeric and alphanumeric). One variable "t1stvisit" was originally coded as numeric with values 1,2, and 3. After attaching the data frame, this is what I see when I use str(t1stvisit) $ t1stvisit: int 1 1 1 1 1 1 1 1 2 2 ... This is as expected. I then convert t1stvisit to a factor and to avoid creating a second
2008 Apr 18
2
naive question regarding running parallel C code from R
Hi, I have only the vaguest notions of what parallel programing, but I think I have a situation where it might be of use to me, or at least provide me with the opportunity to learn more about it. Before I invest in figuring out the nuts and bolts, can anyone confirm that this is a sane approach, or provide alternatives that I could pursue? I'm running stochastic simulations, with the actual
2007 Oct 26
1
finding birth position
Hi All, I have data on the sequence of births for families with completed fertility cycle (in a data frame); the relevant variables are called b1, b2, b3, b4, b5, b6 and record the birth of the first, second, ..., sixth child. So, b1=1 if the first birth is male, b1=2 if the first birth is female, and b1=NA if the family did not record any first birth. Similarly for b2, b3, b4, b5 and b6. I
2008 Jun 13
2
Rails 2.1: invalid date automatically convertion
Hi all, Rails 2.1 seems to converts the following parameters {''birth(1i)''=''1990'', ''birth(2i)''=>''2'', ''birth(3i)''=>''31''} into date ''1990-03-02'' automatically. Is it able to inhibit this convertion? -- makoto kuata
2009 Apr 23
1
Loess over split data
Dear R users, I am having trouble devising an efficient way to run a loess() function on all columns of a data.frame (with the x factor remaining the same for all columns) and I was hoping that someone here could help me fix my code so that I won't have to resort to using a for loop. (You'll find the upcoming lines of code in a single block near the end of the message.) Here's a
2010 Mar 13
2
Two questions, first about contingency tables, and second about table () and data.frame (), from a visually impaired user.
Hi all, I want to make a contingency table in R. I want to tabulate two variables, one as the independent and second as the dependent variable. The IV has two categories, namely, birth complications, and no birth complications. The frequency of birth complication category is fifty, and the frequency of no birth complication category is 34. The categories and frequencies of DV follows.
2011 Mar 19
3
Plotting graph problem!!
http://r.789695.n4.nabble.com/file/n3389613/Life_Expectancies_2008.csv Life_Expectancies_2008.csv I am trying to plot a histogram base on the file i uploaded above. I am facing a trouble in sorting out the frequency of the life expectancies. I wanted to plot a graph of life expectancies at birth versus frequency,but i have no idea how to change the locations into frequencies taking the range of
2011 Feb 08
2
delete a row in dataframe w/o changing indexing
Hi All, I'm trying to delete a row from my dataframe "pop" without changing the indexing (column 0) as follows: >pop id birth size xloc yloc weight energy gonad consumed 1 1 36 13 34 43 0 18 0 0 2 2 36 10 39 38 0 18 0 0 3 3 36 10 37 35 0 18 0 0 4 4 36 10 31 25 0
2012 Feb 17
4
How can I tabulate time series data (in RStudio or any other R editor)?
Hello, I have a question on how to tabulate the time series data. I use RStudio, but if can be done in any other R editor, it should work in RStudio as well. > a1<-11:22 > a1ts<-ts(a1, frequency=4, start=c(1978,1)) > a1ts Qtr1 Qtr2 Qtr3 Qtr4 1978 11 12 13 14 1979 15 16 17 18 1980 19 20 21 22 If I click the variable "a1ts" on the
2012 Nov 20
3
Greek letters on title
Hi all, I want to plot a series "x" and I want to put on title "Time evolution with alpha=0.2", e.g., plot(x, main="Time evotion with alpha=0.2",col="orange") Is there any posibility to put the greek letter and avoid written the word? Many thanks in advance. [[alternative HTML version deleted]]
2011 Feb 27
2
substract 2 data.frames
Hi! I have 2 data.frames: "fish" and "popn": >fish xloc yloc id birth size weight energy gonad 20 15 15 54 -60 107.9 63.0 15952.9 8.0 21 15 15 32 -60 105.1 61.4 15538.8 7.8 91 4 43 96 -60 118.9 69.4 17573.2 8.8 71 32 4 64 -60 121.6 71.0 17976.0 9.0 34 2 64 20 -60 116.2 67.9 17173.0 8.6 95 6 20 58 -60 106.5
2006 Nov 11
1
Fitting a survival curve
I am new to R and am trying to fit a survival curve with a weibull hazard function to a set of data giving the probability of survival to age x, given the year of birth, in the form: Probability of survival: Birth year 1980 1981 ... 2003 .2 0.90 0.89 ... 0.87 1 0.80 0.81 ... 0.79 age 2 0.75 0.74 ... 0.73 3 0.70 0.69 ... 0.68 5 0.50 0.49 ... 0.43 10 0.30 0.31 ... 0.26 I would like to be
2002 Jun 13
1
A random insertion position in a vector
A student asked me about simulation he is doing. This simulation presented an interesting R programming puzzle that we did solve but I am not happy with the solution. I feel there should be a better way of doing this. Briefly, he is simulating births and deaths in a linear array of cells. Births and deaths are required to alternate. For a birth, one of the cells is selected at random to be the
2003 Jul 21
1
RODBC: problem saving a new table in an "Excel database"
Hi I am using package RODBC version 1.0-1 under R version 1.7.1 on Windows XP Pro. I am having problems writing a new table to an (Excel) database using sqlSave. I connect to an empty Excel spreadsheet using odbcConnectExcel (which, I believe, uses the Microsoft Excel Driver DSN). Then I try and save a new table to the database(spreadsheet) using SqlSave, but obtain an error message. Below is