How to Use read.delim in R?

How to Read a CSV from URL into R?

Last Updated : 29 Dec, 2021

In this article, we are going to see how to read CSV files from URL using R Programming Language.

Method 1: Using Base R

Here we are using read.csv() methods, which is an inbuilt function in R programming. This function is similar to Python because it read the CSV file and returns the data into dataframe.

Syntax:

read.csv(URL)

Example: Read a CSV from URL

R

# importing Data
data <- read.csv('https://www.stats.govt.nz/assets/Uploads\
/Annual-enterprise-survey/Annual-enterprise-survey-2020-\
financial-year-provisional/Download-data/annual-enterprise\
-survey-2020-financial-year-provisional-csv.csv')
 
# display top 5 row
head(data)

Output:

Method 2: Using data.table

This package is capable to read the data from URL. Basically data.table is used for data manipulation operations such as subset, group, update, join, etc. This package contains fread() function that takes URL as input to get the job done.

Syntax:

fread(URL)

Example: Read CSV from URL

R

# importing Data
data <- read.fread('https://www.stats.govt.nz/assets/Uploads\
/Annual-enterprise-survey/Annual-enterprise-survey-2020-\
financial-year-provisional/Download-data/annual-enterprise\
-survey-2020-financial-year-provisional-csv.csv')
 
# display top 5 row
head(data)

Output:

Example 2: Read CSV from URL

R

library(data.table)
 
# import data from URL
data <- fread('https://www.stats.govt.nz/assets/Uploads
/Annual-enterprise-survey/Annual-enterprise-survey-2020-
financial-year-provisional/Download-data/annual-enterprise
-survey-2020-financial-year-provisional-csv.csv')
 
# Display first five rows
head(data)

Output:

How to Use read.delim in R?

kumar_satyam

Improve

Article Tags :

Similar Reads

How to Read Zip Files into R

In the R Programming Language Zip files are compressed archives that store one or more files or directories in compressed format. They are commonly used to package and distribute files, particularly when working with huge datasets or many files. Zip files not only conserve disc space but also facili

How to Read XML File in R?

XML (Extensible Markup Language) can be a widely used format for storing and transporting data. It can be structured and allowing the both humans and machines to easily parse and interpret the data it contains. In R programming, reading and processing XML files is straightforward thanks to the vario

How to Read Many ASCII Files into R?

Reading data from ASCII files into R is a common task in data analysis and statistical computing. ASCII files, known for their simplicity and wide compatibility, often contain text data that can be easily processed in R. Here we read multiple ASCII files into R Programming Language. What are ASCII F

How to Use read.delim in R?

In this article, we will learn how to use the read.delim() in the R Programming Language. Example 1: Using read.delim() function to read a space-separated text file The read.delim() function is used to read delimited text files in the R Language. It doesn't need any external package to work. This fu

How to read excel file in R ?

We may work with structured data from spreadsheets, take advantage of R's capabilities for data analysis and manipulation, and incorporate Excel data into other R processes and packages by reading Excel files in R. The readxl package offers a simple and effective method for reading Excel files into

How to Read and Write CSV File in Scala?

Data processing and analysis in Scala mostly require dealing with CSV (Comma Separated Values) files. CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Each line of a CSV file is plain text, representing a data row, with values separated by commas (,). Readin

How to Import a CSV File into R ?

A CSV file is used to store contents in a tabular-like format, which is organized in the form of rows and columns. The column values in each row are separated by a delimiter string. The CSV files can be loaded into the working space and worked using both in-built methods and external package imports

How to Read CSV File in Ruby?

It is common to have tabular data stored in CSV (Comma Separated Values) files. In Ruby, one can handle CSV files without much ado because the built-in libraries make it easy to do so. This article focuses on discussing the ways to read a CSV file in Ruby. Approach to Read CSV Files in Ruby?There ar

How Do I Add a URL to R Markdown?

R Markdown is a powerful tool for creating dynamic reports and documents in the R Programming Language. One common task in creating these documents is adding URLs. This article explains how to easily include URLs in your R Markdown files, whether for linking to external websites or including clickab

How to plot a graph in R using CSV file ?

To plot a graph in R using a CSV file, we need a CSV file with two-column, the values in the first column will be considered as the points at the x-axis and the values in the second column will be considered as the points at the y-axis. In this article, we will be looking at the way to plot a graph