I'm working with a huge datafile (about 400,000 rows and 8 columns) in Libre Office. I need to get rid of certain rows so I selected all cells with the desired value (with
Find & Replace) and tried
Edit > Delete Cells > Delete entire row(s). The screen is fading and still, after some 15 minutes it doesn't get me anywhere (screen fades to grey, program does not respond). Selecting "only" some thousand rows resulted in the same.
Is there an alternate way to get rid of thousands of rows at the same time? Solutions in Libre Office, Gnumeric or R or any other open software are very welcome.
The data is organised in this way (small sample):
Region, TimePeriod, etc, ValueTons
Cyprus, JanDec 2000, somecodes, 0
Cyprus, JanDec 2001, somecodes, 74.2
Cyprus, JanDec 2002, somecodes, 68.7
Cyprus, JanDec 2003, somecodes, 59.1
Cyprus, JanDec 2004, somecodes, 50.3
Cyprus, JanDec 2005, somecodes, 71.1
Cyprus, JanDec 2006, somecodes, 45.7
Cyprus, JanDec 2007, somecodes, 45.7
Cyprus, JanDec 2008, somecodes, 50.4
Cyprus, JanDec 2009, somecodes, 80
Cyprus, JanDec 2010, somecodes, 47.2
Cyprus, JanDec 2011, somecodes, 44.1
Spain, JanDec 2000, somecodes, 5
The time period ranges from 2000 to 2011. I need to get rid of all rows containing the years 2000 to 2005 and 2011.