New answers tagged

1

I'm going to answer this question even though it was posted 3 years and 4 months ago. titanic = ExampleData[{"Dataset", "Titanic"}] Inserting "Missing" in empty cells of titanic Dataset: fillmissingentries = List @@@ Normal@titanic /. Missing[] -> "Missing"; Look at the resulting Dataset: Dataset[fillmissingentries] Re-inserting the column headings ...


3

Try mydata2 = Import["gstar.xlsx", {"Data", 1, All, ;; 2}]; Interpolation[mydata2] {"Data", sheetlist, rowlist, columnlist} specification extracts data from sheets in sheetlist the rows in rowlist and columns in columnlist. So {"Data", 1, All, ;; 2} says "get the array of data in columns 1 and 2 form all rows of sheet 1". See XLSX >> Import ...


Top 50 recent answers are included