Stacks Image 20108

For Academics

Data import export

Notes on basic import and export in R.

Import

mydata <- read.table("/Users/useraccount/Desktop/R/inputFile.txt", header=T)

Importing comma separated value files can be useful, because they retain gaps in column names. This is useful if the column names are used in graphs.

mydata <- read.csv("/Users/useraccount/Desktop/R/inputFile.csv", header=T)

I tend to copy data files to the desktop from wherever I store them. It makes the code work regardless of where the data end up.

Inspection

Quickly check the first rows of the data, useful if the data file is large

head(mydata)

Print the first values of the data to check data are factors or numerals, and generally that the import is as expected.

str(mydata)

Numeric variables may be read as factors, for example if they include NA values.

To convert a numeric variable that was imported erroneously as a factor

mydata$copLatency <- as.numeric(as.character(mydata$copLatency))

Export

To export a data.frame 'frameName' as a txt file:

write.table(dataFrameName, file="out.txt", quote=F, row.names=F, sep="\t")
Previous Post 3 / 10 Post

Tag:

Sex chromosome papers RSS


Chromosome-level genome assembly and sex chromosome identification of the pink stem borer, Sesamia inferens (Lepidoptera: Noctuidae)
Link

The genome sequence of a ground beetle, Ophonus ardosiacus (Lutshnik, 1922)
Link

The genome sequence of a hoverfly, Pocota personata (Harris, 1780)
Link