Please help- deleting rows containing a specific value from a large set of data
Hi, I’m doing a project for a class at my university and need to clean up some data. For this data, any missing data is put in as “-9999”. I need to delete all rows that contain -9999, but can’t figure out how to do it. It’s an insane amount of data, there’s over 100,000 rows and the columns go up to HE, so it’s not reasonable to do manually. Is there a function that can help me do this?
Hi, I’m doing a project for a class at my university and need to clean up some data. For this data, any missing data is put in as “-9999”. I need to delete all rows that contain -9999, but can’t figure out how to do it. It’s an insane amount of data, there’s over 100,000 rows and the columns go up to HE, so it’s not reasonable to do manually. Is there a function that can help me do this? Read More