I'm attempting to do a code for Wolfram Mathematica
I am uploading an Excel file that has a huge number of characters and multiple sheets to enter.
The issue is the import is set up as a table/grid which is fine, but in this table/grid there are a variety of non-integer values (null values) that don't show up as null values, I need to find a way to make all the null values disappear and to delete whatever row they are in (across).
For example, suppose there is a null value in column 7 row 13, I want to automatically delete that whole row because it taints the data set. I'd prefer to have an automatic way to do this because the 7 sheets have about 2300 ~ 4000 rows each, and it would be difficult to carry out the deletion by hand. The rows with no input values are specified as non-0 and non-values as well, which makes getting any sort of mathematical analysis an issue.
Mycode:
Boston01a = Import["Boston-v01.xlsx", {"Data", 1}];
textStyle @
Row[{"Number of entries in ", " file: ", Length[Boston01a]}]
timesStyle10 @
Pane[
Grid[Boston01a, Frame -> All],
ImageSize -> {All, 200}, Scrollbars -> True]
(*Boston data set 1 data specification*)
Bo1 = Drop[Boston01a, 1, 2];
timesStyle10 @
Pane[
Grid[Bo1, Frame -> All],
ImageSize -> {All, 200}, Scrollbars -> True];
Select
. You merely have to create a function that eats a row and spits out wether the row should be selected (return value of function should beTrue
) or it should be ignored (return valueFalse
). MaybeNumericQ
can also be of help. $\endgroup$ – Henrik Schumacher Mar 23 '18 at 20:04