Thursday, January 07, 2016

R: 'file' must be a character string or connection

I was using Shiny app in R and I was trying to read a file using fileInput control but I faced the following error:

Listening on
Error in read.table(file = file, header = header, sep = sep, quote = quote,  :
  'file' must be a character string or connection

Problem code:

file <- read.csv(file=input$file1,head=TRUE,sep=",", stringsAsFactors=FALSE)
csv <- str(file)


inFile <- input$file1
if (is.null(inFile))

csv <- read.csv(inFile$datapath, header=TRUE, sep=",")

The resolution was to use datapath property of the input file and not the file itself.


  1. This is a broad scope of dialects and toolboxs utilized by Data Scientists. ExcelR Data Science Courses

  2. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.

    Digital marketing course mumbai

  3. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
    Data science Interview Questions
    Data Science Course