Suppose we have to load the following data file in r. Your data may be in CSV, or in XLS, or in TXT format. Then the following ways you have to follow:
|
id |
Refund |
gender |
marital |
income |
cheat |
|
1 |
Yes |
M |
Married |
1200 |
No |
|
2 |
No |
F |
Married |
800 |
Yes |
|
3 |
No |
M |
Single |
1500 |
Yes |
|
4 |
No |
F |
Single |
600 |
No |
|
5 |
Yes |
F |
Married |
500 |
No |
|
6 |
Yes |
M |
Divorced |
800 |
Yes |
|
7 |
No |
M |
Single |
900 |
No |
|
8 |
Yes |
M |
Divorced |
1000 |
Yes |
|
9 |
Yes |
M |
Married |
1200 |
No |
|
10 |
No |
F |
Divorced |
1400 |
No |
|
11 |
No |
M |
Single |
400 |
No |
|
12 |
No |
M |
Married |
300 |
Yes |
|
13 |
No |
F |
Married |
700 |
Yes |
|
14 |
Yes |
F |
Married |
1000 |
Yes |
|
15 |
Yes |
M |
Single |
1100 |
Yes |
Suppose file name is Cheat.csv . this file is located in the folder “Users/mdfazlulkarimpatwary/Documents/Rtraining"
Steps:
You need to copy your file location and note your file name. Then check your current default folder. Now make your folder as default folder so that all read and write command will apply only on that folder.
> getwd()
[1] "/Users/mdfazlulkarimpatwary"
> setwd("/Users/mdfazlulkarimpatwary/documents/Rtraining/")
> getwd()
[1] "/Users/mdfazlulkarimpatwary/Documents/Rtraining"
2. Now Reading SPSS file
Assume that we have a data file located at my own folder named “h1.sav”.
library(foreign)
file.choose()
datafile = file.choose()
dataset = read.spss(datafile, to.data.frame=TRUE)
//dataset = read.spss("h1.sav", to.data.frame=TRUE)
>head(dataset)
You will see the data file
Statlearner
Statlearner