Saturday, December 21, 2013

Part 1: Simple calculations with R

Preparing files for usage with R


In the first part of this tutorial, you learn the simple executions with R. These are actions such as importing
files, simple calculations with data and visualitsation of data with simple descriptive statistics.

For the first part of this manual, the file "Flowersales.xls' is used. R may, without special installed packages,
not read xls files (Excel files). This file could be downloaded by clicking on the following Flowersales.xls . For this reason an .xls-file should be saved as a .csv-file, the default file type
that could be read by R. Converting an .xls-file into a .csv-file is quite simple with OpenOffice:

Figure 1: Converting an Excel format into a CSV format
Figure 1: Converting an xls-file into a csv-file

Figure 2: Determining the seperator of the csv file
Figure 2: Determining the seperator of the csv-file

Flowersales.xls is now converted into a csv-file and now has the name Flowersales.csv. The file Flowersales.xls remains in your folder.




No comments:

Post a Comment