search for: jiamei

Hi everyone, I am not new to R, but its been over a year since I've used it, so I don't remember how to do some things. I have a data set (in excel currently, but will be converted to text), that has date, country and price, with a price for every country for every date. I need to find the mean and median of the interval between price changes for each country and the mean and median

Hi, I've completely forgotten how to do R, and it seems I can't even load simple files correctly. I have two tab deliminated text files (attached, these were test files of the larger data files I'm trying to work with) that I am trying to load into R so that I can merge them. They were originally excel files but I used "saved as" to reformat to text. I don't know if

Hi, I know this can be done in Stata (which is quite messy) but I wanted to know if it can be done in R. So lets say I have a merged data set (I used the merge function by date for the attached two files), where all the missing values are filled with NAs (which is what the all.x=TRUE does). Is there any way to replace those NAs with the value of the latest row that contains a value? For

Hi, I've merged the attached two data sets, generating a final merged data set, but when I review this merged data, the dates are not in the correct order. I know that this can be solved by using something like fmt<-"%m/%d/%y", but where should this go in the commands below? > Countrydata<-read.table("Desktop/R/Countrydata.txt", head=T, sep="\t")

Hi everyone, I'm trying to break down data into intervals because I need to analyze data according to the intervals between each change in value. What I have done is merged the attached data files, and filled in the missing values this way: > fmt<-"%m/%d/%y" > dd<-read.csv("Desktop/R/CDSdate.txt") > dd$Date<-as.Date(dd$Date, fmt) >library(zoo)

Hi everyone, A few days back Jim helped with out, helping me find an automated way of determining the mean and median of intervals between price changes. However, a new set of data I have is no longer in the same format. CDSmod is the file that was used with this code: x <- read.csv('/cdsmod.csv', as.is=TRUE, check.names=FALSE) x$Date <- as.Date(x$Date, "%m/%d/%Y")