Delete row in dataframe R

Question

I used

milsa <- edit(data.frame())

To open the R Data Editor and now I can type the data of my table. My problem is: my table has 36 rows, but for some reason I have 39 rows appearing in the program (the 3 additional rows are all filled with NA). When I try to use:

length(civil)

I'm getting 39 instead of 36. How can I solve this? I am trying to use fix(milsa) but it can't delete the additional rows.

PS: Civil is a variable of milsa.

Please save the RStudio tag for RStudio-specific problems, for example if you have R code that works on the R command line or R Gui, but doesn't work in RStudio. — Gregor Thomas
– Gregor Thomas, Commented May 18, 2018 at 18:41

Dodge · Accepted Answer · 2018-05-18 18:42:22Z

1

Subset with the index:

You can reassign the data.frame to itself with only the rows you want to keep.

milsa <- milsa[1:36,]

Here is a LINK to a quick tutorial for your reference

edited May 18, 2018 at 18:42

answered May 18, 2018 at 18:28

Dodge

3,3393 gold badges21 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Callie · Accepted Answer · 2018-05-18 21:41:37Z

0

To delete specific rows

milsa <- milsa[-c(row_num1, row_num2, row_num3), ]

To delete rows containing one or more NA's

milsa <- na.omit(milsa)

answered May 18, 2018 at 21:41

Callie

3431 silver badge10 bronze badges

Collectives™ on Stack Overflow

Delete row in dataframe R

2 Answers 2

Subset with the index:

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Subset with the index:

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related