dataframe - Dataset uploaded and verified, but cannot use read.csv - Stack Overflow

I have uploaded a csv I created. This dataset is visible in Kaggle under "My datasets" - I can open and inspect it.

I have tried various ways of linking a dataset to my notebook.

• clicking the uploaded dataset in the Datasets tab, then selecting "New Workbook"
• creating a notebook, then uploading the dataset
• creating a notebook, then Add Input, and selecting my existing uploaded dataset

I then ran the tidyverse and readr libraries in the Notebook, and they loaded. However, I'm getting stuck at the read.csv.

I have tried all these:

1. df \<-read.csv("filename.csv")
2. df \<-read.csv(/%22filename.csv%22)

Any combination of the above, with and without " " ...

Errors I'm getting:

For 1.

Warning message in file(file, "rt"): “cannot open file 'filename.csv': No such file or directory” Error in file(file, "rt"): cannot open the connection Traceback:

1. read.csv("filename.csv")
2. read.table(file = file, header = header, sep = sep, quote = quote, . dec = dec, fill = fill, comment.char = comment.char, ...)
3. file(file, "rt")

For 2.

Error in parse(text = x, srcfile = src): <text>:1:29: unexpected '/' 1: StudentDep <-read.csv(https:/ ^ Traceback:

I have uploaded a csv I created. This dataset is visible in Kaggle under "My datasets" - I can open and inspect it.

I have tried various ways of linking a dataset to my notebook.

• clicking the uploaded dataset in the Datasets tab, then selecting "New Workbook"
• creating a notebook, then uploading the dataset
• creating a notebook, then Add Input, and selecting my existing uploaded dataset

I then ran the tidyverse and readr libraries in the Notebook, and they loaded. However, I'm getting stuck at the read.csv.

I have tried all these:

1. df \<-read.csv("filename.csv")
2. df \<-read.csv(https://www.kaggle.com/datasets/myname/foldername/%22filename.csv%22)

Any combination of the above, with and without " " ...

Errors I'm getting:

For 1.

Warning message in file(file, "rt"): “cannot open file 'filename.csv': No such file or directory” Error in file(file, "rt"): cannot open the connection Traceback:

1. read.csv("filename.csv")
2. read.table(file = file, header = header, sep = sep, quote = quote, . dec = dec, fill = fill, comment.char = comment.char, ...)
3. file(file, "rt")

For 2.

Error in parse(text = x, srcfile = src): <text>:1:29: unexpected '/' 1: StudentDep <-read.csv(https:/ ^ Traceback:

• dataframe
• dataset
• kaggle
• read.csv

Share Follow asked 15 hours ago Heike VauHeike Vau 1

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

To load a dataset in a Kaggle notebook in R:

mydatapath = "/kaggle/input/datasetname/datasetfile.csv"
df <-read.csv(mydatapath)

To know exactly the dataset path (mydatapath variable), look on the right where is written "Datasets" then click on the small black triangle next to your dataset name. A list of files will appear. Click on the icon looking like a stack of papers/rectangles on the right of your csv file and use CTRL+V in your notebook to paste the file path.