search for: myexcelfile

Tom: Supposse your Excel file is named "myExcelFile" Open myExcelFile and SaveAs "myExcelFile.csv" or "myExcelFile.txt" Then go to the RConsole and type: #Option # 1 mydata <- read.csv("PathTomyExcelFile.csv",header=T) mydata # You should be able to see your dataset in R # Option # 2 # If you saved your Exce...

Dear List, I have a table i have read into R: Name Yes/No John 0 Frank 1 Ann 0 James 1 Alex 1 etc - 800 different times. What i want to do is shuffle yes/no and randomly re-assign them to the name. I have used sample() and permute(), however there is no way to do this 1000 times. Furthermore, i want to copy the data into a excel spreadsheet in the same order as the data was input so i can