How to Delete DataFrames in R?
In this article, we will discuss how to delete Dataframes in R Programming Language. A DataFrame is a two-dimensional data structure that can store data in rows and columns, we can create a dataframe by using data.frame() function
Create Dataframe for demonstration:
R
data1 = data.frame (names= c ( "sravan" , "ojaswi" ),
address= c ( "delhi" , "hyd" ))
data2 = data.frame (names= c ( "sravan" , "ojaswi" ),
marks= c (98,90))
data3 = data.frame (names= c ( "sravan" , "ojaswi" ),
age= c (23,17))
print (data1)
print (data2)
print (data3)
|
Output:
names address
1 sravan delhi
2 ojaswi hyd
names marks
1 sravan 98
2 ojaswi 90
names age
1 sravan 23
2 ojaswi 17
Before deleting the dataframe we have to check how many and what are the dataframes exists, we can get this by using ls() function. This will return the current variables that exists in an environment
Syntax: ls()
Let’s check:
R
data1 = data.frame (names= c ( "sravan" , "ojaswi" ),
address= c ( "delhi" , "hyd" ))
data2 = data.frame (names= c ( "sravan" , "ojaswi" ),
marks= c (98,90))
data3 = data.frame (names= c ( "sravan" , "ojaswi" ),
age= c (23,17))
ls ()
|
Output:
[1] "data1" "data2" "data3"
Method 1: Using rm() methods
This method stands for remove. This method will remove the given dataframe
Syntax: rm(dataframe)
where dataframe is the name of the existing dataframe
Example: R program to create three dataframes and delete two dataframes
R
data1 = data.frame (names= c ( "sravan" , "ojaswi" ),
address= c ( "delhi" , "hyd" ))
data2 = data.frame (names= c ( "sravan" , "ojaswi" ),
marks= c (98,90))
data3 = data.frame (names= c ( "sravan" , "ojaswi" ),
age= c (23,17))
rm (data1)
rm (data2)
ls ()
|
Output:
[1] "data3"
We can also delete multiple dataframes separated by comma using rm() function:
Syntax: rm(“dataframe1″,”datafame2″,……,”dataframe n”)
R
data1 = data.frame (names= c ( "sravan" , "ojaswi" ),
address= c ( "delhi" , "hyd" ))
data2 = data.frame (names= c ( "sravan" , "ojaswi" ),
marks= c (98,90))
data3 = data.frame (names= c ( "sravan" , "ojaswi" ),
age= c (23,17))
rm ( "data1" , "data2" )
ls ()
|
Output:
[1] "data3"
We can also delete all dataframes by using sapply()
Syntax: rm(list=ls(all=TRUE)[sapply(mget(ls(all=TRUE)), class) == “data.frame”])
R
data1= data.frame (names= c ( "sravan" , "ojaswi" ),
address= c ( "delhi" , "hyd" ))
data2 = data.frame (names= c ( "sravan" , "ojaswi" ),
marks= c (98,90))
data3 = data.frame (names= c ( "sravan" , "ojaswi" ),
age= c (23,17))
rm (list= ls (all= TRUE )[ sapply ( mget ( ls (all= TRUE )),
class) == "data.frame" ])
ls ()
|
Output:
character(0)
Method 2: Using grepl() function
This function will delete all the dataframes existing in the current environment used with rm().
Syntax: rm(list = ls()[grepl(“pattern”, ls())])
where, pattern is all dataframes starting letter variables
Example:
R
data1 = data.frame (names= c ( "sravan" , "ojaswi" ),
address= c ( "delhi" , "hyd" ))
data2 = data.frame (names= c ( "sravan" , "ojaswi" ),
marks= c (98,90))
data3 = data.frame (names= c ( "sravan" , "ojaswi" ),
age= c (23,17))
rm (list = ls ()[ grepl ( "data" , ls ())])
ls ()
|
Output:
character(0)
Last Updated :
06 Feb, 2023
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...