Data Analysis > Reading Data in R > Reading CSV Data File

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:

1. Setting your folder as a default folder:

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 csv file

      data=read.csv(“Cheat.csv”, header=TRUE)

Now you can Check:

To see some data along with column’s  head:

   >data

To see some data along with column’s  head:

>head(data)

 

 

No More

Next

Reading Microsoft Excel Data File

Feedback

Submit