Replace Blank by NA in R DataFrame

Replace Inf with NA in Dataframe in R

Last Updated : 27 Sep, 2021

In this article, we will discuss how to replace Inf (Infinity) with NA in Dataframe in R Programming Language.

Create a dataframe with for demonstration:

R

# create a dataframe with 3 columns and 5 rows
data=data.frame(column1 = c(Inf, 2, 3, 4, 5),  
                column2 = c(1, Inf, 1, Inf, 1),
                column3 = c(1,2,3,Inf,Inf))

# display dataframe
print(data)

Output:

So we can replace Inf with NA by using lapply() function, we have to create our own function to replace Inf with NA and then pass that function to lapply() through do.call method.

Function Syntax:

function(value) 
replace(value, is.infinite(value), 
NA)

Where value is the input value and replace() is used to replace the value to NA if it is infinite.

Example 1: R program to replace Inf value with NA in the dataframe

R

# create a dataframe with 3 columns and 5 rows
data=data.frame(column1 = c(Inf, 2, 3, 4, 5), 
                column2= c(1, Inf, 1, Inf, 1),
                column3=c(1,2,3,Inf,Inf))

# actual dataframe
print(data)

# replace inf with NA
final=do.call(data.frame, lapply
              (data, function(value) replace
               (value, is.infinite(value),NA)))

# display
print(final)

Output:

Example 2:

R

# create a dataframe with 5 columns and 5 rows
data=data.frame(column1 = c(Inf, 2, 3, 4, 5),
                column2= c(1, Inf, 1, Inf, 1),
                column3=c(1,2,3,Inf,Inf),
                column4=c(Inf,Inf,Inf,3,4),
                column5=c(1,2,3,4,Inf))

# actual dataframe
print(data)

# replace inf with NA
final=do.call(data.frame,lapply
              (data, function(value) replace
               (value, is.infinite(value),NA)))

# display
print(final)

Output:

Replace Blank by NA in R DataFrame

gottumukkalabobby

Improve

Article Tags :

Similar Reads

Replace 0 with NA in R DataFrame

In this article, we are going to discuss how to replace 0 with NA values in dataframe in R Programming Language. NA stands for Null values which can represent Null data / Null elements in a dataframe. The task can be achieved by first defining a dataframe that contains 0 as values. Then we can repla

Replace NA values with zeros in R DataFrame

In this article, we will discuss how to replace NA values with zeros in DataFrame in R Programming Language. The NA value in a data frame can be replaced by 0 using the following functions. Method 1: using is.na() function is.na() is an in-built function in R, which is used to evaluate a value at a

Replace Spaces in Column Names in R DataFrame

In this article, we will replace spaces in column names of a dataframe in R Programming Language. Let's create a Dataframe with 4 columns with 3 rows: [GFGTABS] R # create a dataframe with 4 columns and 3 rows data = data.frame("web technologies" = c("php","html","

Replace Blank by NA in R DataFrame

In this article, we are going to see how to replace Blank space with NA in dataframe in R Programming Language. Example 1: R program to replace blank by NA in dataframe We will replace the empty cells using a logical condition based on the "==" operator. Syntax: dataframe[dataframe == ""] <- NA [

Create DataFrame with Spaces in Column Names in R

In this article, we will see how to create a DataFrame with spaces in column names in R Programming Language. Method 1: Using check.names attribute The data.frame() method in R can be used to create a data frame with individual rows and columns in R. This method contains an attribute check.names, wh

Repeat Rows of DataFrame N Times in R

In this article, we will discuss how to repeat rows of Dataframe for a given number of times using R programming language.Â Method 1 : Using replicate() method A replication factor is declared to define the number of times the data frame rows are to be repeated. The do.call() method in R is used to

Replace Character Value with NA in R

In this article, we are going to see how to replace character value with NA in R Programming Language. We can replace a character value with NA in a vector and in a dataframe. Example 1: Replace Character Value with NA in vector In a vector, we can replace it by using the indexing operation. Syntax:

Remove rows with NA in one column of R DataFrame

Columns of DataFrame in R Programming Language can have empty values represented by NA. In this article, we are going to see how to remove rows with NA in one column. We will see various approaches to remove rows with NA values. Approach Create a data frameSelect the column based on which rows are t

Find columns and rows with NA in R DataFrame

A data frame comprises cells, called data elements arranged in the form of a table of rows and columns. A data frame can have data elements belonging to different data types as well as missing values, denoted by NA.Â Approach Declare data frameUse function to get values to get NA valuesStore positio

Merge Two Unequal DataFrames and Replace NA with 0 in R

In this article we are going to merge two unequal dataframes and then replace NA values in the resultant dataframe with 0 using R programming language. Dataframes in use: Merging the dataframes We can merge the two dataframes by using merge() function. Syntax: merge(dataframe1, dataframe2, Â by = "c