[R] Remove line from data file

Parkhurst, David p@rkhur@ @end|ng |rom |nd|@n@@edu
Sun Sep 18 14:48:47 CEST 2022

Thank you for your reply.  I meant from the dataframe, but that�s one of the terms I had forgotten.  I created that from read.csv, the csv file coming from Excel.  Last night I went ahead and made the change(s) using Excel.

For future reference, when I look at your solutions below, what do you mean by �value to delete�?  Could that just be a row number?  I was wanting to delete something like the 18th row in the dataframe?

From: CALUM POLWART <polc1410 using gmail.com>
Date: Sunday, September 18, 2022 at 7:25 AM
To: Parkhurst, David <parkhurs using indiana.edu>
Cc: R-help using r-project.org <R-help using r-project.org>
Subject: Re: [R] Remove line from data file
From the file? Or the data frame once its loaded?

What format is the file? CSV?

Do you know the line that needs deleted?

mydf <- read.csv("myfile.csv")

mydf2 <- mydf[-columnName == "valuetodelete", ]
# Note the - infront of column name
# or perhaps columnName != "value to delete", ]

write.csv(mydf2, "mydeletedfile.csv")

On Sun, 18 Sep 2022, 10:33 Parkhurst, David, <parkhurs using indiana.edu<mailto:parkhurs using indiana.edu>> wrote:
I�ve been retired since �06 and have forgotten most of R.  Now I have a use for it.  I�ve created a data file and need to delete one row from it.  How do I do that?

DFP (iPad)
R-help using r-project.org<mailto:R-help using r-project.org> mailing list -- To UNSUBSCRIBE and more, see
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

	[[alternative HTML version deleted]]

More information about the R-help mailing list