Import csv excel file in R

0 votes
In file(file, "rt") : 'cannot open file c:/Users/toshıba pc/Desktop/Book1.csv': No such file or directory

Although the syntax looks correct; My R program cannot import .csv file to the R console with a warning

read.table("c:/Users/toshıba pc/Desktop/Book1.csv", header=TRUE, sep=",", row.names="id")
Nov 5, 2018 in Data Analytics by Hannah
• 14,070 points
56 views

2 answers to this question.

0 votes

Be sure the file is in the working directory, next, try with read.csv2() function, like this:

df<-read.csv2("File_path.csv",header=T,stringsAsFactors=FALSE, fileEncoding="latin1",sep=";")
answered Nov 5, 2018 by Kalgi
• 40,480 points
0 votes
Hi. Check out your filename and the directory as given in the path as @kalgi said.

Try using read.csv( ) as the file is a CSV file.
answered Aug 22 by anonymous
• 26,020 points

Related Questions In Data Analytics

0 votes
1 answer

How to convert a text mining termDocumentMatrix into excel or csv in R?

By assuming that all the values are ...READ MORE

answered Apr 5, 2018 in Data Analytics by DeepCoder786
• 1,700 points
119 views
0 votes
1 answer

How can I read a .csv file in R language?

read.csv () function is used to read ...READ MORE

answered Jun 11, 2018 in Data Analytics by zombie
• 3,690 points
38 views
0 votes
1 answer

Load CSV File in R

Loading a .csv file in R is ...READ MORE

answered Jul 27, 2018 in Data Analytics by darklord
• 6,140 points
218 views
0 votes
1 answer

How can I import a file in R without giving the destination/file path to the specified file?

You can use the window explorer to ...READ MORE

answered Aug 28, 2018 in Data Analytics by Anmol
• 3,620 points

edited Aug 28, 2018 by Vardhan 46 views
0 votes
2 answers

How to sort a data frame by columns in R?

You can use dplyr function arrange() like ...READ MORE

answered Aug 21 in Data Analytics by anonymous
• 26,020 points
121 views
0 votes
1 answer

How can I perform word stemming in R

The tm package in R provides the stemDocument() function to stem the ...READ MORE

answered Aug 20, 2018 in Data Analytics by Anmol
• 3,620 points
55 views
0 votes
1 answer

How to know the type of an object?

To find the type of an object ...READ MORE

answered Sep 19, 2018 in Data Analytics by Anmol
• 3,620 points
33 views
0 votes
1 answer

Is a GUI available for some basic csv file edits?

You can have a look at this csved ...READ MORE

answered Nov 14, 2018 in Data Analytics by Maverick
• 10,040 points
37 views
0 votes
1 answer
0 votes
1 answer

How do I import document files in R programming

Try the following: read.table("~/SMSSpamCollection", header=TRUE, sep="\t") Change "~/" to the "ptah/to/your/file/" Mess around ...READ MORE

answered Nov 5, 2018 in Data Analytics by Kalgi
• 40,480 points
29 views